投稿時間:2022-05-15 21:16:02 RSSフィード2022-05-15 21:00 分まとめ(20件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
python	Pythonタグが付けられた新着投稿 - Qiita	streamlitを用いて開発したアプリをデプロイするまでの手順	https://qiita.com/Daiki-0624/items/7366892cbe4a19397022	requirement	2022-05-15 20:46:30
js	JavaScriptタグが付けられた新着投稿 - Qiita	JavaScript で table 要素を CSV ファイルに変換する	https://qiita.com/QUANON/items/8f21111181c2699681ca	javascript	2022-05-15 20:48:06
海外TECH	Ars Technica	The tech sector teardown is more catharsis than crisis	https://arstechnica.com/?p=1854178	crisisthe	2022-05-15 11:00:52
海外TECH	MakeUseOf	The 4 Best Chrome Extensions for Screenshots and Screen Recorders	https://www.makeuseof.com/best-chrome-extensions-screenshots-recorders/	The Best Chrome Extensions for Screenshots and Screen RecordersTaking screenshots can be a surprising lengthy process and screen recordings are even harder Here are four of the best Chrome extensions to help	2022-05-15 11:30:14
海外TECH	DEV Community	How to Choose The Right Database for Your Application	https://dev.to/apoorvtyagi/how-to-choose-the-right-database-for-your-application-1dk3	How to Choose The Right Database for Your Application IntroductionChoosing which database to use is one of the most important decisions you can make when starting working on a new app or website If you realize down the line that you ve made the wrong choice migrating to another database is very costly and sometimes more complex to do with zero downtime Taking time to make an informed choice of database technology upfront can be a valuable early decision for your application A bonus reason for why this is important is because understanding the different DBs and their properties amp which one to choose over the other is quite commonly asked in job interviews Each database technology has advantages and disadvantages Cloud providers like Amazon offer various database and storage options making it harder to figure out which one is the right one Relational databases have been a primary data storage mechanism for a long time Non relational databases have existed since the s but recently gained traction with popular options such as MongoDB In this article we will go through the factors you should consider while choosing any database The language determines the databaseFirst things first The language or the technology you are going to use never determines the database We ve grown accustomed to technology stacks such as MERN MongoDB Express React Node js amp LAMP Linux Apache MySQL PHP There are certain reasons why these stacks evolved But don t assume these are the rules You can use a MongoDB database in your Java project You can use MySQL in your Node js You might not have found as many tutorials but it s your requirements that should determine the database type amp not the language Understanding the TradeoffLet s now understand the basic tradeoffs we need to deal with while making the DB decision The reason that we have many database options available today is due to the CAP Theorem CAP stands for Consistency Availability and Partition tolerance Consistency means that any read request will return the most recent write Availability means all non failing nodes are available for queries amp must respond in a reasonable amount of time Partition Tolerance means that the system will continue to work despite node failures Only two of these requirements can be fulfilled at any given time If you re building a distributed app then partition tolerance is a must So the choice remains whether we want our database to be highly available or highly consistent Structure of DataIf your data needs to be structured or there is a relation between different types of data that you re going to keep and at the same time you want strict data integrity then a relational database should be a better choice for you For example let s say we are making a student management application where we need to store the information of certain courses and every course needs to be taken by one or more students In this case we can create tables Students and Courses where the value in the Student ID column inside the Courses table points to rows in the Students table by the value of their ID column Apart from this if you want your DB to be ACID compliant for example in cases when you re handling payments and transactions in your application then in that case too you should prefer the SQL based databases because the counterpart i e the NoSQL database offers weak consistency ACID compliance protects the integrity of your data by defining exactly what a transaction is and how it interacts with your database It avoids database tables from becoming out of sync which is super important for financial transactions ACID compliance guarantees the validity of transactions even in the face of errors technology failures disastrous events and more On the other hand if your data requirements aren t clear or if your data is unstructured NoSQL may be your best choice The data you store in a NoSQL database does not need a predefined schema This provides much more flexibility and less upfront planning when managing your database A NoSQL database is a much better fit to store data like article content social media posts sensor data and other types of unstructured data that won t fit neatly into a table NoSQL databases were built with flexibility and scalability in mind and follow the BASE consistency model which means Basic AvailabilityThis means that while the database guarantees the availability of the data the database may fail to obtain the requested data or the data may be in a changing or inconsistent state Soft stateThe state of the database can be changing over time Eventual consistencyThe database will eventually become consistent and data will propagate everywhere at some point in the future The structure of your data is the most important factor in deciding whether to use a SQL or NoSQL database so put a lot of thought into this before making a decision Query PatternsThe next factor to consider is how you ll query your data This is one of the main ways to find the best database for your use caseDo you need retrieval by a single key or by various other parameters Do you also need a fuzzy search on the data Use Non Relational databases if you are going to fetch data by key then all you need is a key value store e g DynamoDB On the other hand if you will require to query many different fields you can choose both Relational DB e g MySQL or Document DB e g MongoDB In case you are looking for fuzzy search query capabilities free text search then search engines like Elasticsearch Which also comes under NoSQL DBs are the best fit But in case your data is nicely structured and organized it is very efficient to query your data with a SQL database SQL is a popular query language that has been around for over years now so it s highly mature and well known It efficiently executes queries and retrieves using JOINs and edits data quickly It s very lightweight and declarative ConsistencyIs strong consistency required read after write or eventual consistency is OK In case you need to read your data right after your write operation i e strong consistency then a Relational database e g MySQL is usually more suited than a Non Relational Database e g MongoDB Performance amp ScalingAll databases performance degrades as the amount of read write traffic increases This is the time when optimizations such as indexing your data and scaling your DB comes into the picture Performance depends on various factors but the overall performance depends to a very large degree on choosing the right implementation for your use case SQL and NoSQL databases scale differently so you ll have to think about how your data set will grow in the future SQL databases scale vertically meaning you ll need to increase the capacity of a single server increasing CPU RAM or SSD to scale your database SQL databases were designed to maintain the integrity of the data so they are best to run on a single server hence they re not easy to scale NoSQL databases are easy to scale horizontally which means you can add more servers as your data grows This is an advantage that NoSQL has over SQL This uncomplicated horizontal scaling nature of non relational databases makes them superior to relational databases as far as availability is concerned The ability of NoSQL databases to scale horizontally has to do with the lack of structure of the data Because NoSQL requires much less structure than SQL each stored object is pretty much self contained Thus objects can be easily stored on multiple servers without having to be linked This is not the case for SQL where each table row and column needs to be related This is also the issue regarding performance and where SQL falls short is scaling As a database grows in size and numbers RDBMS as we have seen requires solutions in vertical scaling This however comes at a significant cost Although many commercial RDBMS products offer horizontal scaling these can also be very expensive and even complex to implement If you predict you will face such an issue then NoSQL is to be considered as many of them were designed specifically to tackle these scale and performance issues ConclusionIn this article we went through the multiple factors you should consider while selecting the type of database In short SQL databases provide great benefits for transactional data whose structure doesn t change frequently or at all and where data integrity is paramount It s also best for fast analytical queries NoSQL databases provide more flexibility and scalability which makes them useful for rapid or iteration development Here s a small summary of what all we have discussed above Reasons to use an SQL databaseWhen you need ACID supportYour application requires a high transaction When only Logical related discrete data requirements comeData integrity is essentialYou don t anticipate a lot of changes in the schema Reasons to use a NoSQL databaseYou store large amounts of data with no structureYou keep getting Unrelated indeterminate or evolving data requirementsSpeed and scalability are critical You are not concerned about Availability and eventual consistency and but data integrity is not your top goal I hope this helps you understand what you need to think about when selecting your database What additional questions do you think about while selecting a database Let me know your thoughts in the comments Starting out in web development Checkout HTML To React The Ultimate GuideThis ebook is a comprehensive guide that teaches you everything you need to know to be a web developer through a ton of easy to understand examples and proven roadmapsIt contains Straight to the point explanationsSimple code examples Interesting project ideas Checklists of secret resourcesA Bonus Interview prepYou can even check out a free sample from this bookand here s the link with off on the original price on the complete book set	2022-05-15 11:57:02
海外TECH	DEV Community	Beautify Github Profile	https://dev.to/rzashakeri/beautify-github-profile-6ld	Beautify Github Profile Hello friends ️how are you If you want to make the look of your github profile more beautiful you have come to the right placeThis repository helps you to have a more beautiful and attractive github profile and you can access a set of tools and guides for beautifying your github profile You can access this repository via the following link github	2022-05-15 11:45:19
海外TECH	DEV Community	What's new in SeaORM 0.8.0	https://dev.to/seaql/whats-new-in-seaorm-080-3cf5	What x s new in SeaORM We are pleased to release SeaORM today Here are some feature highlights Migration Utilities Moved to sea orm migration crate Utilities of SeaORM migration have been moved from sea schema to sea orm migration crate Users are advised to upgrade from older versions with the following steps Bump sea orm version to Replace sea schema dependency with sea orm migration in your migration crate diff title migration Cargo toml dependencies sea schema version sea orm migration version Find and replace use sea schema migration with use sea orm migration in your migration crate use sea schema migration prelude use sea orm migration prelude use sea schema migration use sea orm migration Designed by Chris TsangContributed by Billy Chan Generating New Migration You can create a new migration with the migrate generate subcommand This simplifies the migration process as new migrations no longer need to be added manually A migration file MIGRATION DIR src mYYYYMMDD HHMMSS create product table rs will be created And the migration file will be imported and included in the migrator located at MIGRATION DIR src lib rs sea orm cli migrate generate create product tableProposed amp Contributed by Viktor Bahr Inserting One with Default Insert a row populate with default values Note that the target table should have default values defined for all of its columns let pear fruit ActiveModel Default default all attributes are NotSet The SQL statement MySQL INSERT INTO fruit VALUES SQLite INSERT INTO fruit DEFAULT VALUES PostgreSQL INSERT INTO fruit VALUES DEFAULT RETURNING id name cake id let pear fruit Model pear insert db await Proposed by Crypto VirusContributed by Billy Chan Checking if an ActiveModel is changed You can check whether any field in an ActiveModel is Set with the help of the is changed method let mut fruit fruit ActiveModel Default default assert fruit is changed fruit set fruit Column Name apple into assert fruit is changed Proposed by Karol FuksiewiczContributed by Kirawi Minor Improvements Add max connections option to sea orm cli generate entity subcommand Derive Eq and Clone for DbErrProposed amp Contributed by benlueloSebastien Guillemot Integration ExamplesSeaORM plays well with the other crates in the async ecosystem It can be integrated easily with common RESTful frameworks and also gRPC frameworks check out our new Tonic example to see how it works More examples wanted Rocket ExampleActix ExampleAxum ExamplePoem ExampleGraphQL Examplejsonrpsee ExampleTonic Example Who s using SeaORM The following products are powered by SeaORM Caido A lightweight web security auditing toolkitSensei A Bitcoin lightning node implementationSvix The enterprise ready webhooks serviceSeaORM is the foundation of StarfishQL an experimental graph database and query engine For more projects see Built with SeaORM SponsorOur GitHub Sponsor profile is up If you feel generous a small donation will be greatly appreciated A big shout out to our sponsors Émile FugulinZachary Vander VeldenDean SheatherShane SvellerSakti Dwi CahyonoUnnamed Sponsor CommunitySeaQL is a community driven project We welcome you to participate contribute and together build for Rust s future Here is the roadmap for SeaORM x	2022-05-15 11:36:12
海外TECH	DEV Community	Building a startup | Days 1 - 5	https://dev.to/advikguptadev/building-a-startup-days-1-5-2h97	Building a startup Days Hey guys It s been a pretty productive weekend I did a lot of stuff Starting with the fact that I finally built up the courage to publish my first youtube video which is crazy as I have been planning to do this for so long but never got to it I ll link it down below if you wanna see it Making a first youtube video is a nerve wracking experience but I just made it literally If I kept thinking about it too much then I would have never uploaded it so I just sat down recorded the video and just uploaded it And kept from watching it too many times before uploading because seeing it every time just made me more scared to upload it Also knowing that rarely anyone is gonna the video is great cause then I don t have fear of what will people think of my videos Also I plan to release the pre alpha of the app in some time to get the first response from actual users and work upon that Speaking of the app I made some decent progress the basic user profiles are finished and I can start working on the user connections Adding friends sending messages and all that good stuff Then I ll get to the virtual trading system the part I am most excited about it s one of the more complex features on the site I am pretty excited to build it Thanks for readingUntil next time AdvikMy youtube video My LinksDev toTwitterLinkedInInstagramGithub	2022-05-15 11:30:59
海外TECH	DEV Community	Make a beautiful Connect Wallet Button with RainbowKit and React	https://dev.to/anishde12020/make-a-beautiful-connect-wallet-button-with-rainbowkit-and-react-1mdj	Make a beautiful Connect Wallet Button with RainbowKit and ReactAuthentication in Web is extremely easy but supporting all the wallets and making a nice UI can be painful and time consuming Thankfully there are many libraries which makes this extremely easy as well Today we are going to be looking at adding RainbowKit to a React App What is RainbowKit RainbowKit is a React library that provides us with components to build a Connect Wallet UI in a few lines of code It comes with support for many wallets including Metamask Rainbow Coinbase Wallet WalletConnect and many more It is also extremely customizable and comes with an amazing built in theme RainbowKit uses Ethers js and Wagmi both popular libraries in this space under the hood Also it is developed by the same team behind the beautiful Rainbow Wallet Creating a new Next js AppRun the following command to create a new Next js app note that you can use it on a regular React app too With NPMnpx create next app rainbowkit demo With yarnyarn create next app rainbowkit demoNow move into the project directory and open it in your favorite code editor Adding RainbowKit to our React appRun the following command to install RainbowKit and its peer dependencies With NPMnpm install rainbow me rainbowkit wagmi ethers With yarnyarn add rainbow me rainbowkit wagmi ethersNow add the following code to pages app js import styles globals css import rainbow me rainbowkit styles css import apiProvider configureChains getDefaultWallets RainbowKitProvider from rainbow me rainbowkit import chain createClient WagmiProvider from wagmi const chains provider configureChains chain mainnet chain polygon chain goerli chain rinkeby chain polygonMumbai apiProvider fallback const connectors getDefaultWallets appName My RainbowKit App chains const wagmiClient createClient autoConnect true connectors provider function MyApp Component pageProps return lt WagmiProvider client wagmiClient gt lt RainbowKitProvider chains chains gt lt Component pageProps gt lt RainbowKitProvider gt lt WagmiProvider gt export default MyApp Firstly we import the RainbowKit styles the RainbowKitPovider and other functions to configure our chains and the WagmiProvider Next we configure the chains which we want to support In this example I have added the Ethereum Mainnet Polygon Mainnet Goerli and Rinkeby both Ethereum test networks and the Polygon Mumbai testnet We are using the public fallback RPC URLs for the purpose of this demo for our API providers RainbowKit also lets us specify our own JSON RPC URLs or Alchemy or Infura URLs for our API providers You can see the API Providers documentation here Next we create our wagmiClient passing in the autoConnect and setting it to true Our app will automatically reconnect to the last used connector this way At last we wrap our application with WagmiProvider and RainbowKitProvider Next let us add the Connect Wallet button to our app Replace the code in pages index js with the following import ConnectButton from rainbow me rainbowkit import Head from next head import styles from styles Home module css export default function Home return lt div className styles container gt lt Head gt lt title gt RainbowKit Demo lt title gt lt meta name description content Demo app part of a tutorial on adding RainbowKit to a React application gt lt link rel icon href favicon ico gt lt Head gt lt main className styles main gt lt h className styles title style marginBottom rem gt Welcome to this demo of lt a href gt RainbowKit lt a gt lt h gt lt ConnectButton gt lt main gt lt div gt Now run npm run dev or yarn dev and open up localhost in your browser and you should see this Making it dark mode Time to make sure our eyes don t burn anymore Head over to pages app js and import the midnightTheme function from RainbowKit Alternatively you can also import the darkTheme function a dimmer version of midnight import apiProvider configureChains getDefaultWallets midnightTheme RainbowKitProvider from rainbow me rainbowkit We must also pass in our theme to RainbowKitProvider lt RainbowKitProvider chains chains theme midnightTheme gt RainbowKit supports more advanced theming you can see the RainbowKit Theming docs here for more information Also add this small piece of code to styles globals css to make our app dark mode too body background color color fff Now our app should look like this A tour of RainbowKitAfter authenticating with a wallet our connect button will automatically change to a network switcher which also show us our balance and wallet address Switching the network is as easy as clicking the network switcher and then selecting the network we want to switch to Clicking on our wallet address gives us a modal with the option to copy our address or disconnect our wallet Cool Mode Let s make our application a little cooler Just add the coolMode prop to RainbowKitProvider lt RainbowKitProvider chains chains theme midnightTheme coolMode gt Now if we click on any of the options in the connect modal we will get some amazing confetti ConclusionThat was a basic demo of what RainbowKit can do but it can do a lot more like show recent transactions The best place to learn more about it is RainbowKit docs Important LinksSource CodeDeployed PreviewRainbowKitRainbowKit GitHub	2022-05-15 11:14:17
海外ニュース	Japan Times latest articles	Swallows and Carp draw Central League battle for first place	https://www.japantimes.co.jp/sports/2022/05/15/baseball/japanese-baseball/swallows-carp-tie/	battle	2022-05-15 20:40:03
海外ニュース	Japan Times latest articles	Terunofuji suffers third defeat as five wrestlers share lead	https://www.japantimes.co.jp/sports/2022/05/15/sumo/basho-reports/summer-basho-day-8/	Terunofuji suffers third defeat as five wrestlers share leadThe yokozuna who pulled out of March s Spring tourney with knee and heel injuries has often looked less than match fit in his comeback and	2022-05-15 20:29:40
ニュース	BBC News - Home	NHS prescription charges in England to be frozen	https://www.bbc.co.uk/news/uk-61451005?at_medium=RSS&at_campaign=KARANGA	ministers	2022-05-15 11:12:23
ニュース	BBC News - Home	Muhammed Taimoor: Birmingham teacher charged with sexual assault on schoolgirls	https://www.bbc.co.uk/news/uk-england-birmingham-61455926?at_medium=RSS&at_campaign=KARANGA	taimoor	2022-05-15 11:31:20
ニュース	BBC News - Home	Andrew Symonds: Former Australia cricketer dies aged 46 in car crash	https://www.bbc.co.uk/sport/cricket/61453300?at_medium=RSS&at_campaign=KARANGA	crash	2022-05-15 11:34:15
北海道	北海道新聞	将棋の藤井叡王、初防衛に王手　５番勝負で２連勝	https://www.hokkaido-np.co.jp/article/681071/	藤井聡太	2022-05-15 20:17:00
北海道	北海道新聞	胆振管内２５４人感染　新型コロナ	https://www.hokkaido-np.co.jp/article/681059/	新型コロナウイルス	2022-05-15 20:10:00
北海道	北海道新聞	大型客船、室蘭を元気に　「ぱしふぃっくびいなす」６年ぶりに入港　祝津埠頭の多目的岸壁、一部供用開始	https://www.hokkaido-np.co.jp/article/681058/	世界最大	2022-05-15 20:10:07
北海道	北海道新聞	バイクが路外逸脱、５１歳男性死亡　赤井川	https://www.hokkaido-np.co.jp/article/681070/	赤井川村常盤	2022-05-15 20:05:00
北海道	北海道新聞	「ウクライナに関心持ち続けて」　有志の抗議集会、札幌駅前で最後の開催	https://www.hokkaido-np.co.jp/article/681069/	抗議集会	2022-05-15 20:03:00
海外TECH	reddit	T1 is playing with 22 ping? Competitive integrity is a joke now?	https://www.reddit.com/r/leagueoflegends/comments/uq41k0/t1_is_playing_with_22_ping_competitive_integrity/	T is playing with ping Competitive integrity is a joke now Chinese fans are complaining after seeing this creenshort It shows T is playing with ping Chinese media example in Chinese reports that RED player Jojo thinks the new ping in the revenue is ms However I couldn t find the original interview Will RNG play with a handicap submitted by u deacdcbf to r leagueoflegends link comments	2022-05-15 11:24:20