投稿時間:2022-03-11 17:35:49 RSSフィード2022-03-11 17:00 分まとめ(40件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
IT	気になる、記になる…	楽天モバイル、｢iPhone SE (第3世代)｣の価格を発表	https://taisy0.com/2022/03/11/154525.html	iphone	2022-03-11 07:56:13
IT	気になる、記になる…	Apple公式サイトがメンテナンスモードに − 午後10時から｢iPhone SE (第3世代)｣などの予約受付開始へ	https://taisy0.com/2022/03/11/154522.html	apple	2022-03-11 07:43:04
TECH	Engadget Japanese	「M2」搭載MacBook Airと13インチMacBook Proが今年後半に登場の噂	https://japanese.engadget.com/m2-macbookair-13inch-macbookpro-later-this-year-073051051.html	macbook	2022-03-11 07:30:51
TECH	Engadget Japanese	Google、Androidメッセージのアップデートを発表。iPhoneユーザーとの会話が少し便利に	https://japanese.engadget.com/google-android-message-update-070032234.html	android	2022-03-11 07:00:32
IT	ITmedia 総合記事一覧	[ITmedia News] 一反木綿みたいなロボット「零式人機ver.2.0」、高所の危険な作業を人の代わりに	https://www.itmedia.co.jp/news/articles/2203/11/news151.html	itmedia	2022-03-11 16:44:00
IT	ITmedia 総合記事一覧	[ITmedia PC USER] サンワ、丸洗いも可能な抗菌設計のシリコン製USBテンキー	https://www.itmedia.co.jp/pcuser/articles/2203/11/news146.html	itmediapcuser	2022-03-11 16:13:00
python	Pythonタグが付けられた新着投稿 - Qiita	HITRANデータベースのAPIであるHAPIを使用した放射スペクトルの計算	https://qiita.com/syoukera/items/c52eabbc63d3e730953f		2022-03-11 16:56:06
python	Pythonタグが付けられた新着投稿 - Qiita	Djangoのフォームのバリデーションで生じるKeyError	https://qiita.com/python_walker/items/f63d108451eb116fa7c7	DjangoのフォームバリデーションDjangoのリポジトリを見て内部でどのようなバリデーションをしているのかざっと見てみます。	2022-03-11 16:36:26
js	JavaScriptタグが付けられた新着投稿 - Qiita	【２日目】簡単な和演算の電卓を作る	https://qiita.com/ri6616/items/6d35f23a157fd733aa69	入力する一文字目には「」と「」が打ててしまうということだ。	2022-03-11 16:54:22
js	JavaScriptタグが付けられた新着投稿 - Qiita	Array.someで引数を渡したい	https://qiita.com/hanashima/items/a54a1bd8eb069dffbc9c	thisArg引数がsomeに与えられると、それがコールバックののthisとして使用されます。	2022-03-11 16:40:24
Ruby	Rubyタグが付けられた新着投稿 - Qiita	Userモデルのバリデーションを解説【Ruby on Rails】	https://qiita.com/fumi19/items/63c5c709c943e90aa12b	最後に、データベースにマイグレートターミナルrailsdbmigratetestfixturesusersyml内で一意性の制限が保たれていない場合は、テストを実行してもエラーになる。	2022-03-11 16:55:55
Ruby	Rubyタグが付けられた新着投稿 - Qiita	rails db:migrateを実行した時に出たエラーを解決した話	https://qiita.com/namaiki_2007/items/4755c06f5180dc81dc48	railsdbmigrateを実行した時に出たエラーを解決した話はじめに月プログラミングスクールで学習しています。	2022-03-11 16:10:39
Linux	Ubuntuタグが付けられた新着投稿 - Qiita	Dockerでスクレイピング環境構築	https://qiita.com/sgash708/items/8f059d56f564ea3beb86	errpageNavigateiferrnillogFatalln該当ページに遷移できませんでした。	2022-03-11 16:54:21
Linux	Ubuntuタグが付けられた新着投稿 - Qiita	利用頻度が多いコマンドのべスト10を表示	https://qiita.com/pyon_kiti_jp/items/fab0dd3a322ac551a488	コマンドが表示される行はカラム目に相当するので、オプションfを指定する。	2022-03-11 16:26:16
Docker	dockerタグが付けられた新着投稿 - Qiita	Dockerでスクレイピング環境構築	https://qiita.com/sgash708/items/8f059d56f564ea3beb86	errpageNavigateiferrnillogFatalln該当ページに遷移できませんでした。	2022-03-11 16:54:21
Docker	dockerタグが付けられた新着投稿 - Qiita	【Docker】Dockerとは	https://qiita.com/s_ryota/items/cc8ae7b33506179e99bb	そのため、Dockerエンジンをインストールしてあれば、アプリのDockerイメージからコンテナを作成するだけで環境構築が行えるため、同じ条件でローカル環境を構築することができる。	2022-03-11 16:25:37
golang	Goタグが付けられた新着投稿 - Qiita	Dockerでスクレイピング環境構築	https://qiita.com/sgash708/items/8f059d56f564ea3beb86	errpageNavigateiferrnillogFatalln該当ページに遷移できませんでした。	2022-03-11 16:54:21
Ruby	Railsタグが付けられた新着投稿 - Qiita	Userモデルのバリデーションを解説【Ruby on Rails】	https://qiita.com/fumi19/items/63c5c709c943e90aa12b	最後に、データベースにマイグレートターミナルrailsdbmigratetestfixturesusersyml内で一意性の制限が保たれていない場合は、テストを実行してもエラーになる。	2022-03-11 16:55:55
Ruby	Railsタグが付けられた新着投稿 - Qiita	rails db:migrateを実行した時に出たエラーを解決した話	https://qiita.com/namaiki_2007/items/4755c06f5180dc81dc48	railsdbmigrateを実行した時に出たエラーを解決した話はじめに月プログラミングスクールで学習しています。	2022-03-11 16:10:39
技術ブログ	Developers.IO	OktaからNotionにSAML認証でシングルサインオンしてみた	https://dev.classmethod.jp/articles/notion-okta-saml-sso/	idaas	2022-03-11 07:25:12
海外TECH	DEV Community	tsParticles 1.42.1 Released	https://dev.to/matteobruni/tsparticles-1421-released-6ob	tsParticles Released tsParticles Changelog Options UpdatesNew numeric values are now randomizable using the min max object instead of the numeric value The list of the new randomizable options are particles move attract distanceparticles move angle offsetparticles move angle valueparticles orbit opacityparticles orbit radiusparticles orbit widthparticles repulse distanceparticles repulse durationparticles repulse factorparticles repulse speedparticles roll darken valueparticles roll enlighten valueparticles rotate animation speedparticles tilt animation speedparticles twinkle lines opacityparticles twinkle particles opacityThese are the core options also every animation object now can have randomizable count and speed properties Absorbers and Emitters plugin options now have randomizable coordinates the min max can be set to their position x and position y values instead of a single numeric tsParticles Changelog Bug FixesFixes issue with values on x and y properties of emitters position options matteobruni tsparticles tsParticles Easily create highly customizable particles confetti and fireworks animations and use them as animated backgrounds for your website Ready to use components available for React js Vue js x and x Angular Svelte jQuery Preact Inferno Solid Riot and Web Components tsParticles TypeScript ParticlesA lightweight TypeScript library for creating particles Dependency free browser ready and compatible withReact js Vue js x and x Angular Svelte jQuery Preact Inferno Riot js Solid js and Web Components Table of ContentsUse for your websiteLibrary installationOfficial components for some of the most used frameworksAngularInfernojQueryPreactReactJSRiotJSSolidJSSvelteVueJS xVueJS xWeb ComponentsWordPressPresetsBig CirclesBubblesConfettiFireFireflyFireworksFountainLinksSea AnemoneSnowStarsTrianglesTemplates and ResourcesDemo GeneratorCharacters as particlesMouse hover connectionsPolygon maskAnimated starsNyan cat flying on scrolling starsBackground Mask particlesMigrating from Particles jsPlugins CustomizationsDo you want to use it on your website Documentation and Development references here This library is available on the two most popular CDNs and it s easy and ready to use if you were using particles jsit s even… View on GitHub	2022-03-11 07:39:16
海外TECH	DEV Community	Heroku Database VS AWS RDS	https://dev.to/mohsenkamrani/heroku-database-vs-aws-rds-50a6	Heroku Database VS AWS RDSDatabase is the heart of almost any real world software system and when it comes to choosing the right platform to host your database two of the famous names are AWS RDS and Heroku PostgreSQL In this tutorial I briefly compare the key factors of each of these two offerings without going too deep in the technical details while hopefully keeping it clear enough to be able to draw a conclusion based on these facts Also I do not include Redis in the comparison as like many of you even I m not yet convinced that Redis is a database plus it s totally a separate service in AWS which I ll cover in another post To begin with let s take a look at the different Database offerings the two platforms provide Supported enginesDatabaseAWSHerokuPostgreSQLYesYesMySQLYesNoMS Sql ServerYesNoAuroraYesNoOracleYesNoWinner gt AWSConsidering the fact that Heroku doesn t even support many different database engines let s just compare the same database engine that is provided by both platforms yup our lovely elephant DB PostgreSQL Again let s simplify the comparison and start with few side by side comparisons demonstrated in tables VersionsVersionAWSHerokuYes deprecated Yes deprecated YesYes deprecated YesYesYesYesYesYesYesYesYesNoWinner gt AWS FailoverFeatureAWSHerokuUrl Change No good gt seamless Yes bad gt restarts applications Supported plansAllOnly Premium Private and Shield tier plansRead only support Yes if more than two AZs selected Yes with extra setup Url change refers to the fact that the URL endpoint of the database does or does not change after the failover Read only support is about whether the failover follower instances can be used as read only databases or not Winner gt AWS BackupAlthough you might think you won t need backup and restore functionality that often you can find yourself restoring production databases in development environments many times Also RPO RTO and in general your disaster recovery strategies are directly impacted by the effectiveness and simplicity of the backup restore functionalities available to you FeatureAWSHerokuPoint in time recoveryYes by default Yes conditionally Supported plansAllOnly Standard Premium Private databases tier plansRollback history days no limitations days depending on your plan Winner gt AWS PricingThis one can be a bit misleading Here we re comparing only the price of the service exclusive of the labour and or the set up and maintenance price Also the list is not an exhaustive one but it s a good indicator of the actual difference between the two platforms Memory sizeAWSHerokuGB w w o multi AZ storage based on features GB w w o multi AZ storage based on features GB w w o multi AZ storage based on features AWS GB memory was the closest match to Heroku GB memoryIt s worth mentioning that all the pricing difference in AWS column is based on the extra pricing for the storage when Multi AZ option is available otherwise irrespective of the price and size RDS instances have all the features Winner gt AWS Simplicity of use and operational overheadThis section is more of an analytical experience instead of quantitative comparison Provisioning a databaseHeroku gives you way less options meaning way fewer decisions to be made and faster progress knowing that lots of the decision Heroku takes for you are already descent decisions On the other hand AWS gives you heaps of options from deciding the VPC and subnets to setting the security groups parameter groups and option groups While this might sound appealing at first we should consider that it comes at the price of increased complexity meaning a lot more time to spend and many more ways to take wrong decisions Backup and RestoreHeroku has simple options to create backups and restore the databases but again doesn t give you much control even on how long you want to retain the backups AWS on the contrary gives you plenty of options or decision points from a different perspective but again it requires a good understanding of how RDS works and even knowing the fact that your RDS snapshots are stored on S can help you better understand the logic behind some behaviours MonitoringHeroku provides very limited monitoring options out of the box which can be enough in many cases but as your use cases become complicated they definitely lack many metrics that can help you troubleshoot the system AWS on the other hand gives you the ever growing CloudWatch metrics which can help you fine tune even the applications using that database based on the behaviour that becomes clear looking at the extensive metrics available to you As you can guess again you have to navigate to different sides of the AWS dashboard to be able to get the metrics you want with the level of details you like while still some metrics are available on the RDS page with limited options On top of all these differences setting up read replica instances failoever and many optimisations on RDS are way more involved than the Heroku s counterparts meaning that you have to shift the focus from building the product and providing a better service towards operational activities Winner gt HerokuChoosing AWS as your platform while might look like buying directly from the factory comes at the cost of lots of DIYs which can heavily impact where you spend your time i e product vs operations and can even impact your hires It s very typical for the teams that run their solution on AWS to have multiple DevOps engineers for the larger teams or hire developers particularly with AWS experience to handle the operations for them while doing their coding tasks in smaller teams Obviously the DevOps engineers permanent or on contract in most cases are way more costly than the savings you were planning to have if that was the reason you choose AWS over Heroku and asking the developers to manage AWS means lots of distraction sub optimal infrastructure utilization and in most cases less skilled developers you re hiring someone who knows AWS and deep down you know that you re willing to sacrifice the development skills to some extent Overall if in the middle of the article you were completely convinced that picking AWS is a no brainer I believe you might now factor in more real life parameters in your assessment The best of both worldsSimplicity of Heroku means less operational cost and more agility in the development of the product with a developer first experience and more focus on shipping a quality product that directly brings value and generates revenue The high quality service that AWS provides has a way lower cost for the raw material yup I m calling RDS raw material compared to Heroku please forget the pre historic datacenter era along with perfect integrations with the rest of your platform and advanced options to make the solution way more secure irrespective of the instance size Utopiops is a solution that gives you the simplicity that Heroku provides on AWS meaning you can now have the best of both worlds Not only that as the solution is provided on your own AWS account lots of advanced configurations are included without your involvement You get your extremely popular RDS with a set up that most experienced DevOps engineers and solution architects can provide with such a simplicity that any developer can use it What does it mean for DevSecOps engineers While Utopiops is starting a new era that we call no ops and low ops it doesn t mean the DevOps role will become redundant at least in the near future The operational expenses of the companies will definitely reduce in the future benefiting from platforms and services like Utopiops while helping teams to achieve even more Auto tuning the parameters settings scales and even diagnosis are a few of the things you can expect to see in this era meaning that the DevOps role will shift more and more towards solution architect activities and the experts in the field can help the teams achieve more by designing more complex and efficient solutions without having to go through the unnecessary boring and low level grunt work	2022-03-11 07:37:07
海外TECH	DEV Community	Features of Codeigniter web development	https://dev.to/jhonthsmith/features-of-codeigniter-web-development-1051	Features of Codeigniter web developmentCodeIgniter is an amicable and clear Hypertext Preprocessor PHP system created and produced for site advancement By utilizing this toolbox a designer can deliver an undeniable site Because of its straightforward structure and selective highlights web designers can make top notch web applications CodeIgniter web development has seen a huge development in the market due to its adaptable elements Also web applications created utilizing the CodeIgniter structure were very effective as they were basic rich and easy to use Do you have at least some idea why it is getting well known among designers Since any web application created by utilizing the CodeIgniter structure performs actually and quickly •Handling errors Assuming you are one of those master web designers or experts who like to make a sans bug site you ought to go for CodeIgniter Because of its impeccable and unprecedented highlights one could foster extraordinary web applications In addition assume you might want to inspect regardless of whether your current application is working consistently All things considered you can check it from its straightforward UI highlight which helps observe bugs which discourage the site s well working and at last upgrade your clients insight Additionally the mistakes in code are shown while attempting to assist you with composing a blunder free code •Security measures CodeIgniter web developer is one of the most solid structures with regards to security It gives true serenity to engineers so they can code without stressing over information spills In view of its different start to finish encryption and unscrambling features PHP CodeIgniter has become one of the most well known PHP stages among engineers •SEO friendly features This perspective is likewise one of the basic elements of CodeIgniter when you have an internet based business making your site rank on google turns into a fundamental errand As an entrepreneur you might want to arrive at a great many individuals and need to be their best option and for that you must be the top site in google search •User friendly interface One thing that you will observe normal and natural among every one of the effective sites is their incredible UI The most significant and appealing piece of a site is its UI The progress of a business is similarly corresponding to the allure of the site s UI What s more this is one of the benefits of CodeIgniter a designer can make a User accommodating Interface to hoist the client s general insight	2022-03-11 07:19:44
海外TECH	DEV Community	Solidity? What is it, and can this language change how we develop software forever?	https://dev.to/edward_naidoo/solidity-what-is-it-and-can-this-language-change-how-we-develop-software-forever-57cp	Solidity What is it and can this language change how we develop software forever The StartThis is a late response to the language called Solidity I have only came onto DEV to early this year and the last time I have read part of the documentation was when it was in version Now Solidity is in version Time has flown by but that is no excuse Today I will be embarking on understanding this language and explore the vast horizons in Web technology This will be a a series where I will document everything about what I have learnt and as many resources that supports my argument Web is foreign to me but from what I understand I believe that Web will exist in the future and will be part of our lives just not every single individual who has the technology to interact with it It is a large say when I just said of how foreign it is to me But I have spent a lot of time on such technologies Some of them are TokensSmart ContractsDefisDappsDAOsBlockchain intergrationWeb gt Web hybridsand a few in which I cannot think on the top of my head But now is the time where even though I have an existing project and posting schedule I have to fix I am willing to create software that makes Web great and to solve a variety of problems around the world Watch me as I plan on spending months on this I will do a clean restart in my existing research because so much time as passed that I am extremely behind in Web related news and development implementations What I plan to cover and what I plan to avoidFor this research and developing I do not plan on looking into NFTs and Cryptocurrency related news development in general I might read articles to stay updated as much as I can But the scope is just Web and most importantly Solidity Maybe on a different post unrelated to this project and redesigning Nasa s APOD I will post some things I find interesting I think this will be fun Resources to start you off on your own v Solidity v Intro to Smart ContractsBlockChain BasicsIntro to the Eth Virtual Machine Resources to start you off on your own LatestSolidity LatestIntro to Smart ContractsBlockChain BasicsIntro to the Eth Virtual MachineIf find yourself reading this whole post then thank you it s really cool when someone reads my posts and also if you d like to I will add my social media or other links down below so you can keep track of what I ll post or when I ll post Or something else like things are going to be delayed GithubTwitterLinktree	2022-03-11 07:07:07
海外TECH	DEV Community	Firebase is Dead: What is the Perfect Database in 2022?	https://dev.to/jdgamble555/firebase-is-dead-what-is-the-perfect-database-in-2022-4o9a	Firebase is Dead What is the Perfect Database in FirestoreTo be fair I meant Firestore really not Firebase the Platform Ok Firestore is not dead It is quite popular But it should be dead It should be dead for the reasons I listed in my post almost a year ago The team has spent the last months building every single SDK plugin and monitoring addon for Firebase possible This includes the controversial Firebase interface although I do like the word faster But you know what hasn t been updated not even a little FIRESTORE We still can t do any kind of basic aggregation without writing an error prone firebase function that doesn t take into account our current data We still can t do a basic full text search Google MOST IMPORTANTLY we still can t count our search results Sure we can create automated collection counts by incrementing a random table value yuck Try indexing every possible where clause in just one collection It can t be done Marty I have created a backend solution and a frontend solution for most use cases I spent hours writing a backend package but these days I prefer the frontend solutions Why I love FirestoreFirestore is so freakin easy to develop I love that it is cloud hosted I don t love the vendor lock in I love that it has the easiest to use client side api for javascript development I love that I can secure these things with Firestore Rules I love how easy I can just add the subscribe function to get real time data I love how Firestore can auto scale for a few or many users I don t love having to manage a second database and the lack of growth The Perfect DatabaseI want the perfect database It has these features ScalableRelational SQL or Graph Realtime Data SupportA JS TS Client Side API or GraphQL Middleware SecurityCloud Hosted DbaaS OptionNo Vendor Lock InACL with Login MethodsI have been researching the perfect database and it does not quite exist yet However there are some options that come close and some future prospects to watch out for noSQLnoSQL databases in general are great at scaling You know what they re not good at Everything else Firestore recommends you use Algolia with it in order to add search functionality Besides the obvious problem with a Google product requiring you do use a non google product to function correctly you would be storing your data in one noSQL database and have to manage a second noSQL database just for searching Huh This makes no sense but it is the world we live in MongoDB simulates joins by aggregating data However you can t actually do joins Firestore just says hey write you re own damn code that is probably going to be problematic to handle aggregations Oh and there are limits on that too So I can t just duplicate user profile s on posts as the function would timeout Yeah you got to think outside of the box to hack a way of doing this with even more joins and complications Oh did I mention the follower feed problem If you ve been following my posts for a while you know my many theories about how this CAN T really be done outside of theory at least not scalable in both users and followers collections I have posts on the subject Here is the latest Now try aggregating data keeping it up to date and adding functionality later to existing data that grows with Firestore or Mongodb Try this with plain ol redis All data is relational You simply cannot create a realistic scalable database solution with ONLY a noSQL database unless a graph database is built on top of that noSQL database noSQL databases need to die as main databases MongoDB I do give you mucho credit for trying key word try here Hello my lovely and remarkable Graph Database with one problem There is a huge misconception about Graph Databases I have literally talked with a PhD computer scientist who works at Twitter who didn t understand why anyone would use a Graph Database who is not querying analytical data I got news for you buddy All data is relational Graphs relate data better than SQL Graph Databases are better than SQL It used to be true that Graph Databases were not scalable That is no longer true It used to be true that Graph Databases were slower than SQL That is also no longer true Every database can be awesome it just depends on what is underneath A great database is scalable by distributing the data uses sharding maybe multi tenancy and could even be deployed to grow all automatically We also have all needed features without having to spin up a second database This is usually the problem Graph Databases are evolving There are really two classic types triple stores and property graphs Triples stores usually store RDFs that subject verb predicate thing used by SPARQL and property graphs have edges and nodes Despite what some articles say they both can have index free adjacency This is the real key to the future of a graph database Memory LocationImagine a foreign key in a many to many SQL table We often have to have a junction table ms pivot table when doing joins We join one table to another just to get the value of the real table we want We need two joins to relate only two pieces of data This is the real reason Graph Databases are amazing We store the direct place in memory to goto and we go there We don t make a stop in between Relational data is actually relational in a Graph Database n There is also the n problem in SQL If I query junction tables I am querying n one more than I need SELECT and WHERE statements also require you to query more than you need It is basically over and under fetching Granted both of these problems can theoretically be fixed if you re a really good a SQL querying and you use advanced JSON querying techniques However most cases are simply faster in a graph database They were made for this kind of SH T Trying querying multiple deeply nested data objects If you don t know what a nested data object is it is because you don t know how to think in graph terms Real problem with graph databases The real problem with a graph database is not that it is only made for graph data ALL DATA IS GRAPH DATA The real problem is the same problem with Svelte maturity Most Graph Databases do not have all the necessary features to produce a web app like constraints policies triggers full text search and security In fact that list is very very short The definition of a Graph Database is also evolving First you had graph databases then you had graph databases built on noSQL or other KV stores then you had graph databases built on sql agensgraph and now you have hybrids that use more than one database under the hood The focus is no longer on edges and nodes as a node itself can be used as an edge The focus is on the speed you save by storing the memory location directly and not the location of another intermediate table The focus is on querying So which databases are in the lineup huh Get on with it In order to compete with Firestore you have to have pre written and customizable middleware I am only going to list databases that have this In Firebase this would be the Client Side Javascript API plus Firestore Rules for Security SupabaseSupabase is by far Firestore s number one competitor Sure it is also Firebase s competitor because it has storage bucks and login methods but it is really Firestore s competitor because it has a client side securable interface similar to Firebase It is so easy and lovely to use You may enjoy the flexibility of a schemaless database but the tradeoffs for relations are incredible It uses PostgreSQL under the hood PostgreSQL is faster for handling large sets of data while mySQL is faster for smaller sets of data It now even supports secure subscriptions You must get used to using Policies and Constraints but frankly Supabase makes writing these a pleasure seriously They are also working on a GraphQL Layer which theoretically would mostly automatically handle the n problem There is one tiny caveat PostgreSQL while made for large datasets is not made for scalable data Sure you can scale vertically with more computing power but you can t scale easily horizontally with more computers virtual computers They may one day support this but it won t be easy mySQL can FaunaFauna is pretty freaking cool I admit I have not yet had the pleasure to build anything with it It is one of those freaky hybrids You can store data in a key value store but query it like a graph The FQL Client API looks like Firebase in that you need to import a lot of functions within functions You use internal database techniques like in Supabase for security The biggest two problems I see with Fauna are Vendor lock in Learning Curve it does not seem as easy to create links etc as a graph database or sql database HasuraHasura gives you several choices of SQL databases to build on but specializes in postgres It also has the most advanced GraphQL engine that exists although it is still missing some required features You need to combine Hasura with Firebase Auth auth or some other login system but technically the middleware is there It suffers the same scalable problems and feature problems as DGraph You can also use NHost io to automatically set up an instance of your database with a built in login system and file storage I have not built anything complex with Hasura yet but I have read about missing features like nested updates I think once you get to the complex level the GraphQL alone won t cut it Honestly no GraphQL cuts it yet Honorable Mention DgraphDgraph was chewed up spit out killed brought back to life and now split A month ago I would not have listed Dgraph at all even though I love Dgraph They basically got some VC money spent the money fired half the staff started producing a decent return and split One side got the Founder and programmers and forked the open source part now Outcaste the other side got the board and VC money as well as the paying cloud users They are honestly going to be very different products in a year I personally am spending a lot of time with both CEOs to give them my ideas and the compiled feedback I have seen from the community of the users There is an unofficial discord recently started with over users You will find both communities and managing staff active on there I do not care to take sides I just believe in the original product s potential There has been active talk of a second fork as well Dgraph specializes in GraphQL written in GO for extreme speed and is arguably better and worse than Hasura at GraphQL I would say Hasura Prisma and Dgraph all are in a fight for the best GraphQL I wrote the j dgraph package just so it works like Firebase querying the GraphQL automatically through JS methods Dgraph checks ALL my boxes and I believe in one year that one or even both versions will take the and maybe spots on this list This product is absolutely amazing in every way so follow me for updates neojneoj is that most popular graph database everyone knows They focus too much on the analytical users and are missing out on the Firebase users They have advanced querying capabilities with cypher math functions and triggers While they do have basic constraints they do not have policies However you could write your own with triggers neoj is really a beast and competes more with sql databases than you know However they re missing out They offer a cloud platform but expect you to host your own GraphQL They could make this process easy They also haven t developed subscriptions although people keep asking for it It supports huge amounts of data but it does not support sharding like DGraph I have heard DGraph users switched from neoj due to the inability to support the large datasets So the enterprise version can scale for high availability so it sort of scales Full disclosure I have not tested any of this nor am I an expert by any means Planetscale with PrismaThese are really two different products Really you could choose any cloud hosted mySQL database and Plugin Prisma to it but the Fireship guy tweeted about Planetscale and they spend a lot of money on Google ads so I suspect they re legit I need to spend more time researching this Technically there is some setup needed for Prisma Prisma itself is in the top tier of GraphQL has its own api too like Firebase but no frontend caching like pure GraphQL with URQL or Apollo Prisma has subscription capabilities This may should be your best option TBD Up and Coming EdgeDBEdge database looks pretty freakin awesome It basically seems to re write SQL and Graph databases together to create some new ish programming language It takes care of all the problems GraphQL has and seems to be built separately but on top of postgres It is really something unique beautiful and powerful They don t have a security layer yet or a cloud hosting environment but both are in the works However postgres still suffers from the scalable problems we all know If you like unique fetching and strong typing also check out TypeDB It doesn t make its own list number because there is not cloud version middleware etc However worth checking out basebase has perhaps the most beautiful UI It is mySQL so it is serverless and scalable It uses GraphQL so has middleware It checks all boxes except features The GraphQL is adequate It is not the best not the worst It needs nested filters nested updates etc I am going to create am app soon with this thing so I can truly test its functionalities There is also something called Grafbase for producing GraphQL apis but I m not sure where it stands yet Who Wins Nobody All options are missing something or another I am currently building in Supabase because it is so damn easy and they sent me a T Shirt due to my past article I love DGraph and will continue to give updates on that and Outserv Outcaste s product I think mySQL is the best overall database noSQL scales well but is not relational Hybrid databases are built on other databases or given names like newSQL Ultimately great databases are hybrids we just want all the management done automatically base and Edgedb should definitely be on your radar MongoDB Aura if you don t need a follower feed doesn t have a front end client system If we stick with these rules real time dataclient side apicloud hostingmiddlewareWe only have Fauna Hasura and Supabase Ok technically DGraph too base is just a baby Complain though I have the Firebase Team forgot about Firestore We should not only be angry but frankly disrespected They quit listening to their users I have high respect to all the team members especially the active ones in the community but low respect for whoever is choosing to keep Firestore stagnant If they start development again I will gladly continue spreading the good word Hopefully they create a cloud platform for an actual relational database instead Either way the product used to be great but it is getting passed by Firebase do something about it One thing to rememberSeparate your code Build your React or Svelte app so that your Firestore or Supabase code is totally separate from your key elements Use good DRY SOLID and KISS techniques When we find that perfect database your app will be built and it will be easy to change your code Otherwise find the tradeoffs that work for you Maybe you love noSQL databases like Cassandra Maybe you want that Web database that syncs with the blockchain did I mention that is Outserv Dgraph s fork Maybe you don t mind managing a second database just for searching That is fine too I personally am ready for the future This year is a new beginning Check out my databases from last year Until then keep building J	2022-03-11 07:03:43
海外TECH	DEV Community	How to prepare for Google Summer of Code 2022?	https://dev.to/sanjaysinghrajpoot/how-to-prepare-for-google-summer-of-code-2022-899	How to prepare for Google Summer of Code Let s talk about the most important topic how to prepare for Google Summer of Code and what are the key points that one should keep in mind while applying Update The list of projects and organisations participating in GSoC is out now Decide your tech StackThis point is really important Take your time and decide which technology you are good at for Example web development Android Development AI ML etc Most of the time people are confused about which org to contribute to because they don t decide their tech stack first Now Finalize your OrganisationOnce you have decided on your tech stack it s time to fix your Organisation as per your tech stack Go through the code base of the organisation create some issues make some PRs and don t forget to join their community Project SelectionEvery Organisation will have projects listed on their idealist Go through the projects Once you have finalized the project contact the mentor of that project and ask him about what all things are required for the project Keep things formal and ask genuine doubts Be active in the communityEvery Organisation will have some form of community It could be a slack channel discourse panel or something else Make sure to join their community give a nice introduction and help others with their doubts Try to put our problem in the discussion before creating a GitHub issue so that others can also contribute to this problem Update Social Media handlesUpdate your LinkedIn and Github profile Keep all genuine information on your profile and remove everything else if you have made any projects don t forget to upload them on Github Your mentor might visit your social media accounts Don t forget to read my other posts linked in the comments down below like it a like if you made it so far github opensource webdevelopment	2022-03-11 07:01:30
海外TECH	DEV Community	Scan Duplicated CSS	https://dev.to/zhcalvin/scan-duplicated-css-4fc0	Scan Duplicated CSSTo auto detect redundant and unused CSS classes I made this library recently css checker It helps to scan your codebase automatically by one command css checker I think it s always better to rely on automatic code checking tools than read all codes manually to find improvements The css check can scan your CSS code along with your js jsx html ts tsx code to find unused CSS code optional InstallYou can access to the package via go install go install github com ruilisi css checker latest With go version before use go get github com ruilisi css checker Or download from releasesOr from npm npm install g css checker kit Start Checkingcd to your Project Path Then just run css checkerThe css checker helps in checking my projects in seconds and provides hundreds of similar and redundant classes for me to improve You can check out the package from the Github link for more details css checker	2022-03-11 07:01:11
金融	日本銀行：RSS	「気候変動関連の市場機能サーベイ」の実施に関する市中協議取りまとめ報告書の公表について	http://www.boj.or.jp/announcements/release_2022/rel220311b.htm	取りまとめ	2022-03-11 17:00:00
ニュース	ジェトロ ビジネスニュース（通商弘報）	メコン地域の一部で新型コロナ感染拡大も、対応に変化	https://www.jetro.go.jp/biznews/2022/03/1553d298f3a2efe3.html	感染拡大	2022-03-11 07:20:00
ニュース	ジェトロ ビジネスニュース（通商弘報）	韓国、対ロシア・ベラルーシ向けFDPルールの免除確定	https://www.jetro.go.jp/biznews/2022/03/a24e139c84a5df75.html	韓国	2022-03-11 07:10:00
ニュース	BBC News - Home	Ukraine war: Large Russian convoy redeploys near Kyiv - satellite images	https://www.bbc.co.uk/news/world-europe-60702464?at_medium=RSS&at_campaign=KARANGA	ukrainian	2022-03-11 07:42:12
ニュース	BBC News - Home	Ukraine war: People can welcome refugees into own homes - PM	https://www.bbc.co.uk/news/uk-60701941?at_medium=RSS&at_campaign=KARANGA	boris	2022-03-11 07:35:03
ニュース	BBC News - Home	UK economy grew in January as Omicron eased	https://www.bbc.co.uk/news/business-60699815?at_medium=RSS&at_campaign=KARANGA	omicron	2022-03-11 07:46:48
ニュース	BBC News - Home	Covid inquiry terms set out and Scottish hospitals under strain	https://www.bbc.co.uk/news/uk-60700199?at_medium=RSS&at_campaign=KARANGA	coronavirus	2022-03-11 07:30:32
ニュース	BBC News - Home	Ukraine conflict: Growing numbers of firms pull back from Russia	https://www.bbc.co.uk/news/business-60571133?at_medium=RSS&at_campaign=KARANGA	difficulties	2022-03-11 07:27:57
ニュース	BBC News - Home	War in Ukraine: Facebook to allow calls for violence against Putin	https://www.bbc.co.uk/news/technology-60702619?at_medium=RSS&at_campaign=KARANGA	activities	2022-03-11 07:50:54
ニュース	BBC News - Home	GB's Hill clinches history-making snowboard bronze at Winter Paralympics	https://www.bbc.co.uk/sport/winter-sports/60703139?at_medium=RSS&at_campaign=KARANGA	britain	2022-03-11 07:35:14
北海道	北海道新聞	ＪＲ、１２日から新ダイヤ　新幹線、在来線を大幅減便	https://www.hokkaido-np.co.jp/article/655779/	東海道	2022-03-11 16:11:00
北海道	北海道新聞	国家公務員の懲戒処分、８％増　違法接待発覚の総務省で急増	https://www.hokkaido-np.co.jp/article/655778/	国家公務員	2022-03-11 16:10:00
北海道	北海道新聞	ニュース記事をＡＩでクイズに　問題と正解を自動作成	https://www.hokkaido-np.co.jp/article/655777/	集団	2022-03-11 16:05:00