投稿時間:2021-06-30 00:41:36 RSSフィード2021-06-30 00:00 分まとめ(41件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
IT	ITmedia 総合記事一覧	[ITmedia ビジネスオンライン] ぐるなび、楽天デリバリー事業とテークアウト事業を承継　「食の総合サービス」化を目指す	https://www.itmedia.co.jp/business/articles/2106/29/news172.html	itmedia	2021-06-29 23:52:00
IT	ITmedia 総合記事一覧	[ITmedia ビジネスオンライン] HIS Mobile、ライトユーザーに向けデータ容量が設定できる「格安ステップ」を提供　1GBで590円から	https://www.itmedia.co.jp/business/articles/2106/29/news171.html	hismobile	2021-06-29 23:34:00
AWS	AWS Government, Education, and Nonprofits Blog	How UCL migrated its Moodle virtual learning environment to the cloud in 10 weeks	https://aws.amazon.com/blogs/publicsector/how-ucl-migrated-moodle-virtual-learning-environment-cloud-10-weeks/	How UCL migrated its Moodle virtual learning environment to the cloud in weeksUniversity College London s UCL virtual learning environment built on the Moodle learning management system is at the heart of its digital education infrastructure and used by students all over the world Before migrating to Amazon Web Services AWS its system could handle concurrent users But when the pandemic drove schools and universities to predominantly online teaching the UCL team wanted to support six times this amount in just weeks Here s how they did it with AWS	2021-06-29 14:46:41
python	Pythonタグが付けられた新着投稿 - Qiita	Celeryメモ	https://qiita.com/youichiro/items/5d83e116389e7c0261a9		2021-06-29 23:13:10
js	JavaScriptタグが付けられた新着投稿 - Qiita	InDesign スクリプト 選択を条件テキストに	https://qiita.com/kohakunekotarou/items/e1e167b1b71780d149bb	InDesignスクリプト選択を条件テキストに選択を条件テキストにするスクリプトは、これで良いのかな・・・更新アプリ指定targetindesignスクリプト名varscriptName選択を条件テキストにスクリプト動作指定一つのアンドゥ履歴にする及びアンドゥ名の指定appdoScriptfunctionダイアログvardialogueFlgconfirm選択に条件テキストを適用します。	2021-06-29 23:55:54
js	JavaScriptタグが付けられた新着投稿 - Qiita	Nuxt.jsの環境変数でまだdotenv使ってるの？そろそろruntimeConfig使いましょう♪	https://qiita.com/nagachan1192/items/8b8e3c21f4af2b06ba49	ではどうするのかというとSPAモードでも同じように、nuxtServerInitのような仕組みを作る必要があります。	2021-06-29 23:04:47
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	DB2 SQLについて DELETEを実行しようとするとタイムアウトする	https://teratail.com/questions/346842?rss=all	他のデータ数が同じ位のテーブルはデリートできます。	2021-06-29 23:46:15
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	Pythonでcsvを読み取り、辞書型に変換するためのfor文に入れない	https://teratail.com/questions/346841?rss=all	Pythonでcsvを読み取り、辞書型に変換するためのfor文に入れない①Pythonでcsvファイル作成②同一csvファイルを読み込み③データを辞書型に変換してリストに追加という処理を作りたいのですが、③が上手くいきません。	2021-06-29 23:36:39
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	Swift 非同期処理	https://teratail.com/questions/346840?rss=all	Swift非同期処理nbsp前提・実現したいことSwiftのTwitterライブラリ「Swifter」を使用し特定ユーザーの最新ツイートを取得し続け、ツイートに特定の文字が含まれていた場合に処理を止めそのツイートを表示する仕組みを作りたいです。	2021-06-29 23:22:10
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	リンクを枠全体に設定するために擬似要素を設定したらhoverが変なことになる	https://teratail.com/questions/346839?rss=all	リンクを枠全体に設定するために擬似要素を設定したらhoverが変なことになるで質問してそれは解決したのですが、別件で問題が生じ、改めて詳しく教えてください。	2021-06-29 23:14:56
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	NullReferenceException: Object reference not set to an instance of an objectの解決	https://teratail.com/questions/346838?rss=all		2021-06-29 23:14:08
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	VBAでダブルコーテーションで囲んだ文字列をcsv出力するとエスケープコードまで出てしまう	https://teratail.com/questions/346837?rss=all	VBAでダブルコーテーションで囲んだ文字列をcsv出力するとエスケープコードまで出てしまう前提・実現したいことVBAでcsvの情報を変更するコードを書いています。	2021-06-29 23:10:29
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	連想配列？について(php初心者です)	https://teratail.com/questions/346836?rss=all	連想配列についてphp初心者です前提・実現したいことここに質問の内容を詳しく書いてください。	2021-06-29 23:05:26
Ruby	Rubyタグが付けられた新着投稿 - Qiita	[Rails]rails db:resetで不要なmigrationファイルを削除	https://qiita.com/onakasuita_reo/items/d7feed2af0848319a5fd	railsdbmigrateresetとは何かDBをdropした後、通常通りのマイグレートdbmigrateが行われます。	2021-06-29 23:05:51
AWS	AWSタグが付けられた新着投稿 - Qiita	SSH公開鍵認証について	https://qiita.com/Ub_Iwerks/items/a1306ee85af1ee631e1c	認証	2021-06-29 23:47:03
AWS	AWSタグが付けられた新着投稿 - Qiita	AWS Solution Architect Professional 合格記（2021年6月）	https://qiita.com/ysuganuma/items/303ecef7cded36c89146	フィードバックのサイクルを早くするUdemyの場合、問全て解かないと結果が見えなかったので、はじめのほうに答えた問題とか記憶の彼方にすっ飛んでしまっていることがおおかったのだけど、AWSWEB問題集で学習しようは問一区切りとなっていて、チャレンジ⇒フィードバックのループが短い間隔で回せたのが、個人的には合ってたなという印象。	2021-06-29 23:09:46
Git	Gitタグが付けられた新着投稿 - Qiita	gitで最近のcommitに戻す方法	https://qiita.com/tomatomnt/items/871fb3061766d338aebc	gitresethardhead	2021-06-29 23:08:26
Ruby	Railsタグが付けられた新着投稿 - Qiita	[Rails]rails db:resetで不要なmigrationファイルを削除	https://qiita.com/onakasuita_reo/items/d7feed2af0848319a5fd	railsdbmigrateresetとは何かDBをdropした後、通常通りのマイグレートdbmigrateが行われます。	2021-06-29 23:05:51
技術ブログ	Developers.IO	[AWS CDK] Kinesis Data FirehoseのデータのS3出力失敗時のログを記録してみた	https://dev.classmethod.jp/articles/logging-when-s3-output-failure-of-amazon-kinesis-data-firehose-data/	amazonkinesisdatafirehose	2021-06-29 14:53:56
海外TECH	DEV Community	Essential AWS Landing Zone and Control Tower Resources	https://dev.to/leewynne/essential-aws-landing-zone-and-control-tower-resources-2ifj	Essential AWS Landing Zone and Control Tower ResourcesYou are looking to get into AWS for the first time you may know a bit about platform architecture such as Regions Availability Zones EC S VPN s etc but you may not know that there is a whole other space around procurement billing and AWS account organization and OU structure that needs to be considered as part of any enterprise grade service especially at scale Here are some useful resources to get you started down that path Useful YouTube Videos What is AWS Control Tower Using AWS Control Tower to Govern Multi Account AWS Environments GRC R Using AWS Control Tower to Govern Multi Account AWS Environments GRC R Build governance at scale with AWS Control Tower  AWS Control Tower Tutorial Deep Dive Demo Implement AWS Landing zone using AWS Control Tower  Provisioning Users in AWS Control Tower Using AWS SSO How to onboard existing AWS accounts onto AWS Control Tower AWS Control Tower Well Architected Deployment AWS Control Tower Easiest way to set up and govern AWS at scale Programmatically Create an AWS Account with AWS Control Tower Useful Articles from around the Wen My Architecture AWS Control Tower vs AWS Landing ZoneBoth Control Tower and Landing Zone help set up and manage secure multi account AWS environments Which one should customers use Let s take a closer look and figure out together Read more AWS Landing Zone versus AWS Control TowerAWS Landing Zone and AWS Control Tower help set up and govern a new secure multi account AWS environment based on AWS best practices Both consist of core accounts and resources which will implement an initial security baseline The following table compares the managed service AWS Control Tower with the solution AWS Landing Zone This article also includes some great referencesRead more When to Migrate from AWS Landing Zone to AWS Control TowerLanding zones have traditionally been how enterprises would address this concern as they use a best practice security approach to help ensure the safe setup of AWS accounts Yet with the introduction of AWS Control Tower enterprises may consider migrating from AWS Landing Zone to AWS Control Tower Today we ll walk you through why you might want to migrate but first we ll start with a little background Amazon knows that when you have multiple AWS accounts it can be hard to manage control and secure all of them in one go Enter AWS Control Tower It combines power and simplicity making it easy to set up govern and secure your multiple accounts using built in services from AWS like AWS Organizations AWS Service Catalog AWS Single Sign on AWS IAM AWS Config AWS Cloudtrail and more This combination of services makes life easy and secure for your AWS accounts You can also provision new accounts very quickly using the Control Tower dashboard with limited steps Last it also provides built in guardrails to protect your accounts Read more Reddit Landing Zone vs Control Tower Landing Zone vs Control Tower May Author Jjmc We are currently rolling out AWS Landing Zone but i have been seeing that Control Tower is essentially a service offering for Landing Zone and should be out soon I was just wondering if anyone is testing one or the other and has any input We are definitely going to use one or the other to execute our multi account… See Full Post AWS Control Tower Everything You Need To KnowYou may have heard of AWS Control Tower AWS Organizations and AWS Service Catalog but what are these services and how do they integrate with one another What are the benefits of leveraging Control Tower and the underlying services If you re interested to learn more please read on and we ll answer these questions and more below What Is AWS Control Tower AWS Control Tower automates the at scale build out of a multi account structure on AWS For large companies migrating to AWS it makes sense to have a multi account architecture as different business functions will have different access requirements compliance requirements and so on these functions can be segregated easily between accounts With AWS Control Tower administrators can set up a new multi account environment with a single click in the AWS Management Console AWS Control Tower creates an orchestration layer for other AWS services including AWS Organizations AWS Service Catalog and AWS Single Sign on this Orchestration layer makes it easier for administrators who are managing more than a handful of AWS accounts Read more Setting Up AWS Landing Zone with AWS Control TowerMany years ago I was working in a company where everything had to be created from scratch Defining the requirements designing the Rack configuring the firewall routers and storage to be able to save data defining user management how to create all the infrastructure and the list went on and on This was a definitive infrastructure that hosted all customers and then managed them Today the way of thinking and drawing the entire infrastructure has changed It has become much simpler thanks to flexibility and automation tools but many of the requirements are the same When we start thinking about AWS and what customers want to do on AWS we need to first think about requirements to better understand what the customers need For example which is the right service to use What about security governance and baseline How many accounts should I create for my customer based on own use cases How many users groups and what permissions should they have Let me introduce you to the concept of a Landing Zone and Control Tower and why they work well together Read more More Reddit AWS Control Tower Landing Zone questions AWS Control Tower Landing Zone question May Author ixion Hello After looking at alternatives I m very heavily leaning toward AWS Control Tower Landing Zone but I had some burning questions I can t seem to find too much relevant or recent documentation on this The landing zone pattern vs AWS Landing Zone vs AWS Control Tower Landing Zone definitely contributes to the confusion I ve read for example that you shouldn t… See Full Post Managing AWS accounts for an organization AWS Control Tower v s Landing Zone v s Terraform Jul Author thorn Hello I m looking into the best way to manage a relatively small number lt of AWS accounts in an organization AWS is trying to push for Control Tower or Landing Zone but I m not sure of the added value compared to Terraform More precisely I ve PoC ed managing the following with Terraform Master account Organization children accounts OUs service control policies tagging… See Full Post Experience with Control Tower vs managing Organizations and access directly Aug Author CanyonSlim I ve started working with an organization that s only just getting their feet wet with AWS A couple weeks before I came on board they started using Control Tower to manage multiple accounts and provision access to them They re happy with it and it seems relatively user friendly but I have concerns about potential issues that could pop up long term… See Full Post When to use AWS Control Tower Jul Author Flipphones Hey all amp xB I ve been looking at using AWS Control Tower for the past few days From what I m reading with their documentation you need a new AWS account to then launch service I already have an existing multi account infrastructure so would I be able to add these accounts to the new org See Full Post AWS Control Tower govern a secure compliant multi account environment Nov Author ryankearney See Full Post Slide shows Implementing your landing zone AWS Landing Zone step by step Architecting Security amp Governance Across Your AWS Landing Zone Using AWS Control Tower to govern multi account AWS environments at scale	2021-06-29 14:37:21
海外TECH	DEV Community	How to build a Ruby on Rails app on AWS for beginners - Part 2.	https://dev.to/leewynne/how-to-build-a-ruby-on-rails-app-on-aws-for-beginners-part-2-21al	How to build a Ruby on Rails app on AWS for beginners Part Now it is time to provision our database We are going to go with Postgres There are ways to do this on AWS we can either install Postgres into our ec Linux host or we can provision the database separately in AWS LightSail as a PaaS RDS database In this example we are just going to install Postgres locally on our LightSail ec instance This is a fairly simple process first of lets install a recent version of Postgres sudo apt install postgresql libpq devNext up we we are going to setup our DB user sudo u postgres createuser lee s If you would like to set a password for the user you can do the followingsudo u postgres psql postgres password leeThat s it for installing and setting up PostGres within an EC instances Let s give this a whirl by creating your first Rails App rails new mynewrailsapp d postgresqlcd mynewrailsapprails db createrails serverVisit http localhost to view your new rails app That should be it you can then go ahead and create some of your models and migrations and start building your dreams	2021-06-29 14:34:31
海外TECH	DEV Community	How to build a Ruby on Rails app on AWS for beginners - Part 1.	https://dev.to/leewynne/how-to-build-a-ruby-on-rails-app-on-aws-for-beginners-part-1-p5n	How to build a Ruby on Rails app on AWS for beginners Part This is part one of a series of posts this post covers the initial provisioning of a Ruby on Rails app on AWS using LightSail which is the simplest way of getting started with compute and databases on AWS Let s get started by creating an AWS account and building a Linux host to run our Ruby on Rails app with AWS LightSail Provisioning a Linux instance to run a Ruby on Rails app on AWS LightSail This post will guide you through getting started with your first AWS LightSail compute instance Before you follow the article though you need to remember to choose Ubuntu as the OS as per below Then select your plan I chose the for now Okay once that s done click on the little command line icon next to you instance and you should get a new console tab all logged in and ready to go Installing Node and Yarn to support Webpacker in Ruby on Rails sudo apt install curlcurl sL sudo E bash curl sS sudo apt key add echo deb stable main sudo tee etc apt sources list d yarn listsudo apt get updatesudo apt get install git core zlibg dev build essential libssl dev libreadline dev libyaml dev libsqlite dev sqlite libxml dev libxslt dev libcurl openssl dev software properties common libffi dev nodejs yarn Installing rbenv and then RubyGreat let s install a Ruby We are going to install it using rbenv which allows you to run multiple versions of Ruby side by side if needed cdgit clone rbenvecho export PATH HOME rbenv bin PATH gt gt bashrcecho eval rbenv init gt gt bashrcexec SHELLgit clone rbenv plugins ruby buildecho export PATH HOME rbenv plugins ruby build bin PATH gt gt bashrcexec SHELLrbenv install rbenv global ruby vNow all we need to do is install bundlergem install bundlerNext up installing Railsgem install rails v To make the Rails executable available rbenv rehashCheck you have everything installed this should return the installed version rails vJob done next up this series is installing PostgreSQL for the DB	2021-06-29 14:28:28
海外TECH	DEV Community	Fast Fulltext Search With Postgres Gin Index	https://dev.to/____marcell/fast-fulltext-search-with-postgres-gin-index-22n5	Fast Fulltext Search With Postgres Gin IndexCreating Fake Realistic DataList Of English WordsPostgres Data Directory Generating The Data Testing Before The IndexCreating The Index And TestingExpression IndexesThe first thing we need to do is to create a lot of fake data so we can test our indexex it s also important to use real words dependending on the index that you re trying to use there s a clever way of doing this on linux if you re not on linux you can download a list of words here Creating Fake Realistic DataThe first thing and maybe the most important part when dealing with indexes or any code for that matter is being able to test it you need to play around with it to figure out what is the best index for your specific query to test indexes we need a lot of data otherwise the query planner won t use our index if you wanna to know more about indexes you can read this List Of WordsIn order to create realistic data we need a list of words on Linux you can grab the word list generated by the spell checker utility on usr share dict the name of the file varies depending on the distribution if you re not on linux you can grab your list of words here Postgres Data DirectoryNow that we have a list of words we need a way of reading this list into postgres so we can generate our data the function pg read file can read anything inside the data directory you can find out where your data directory is runningSHOW data directory The result will probably be something like var lib postgres this also dependends on your OS after getting the path you just need to copy your list of words to this directory so we can use pg read fileto read this list of words and generate our data Generating The DataLet s create a table called notes with two fields title and descriptionCREATE TABLE notes id serial PRIMARY KEY title text description text We can then create a function that will feed us the wordsCREATE OR REPLACE FUNCTION getNArrayS el text count int RETURNS text AS SELECT string agg el random array length el FROM generate series count g i VOLATILELANGUAGE SQL Just copy and paste press enter and things will work I promise PNow we can create the data it will take some time so go grab some tea meanwhile WITH t ray AS SELECT string to array pg read file words list text E n INSERT INTO notes title description SELECT getNArrayS T ray getNArrayS T ray FROM T generate series We re creating one million records insert dr evil meme here with real words in two fields not bad we can increase the amount of words in each field if you want you just need to change in getNArrayS in this case is the number of words in each field now we can test our indexes variations and easily change it depending on what query and index we want to test Testing Before The IndexWe need to test our query now and see how fast it s so we can take note and compare later on after we create our index unfortunatly as far as I know postgres don t have a way of forcing the query planner to use a specific index or not so we need to test first then compare the times later run timingNow every query will show the time it took to run First let s test a simple like we also need to choose one word from our word list ofc I chose asimov SELECT FROM notes WHERE title ilike asi Time mswith an ANDSELECT from notes where title ilike asi and description ilike gar Time mswith a ORSELECT from notes where title ilike asi or description ilike gar Time ms concating the two fieldsselect from notes where coalesce title coalesce description ilike gar Time msOk now let s create the index and compare the time afterwards for each query Creating The Index And TestingLet s first create the trigrams extensions more about this later CREATE EXTENSION IF NOT EXISTS pg trgm Now let s create an index just on the title field using the trigrams extensionCREATE INDEX notes title idx ON notes USING gin title gin trgm ops Since it s very common to search for the first three letters of a word postgres has a trigrams letters that speed up just that it creates a index with the first letters of the words in the field so our queries run even faster now let s test our index with the same query that we used before SELECT FROM notes WHERE title ilike asi Time msAlmost three times faster not bad we can use EXPLAIN to see how the query planner is using our indexEXPLAIN SELECT FROM notes WHERE title ilike asi QUERY PLAN Bitmap Heap Scan on notes cost rows width Recheck Cond title asi text gt Bitmap Index Scan on notes title idx cost rows width Index Cond title asi text We can see that the query is using our index notes title idx subsequent runs willreturn even faster results since the index is already in memory the second run was msmore than x faster the second run without the index woulnd t have made any difference The second query that we want to test has an AND using the description field let s first run the query without a description index to see what happens SELECT from notes where title ilike asi and description ilike gar Time msEven though we don t have a index in description our results are already x faster that s because title is almost instant now and the and query on description don t need to scan the whole table just the result set of the title index before creating the index in the description field let s run the query with the OR clause to seehow it compares to the and querySELECT from notes where title ilike asi or description ilike gar Time msThe same time as before what happened with an OR the query planner needs to scan the whole table again so it decides to not use the index if we run with an EXPLAIN we can see that QUERY PLAN Gather cost rows width Workers Planned gt Parallel Seq Scan on notes cost rows width Filter title asi text OR description gar text The query is not using notes title idx because it would be even slower in this case the reason is becausethe disc would have to be hit three times one for the index read one for the title read and one for the description Now let s create the description index and see how it comparesCREATE INDEX notes description idx ON notes USING gin description gin trgm ops After running the OR query again we have a much better result Time ms almost x faster again we can use explain to see that both indexes are being used now QUERY PLAN Bitmap Heap Scan on notes cost rows width Recheck Cond title asi text OR description gar text gt BitmapOr cost rows width gt Bitmap Index Scan on notes title idx cost rows width Index Cond title asi text gt Bitmap Index Scan on notes description idx cost rows width Index Cond description gar text The last query that we need to improve is the one where we concatenate the two fields title and description and search them we could use an index on both fields together or use one in each like we did in the previous example let s do both and see what s faster To test for both we just need to run the query again since we already have two indexes one in each fieldselect from notes where coalesce title coalesce description ilike gar Time msUsing the coalesce the query planer doesn t use any of our indexes now let s create an index on both fields and see what happenscreate index notes title description idx ON notes USING gin title gin trgm ops description gin trgm ops Running the query again we get the same result in order to speed up a query like this is much better to change the query to use a OR and to use a expression index SELECT from notes where title ilike gar or description ilike gar with an OR we get ms and the query planer is using our multicolumn index notes title description idx that we just created the results of using an multicolumn index are better but not by a lot and depending on how many fields you have in your table the index won t even be used now let s try to create a concatenated index using the two fields that mimics the query that we tried Expression IndexesCREATE INDEX notes coales title description idx ON notes USING gin coalesce title coalesce description gin trgm ops We need the extra parenteshis for the expression now let s run the query againselect from notes where coalesce title coalesce description ilike gar Time msx faster again postgres is smart enough to use our new index notes coales title description idx so that was faster than using the two different indexes in each field with an OR and faster than multicolumn index with an OR The most important thing we can take from these tests is that is hard to predict what postgres will do so you should always test your indexes with the exact query that you re going to use you should try different approaches to figure out what s the fastest for your query and don t be afraid of creating different indexes for different queries and also using indexes for your queries makes them a LOT faster x faster for all these queries that we tried so you should definitely use them	2021-06-29 14:11:42
海外TECH	DEV Community	Introduction To MongoDB and How To Use It	https://dev.to/boiliev/introduction-to-mongodb-and-how-to-use-it-3no1	Introduction To MongoDB and How To Use It IntroductionMongoDB is a NoSQL not only SQL database In NoSQL databases we store our data in a collection of documents These documents are very similar to JavaScript objects or JSON objects So if you are familiar with JavaScript then you are going to like Mongo because it will be easier to get the hang of it MongoDB is very scalable It has built in replication and sharding It s performant it s fast and mostly it s very flexible Because the data structure is like a JavaScript object you don t have to map out your entire data structure beforehand as you do with relational databases Unlike a relational database like MySQL where you have to create all your tables and all your columns Mongo gives you the freedom to structure your data however we want through our application This doesn t mean it s better than relational databases it all depends on how you need to use your database Installing MongoDBWe are going to install MongoDB through Homebrew If you don t have Homebrew installed just run the code below in your terminal and that will install Homebrew bin bash c curl fsSL Once you get Homebrew installed on your Mac just run the three following commands First we run brew tap mongodb brewThen run brew install mongodb community Then after that we will want to run it as a service with the following command brew services start mongodb community And finally we need to run the following command so that we can connect and start using MongoDB mongoThis is what you should see after running the command Now that we have Mongo installed and ready let s start with some of the main commands that you should know Commands Show Current DatabaseThe command for seeing the current database is db Show All DatabasesIn order to see all of the databases just run the following command show dbs Switching and Creating DatabasesIf you want to switch which database you are using just type in use followed by the database name use db nameIf you want to create a DB just type in the use command again followed by your new DBs name use new db nameIf you run show dbs after creating a DB the new DB won t show because it doesn t have anything in it so don t worry when it doesn t show up after running the show dbs Dropping a DatabaseIn order to drop a database or in other words delete it you first need to switch to the database with the use command and after that you need to type in the following command db dropDatabase Creating and Viewing CollectionsTo create a collection in the DB that you are using you just have to run the following command and set the name of your collection db createCollection collection name And if you want to view the collection just run the show command followed by collections and that should print out the collections in your DB show collections Inserting RowsNow in order to insert a row just type in the db followed by the name of the collection that you want to insert the row in and then by insert which is then followed by parentheses And in those parentheses you pass in an object with whatever you want Here is an example of how this should look like db users insert username Batman fan followers following Alred Robin status name Bruce Wayne status active As you can see this looks just like a normal JavaScript object You can store strings numbers arrays and can also have embedded objects inside This is why Mongo is liked by so many because of how similar it is to JS and how easy it is to use If you want to insert more than one row instead of typing insert after the collections name type in insertMany and then insert your rows in an array like this db users insertMany username Tony Montana followers username Hannibal Lecter followers username Rick Grimes followers These rows don t have as many stuff like likes or status which our first row has but that doesn t matter Unlike relational databases in Mongo we don t have that strict data model that we have to follow We can put whatever we want wherever we want which is awesome Viewing RowsTo view the rows of a certain collection just run the following command db collection name find This will print out the data but it will be hard to read Luckily there is a method called pretty which formats all the rows db collection name find pretty And now it will be much easier to read These are some of the main commands that you should know I recommend that you check out this MongoDB Cheat Sheet and have a look at some other commands that might be useful to you ConclusionAs you can see MongoDB looks identical to JavaScript They have similar syntax and are pretty easy to get the hang of If you want to have a MongoDB database cluster production ready I strongly recommend using the new DigitalOcean managed MongoDB clusters which you can deploy with just the click of a button so that you won t have to worry about server maintenance which can be very challenging sometimes If you want you can use this referral code which gives you free DigitalOcean credit If you also want to learn more about SQL and how to use it I highly recommend that you check out this Introduction to SQL opensource ebook It helped me understand how to use SQL and I highly recommend it I hope that this post has helped you get more comfortable with using MongoDB and getting the hang of it	2021-06-29 14:08:16
Apple	AppleInsider - Frontpage News	Apple suppliers gearing up for new AirPods, MacBook Pro releases in late 2021	https://appleinsider.com/articles/21/06/29/apple-suppliers-gearing-up-for-new-airpods-macbook-pro-releases-in-late-2021?utm_medium=rss	Apple suppliers gearing up for new AirPods MacBook Pro releases in late Companies in Apple s supply chain are reportedly increasing production and hiring further staff now to meet Apple s orders for new AirPods and at least one new MacBook Pro Apple component suppliers are said to have recently accelerated their work because of significantly stronger orders for products being released in the second half of According to Economic Daily News the Shin Zu Shing company which produces bearings is estimating that MacBook shipments will be up year on year That would mean million units and at the same time the company is expecting to decrease its shipment of AirPods by up to or up to million Read more	2021-06-29 14:21:49
Apple	AppleInsider - Frontpage News	Nikon Z fc mirrorless camera announced with retro compact design & iPhone connectivity	https://appleinsider.com/articles/21/06/29/nikon-z-fc-mirrorless-camera-announced-with-retro-compact-design-iphone-connectivity?utm_medium=rss	Nikon Z fc mirrorless camera announced with retro compact design amp iPhone connectivityNikon has announced new MP mirrorless DX shooter the retro Nikon Z fc with physical tactile controls a compact build and wireless iPhone connectivity Nikon Z fc in brownA powerful new compact camera Read more	2021-06-29 14:42:56
Apple	AppleInsider - Frontpage News	Duelling hackers may have caused mass WD My Book Live wipes	https://appleinsider.com/articles/21/06/29/duelling-hackers-may-have-caused-mass-wd-my-book-live-wipes?utm_medium=rss	Duelling hackers may have caused mass WD My Book Live wipesThe mass wiping of Western Digital My Book Live storage devices may have been caused by a pair of vulnerabilities and a leading theory suggests that it was fallout from rival hacking groups working against each other July s remote wiping of WD s My Book Live lineup had customers discovering deletion of files and backups with the network storage appliance factory reset While it was attributed to a malware attack of a vulnerability analysis of the event suggests multiple elements were at play including multiple vulnerabilities Security researchers discovered one vulnerability in the system factory restore file where a PHP script performs a reset to default configurations and wipes data While the feature typically would require a user password as authentication the lines of code for the script were commented out making them inoperable Read more	2021-06-29 14:03:15
海外TECH	Engadget	Amazon reportedly pressuring suppliers for a discounted stake in their businesses	https://www.engadget.com/amazon-supplier-stake-warrant-below-market-value-145545027.html?src=rss	Amazon reportedly pressuring suppliers for a discounted stake in their businessesAmazon has reportedly struck dozens of deals with suppliers to buy stakes in their companies potentially at lower rates It has scooped up warrants for at least a dozen publicly traded companies and more than private businesses according to The Wall Street Journal Amazon s stakes and potential stakes in those organizations is worth billions of dollars Warrants work in a similar way to stock options Holders of warrants can buy shares at a fixed price during a certain period If the share price rises during that time the warrant holder can swoop in and buy a stake in the company at a below market rate Amazon is said to have warrant deals with Kohl s aircraft leasing companies call center businesses and hydrogen fuel cell suppliers among others Some of the deals have made Amazon one of the top shareholders in the respective companies according to the report In several cases the ecommerce giant has the right to board seats and an option to outbid any acquisition offers Leaders at some of the companies suggested they couldn t turn down Amazon s proposal else they could risk losing a big contract to a competitor Some chalked up Amazon s demands as the price of doing business Amazon told the WSJ that warrant agreements are part of less than one percent of the deals it agrees with suppliers In some cases the warrants are connected to certain thresholds They often don t come into effect until Amazon purchases a certain level of goods or services We ve seen some other evidence of this strategy in action Last week Amazon ordered autonomous driving systems from Plus a company that develops such tech for self driving trucks It also scooped up the option to buy up to a percent stake in the startup Amazon has reportedly been engaging in this practice over the last decade or so and it s said to have ramped up its efforts to secure warrants over the past few years However with Amazon facing deepening antitrust scrutiny regulators may not look favorably on a report that suggests Amazon is pressuring companies into accepting terms that could force them to sell shares at below market rates	2021-06-29 14:55:45
海外TECH	Engadget	Save $70 on this distraction-free portable writing device	https://www.engadget.com/freewrite-traveler-145530344.html?src=rss	Save on this distraction free portable writing deviceIt s hard to stay focused while writing on your laptop tablet or phone and it s easy to see why Notifications constantly pop up on your screen while the internet and games are just a few clicks away If you re an avid writer it would be worthwhile to invest in a device that limits your distractions without obstructing your workflow That s where Freewrite Traveler can help Successfully funded on Indiegogo the Traveler is a portable writing tool that doesn t just block out distractions it eliminates them outright giving you a reliable way to stay focused on your work Right now you can add the Freewrite Traveler to your home office setup or everyday carry for when you use coupon code FREEWRITE for off With the Traveler you get both the portability of a small tablet and the comfortable typing experience of a full laptop That s because it uses a full sized keyboard with scissor switches for a satisfying tactile response without sacrificing its slim silhouette You can even choose more than keyboard layouts including QWERTY AZERTY DVORAK and more This handheld writing device is lightweight too ーjust shy of two pounds ーnot to mention compact at just inches at its thickest point You ll also find that the E Ink display doesn t wash out under direct sunlight or reflect any glare In fact the display is easier on your eyes than the backlighting from traditional laptops which emit harmful blue light Finally if you were to use the Freewrite Traveler for half an hour a day every day the battery would easily last you up to four weeks The goal behind the Freewrite Traveler is to give writers a tool that allows them to work with no opportunities for distraction To that end it doesn t feature a browser or email app You won t have to worry about space for files on the device either it contains enough internal storage to hold over one million pages The Freewrite Traveler does come with WiFi enabled but it s only there to seamlessly back up your drafts to the cloud Zone in on your work distraction free with the Freewrite Traveler Portable Writing Tool It s on sale right now for or off but you can save an additional when you use FREEWRITE at checkout Prices subject to change Engadget is teaming up with StackSocial to bring you deals on the latest headphones gadgets tech toys and tutorials This post does not constitute editorial endorsement and we earn a portion of all sales If you have any questions about the products you see here or previous purchases please contact StackSocial support here	2021-06-29 14:55:30
海外TECH	Engadget	Omaze's latest sweepstakes offers the chance to win $20,000 towards a gaming PC	https://www.engadget.com/omaze-sweepstakes-win-20000-for-your-ultimate-gaming-pc-141504862.html?src=rss	Omaze x s latest sweepstakes offers the chance to win towards a gaming PCIf you missed Omaze s last PC giveaway you have another opportunity to enter a new one now The company is holding a sweepstakes through September in which you can enter to win towards a gaming PC ーor any PC you want really Enter to win at OmazeAs with most Omaze sweepstakes this one is free to enter but you can choose to buy additional entries and those proceeds will go to charity Funds from this giveaway go to Schools on Wheels which provides free tutoring and mentoring services to children experiencing homelessness across Southern California You can also use the code RADNESS at checkout to get bonus entries through July If you re unfamiliar with Omaze it s a site that raises money for charities through giveaways and experiences Although you don t have to spend money to enter giveaways like this you ll increase your chances of winning if you spend a few bucks on extra entries You can read more about how the allocation of funds works by reading the quot Fundraising Transparency quot section at the bottom of the giveaway page Pricing and availability is subject to change No donation or payment necessary to enter or win this sweepstakes See official rules on Omaze	2021-06-29 14:15:04
海外TECH	Engadget	Apple intros country-specific Watch bands and faces ahead of the Olympics	https://www.engadget.com/apple-watch-international-collection-bands-140218552.html?src=rss	Apple intros country specific Watch bands and faces ahead of the OlympicsApple is once again releasing special edition Watch bands to mark the summer Olympics but this time you won t have to travel to the games not that you likely can to get one The company has launched an Apple Watch International Collection of Sport Loops that should help you cheer your team as it chases medals in Tokyo There s a US band below to no one s surprise but you ll also find straps for countries as wide ranging as Australia Greece it did start the Olympics after all Japan and South Africa No you won t have to go to the trouble of creating a custom watch face The packaging takes advantage of App Clips to help you download a matching Stripes face You can also download them from Apple s website if there s another country you want to support AppleThe International Collection bands are available solely through Apple and sell for in both mm and mm sizes Apple characterizes them as quot limited edition quot although it didn t say how long they ll be available we ve asked for clarification It s safe to say you ll want to get yours quickly if you re interested This is a rare chance to buy an official nation themed Apple Watch band without having to pay a premium for one on an auction site	2021-06-29 14:02:18
Cisco	Cisco Blog	Rural connectivity is the next digital opportunity	https://blogs.cisco.com/sp/rural-connectivity-is-the-next-digital-opportunity	Rural connectivity is the next digital opportunityCisco s Converged Software Defined Networking Transport Architecture is the bridge to reduce the digital divide Recent innovations with the NCS and NCS access routers make serving rural areas more economical and will help to close the gap with rural broadband connectivity and ensure an inclusive future for all	2021-06-29 14:57:36
Cisco	Cisco Blog	The era of the office as we knew it is over	https://blogs.cisco.com/financialservices/the-era-of-the-office-as-we-knew-it-is-over	The era of the office as we knew it is overFor the office to have a future it must offer employees added value Collaboration software and a laptop are no longer enough to be effective and productive in and out of the office It has to be completely rethought	2021-06-29 14:41:02
金融	金融庁ホームページ	経営健全化計画の履行状況報告について公表しました。	https://www.fsa.go.jp/news/r2/ginkou/210629/20210629.html	計画	2021-06-29 16:00:00
ニュース	BBC News - Home	More pupils sent home as Covid disruption soars	https://www.bbc.co.uk/news/education-57640397	isolation	2021-06-29 14:40:23
ニュース	BBC News - Home	Dalian Atkinson: PC Benjamin Monk jailed for ex-footballer's death	https://www.bbc.co.uk/news/uk-england-shropshire-57603091	contact	2021-06-29 14:51:04
ニュース	BBC News - Home	England v Sri Lanka: Sam Billings' 40-metre direct hit ends Sri Lanka innings	https://www.bbc.co.uk/sport/av/cricket/57656177	England v Sri Lanka Sam Billings x metre direct hit ends Sri Lanka inningsSri Lanka s Praveen Jayawickrama is run out by England Sam Billings brilliant metre direct hit during the first ODI at Emirates Riverside	2021-06-29 14:19:32
ニュース	BBC News - Home	Wimbledon 2021: Venus Williams beats Mihaela Buzarnescu to progress into second round	https://www.bbc.co.uk/sport/av/tennis/57654154	Wimbledon Venus Williams beats Mihaela Buzarnescu to progress into second roundWatch the best shots as Five time Wimbledon singles champion Venus Williams beats Romania s Mihaela Buzarnescu to reach the second round	2021-06-29 14:05:27
北海道	北海道新聞	五輪選手への誹謗中傷を監視へ　ＪＯＣ、捜査機関へ通報も	https://www.hokkaido-np.co.jp/article/561355/	捜査機関	2021-06-29 23:14:00
北海道	北海道新聞	届かぬワクチン　道内市町村困惑　接種予約休止の動き	https://www.hokkaido-np.co.jp/article/561352/	感染拡大	2021-06-29 23:08:00
北海道	北海道新聞	ピカソの盗難絵画発見　ギリシャ、４９歳男を逮捕	https://www.hokkaido-np.co.jp/article/561351/	盗難絵画	2021-06-29 23:06:00