投稿時間:2022-08-20 03:24:05 RSSフィード2022-08-20 03:00 分まとめ(27件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
AWS	AWS Database Blog	Access Amazon MemoryDB for Redis from AWS Lambda	https://aws.amazon.com/blogs/database/access-amazon-memorydb-for-redis-from-aws-lambda/	Access Amazon MemoryDB for Redis from AWS LambdaToday marks the one year anniversary of the launch of Amazon MemoryDB for Redis On AWS announced the general availability of Amazon MemoryDB for Redis a fully managed Redis compatible database that delivers both in memory performance and Multi AZ durability Over the past year thousands of customers have adopted MemoryDB as their primary database for critical workloads …	2022-08-19 17:31:16
AWS	AWS Developer Blog	New: AWS CLI v2 installers available over IPv6 connections	https://aws.amazon.com/blogs/developer/new-aws-cli-v2-installers-available-over-ipv6-connections/	New AWS CLI v installers available over IPv connectionsWe are excited to announce that the AWS Command Line Interface AWS CLI v is now available for download over IPv connections Customers can now download the AWS CLI v installers for IPv only environments such as Amazon EC running inside an IPv only Amazon Virtual Private Cloud Previously the AWS CLI v installation packages were only …	2022-08-19 17:31:40
Ruby	Rubyタグが付けられた新着投稿 - Qiita	Railsで途中からDBをsqlite3からmysql2に変更するだけなのに死んだ	https://qiita.com/kei_matsuoka/items/34579f15e1504cfe1d4a	dbmig	2022-08-20 02:34:47
Docker	dockerタグが付けられた新着投稿 - Qiita	Rails7 Mysql8 React TypeScriptで作る Docker環境	https://qiita.com/kandalog/items/80a06114f55bdc07be00	docker	2022-08-20 02:19:22
Ruby	Railsタグが付けられた新着投稿 - Qiita	Railsで途中からDBをsqlite3からmysql2に変更するだけなのに死んだ	https://qiita.com/kei_matsuoka/items/34579f15e1504cfe1d4a	dbmig	2022-08-20 02:34:47
Ruby	Railsタグが付けられた新着投稿 - Qiita	Rails7 Mysql8 React TypeScriptで作る Docker環境	https://qiita.com/kandalog/items/80a06114f55bdc07be00	docker	2022-08-20 02:19:22
海外TECH	MakeUseOf	Adobe Lightroom vs. Photoshop Express: How Do These Mobile Photo Editing Apps Compare?	https://www.makeuseof.com/adobe-lightroom-vs-photoshop-express-mobile-photo-editing-app-compared/	Adobe Lightroom vs Photoshop Express How Do These Mobile Photo Editing Apps Compare The Lightroom and Photoshop Express mobile apps are excellent for photo editors on the go Here s how they compare	2022-08-19 17:30:14
海外TECH	MakeUseOf	11 Well-Hidden Features in Windows 11	https://www.makeuseof.com/windows-11-well-hidden-features/	windows	2022-08-19 17:16:14
海外TECH	DEV Community	CANLI - GALATASARAY ÜMRANİYESPOR MAÇI ŞİFRESİZ İZLE 19 AGUSTOS 2022	https://dev.to/t24tvhd/canli-galatasaray-umraniyespor-maci-sifresiz-izle-19-agustos-2022-59jl	CANLI GALATASARAY ÜMRANİYESPOR MAÇI ŞİFRESİZ İZLE AGUSTOS Click Here gt LIVE gt gt Click Here gt LIVE gt gt Ümraniyespor Galatasaray maçözeti izle saat önce ーÜmraniye Bandırma maçıcanlıizle Birinci Lig in heyecanıbaşladı Trabzonspor Giresunspor Maçözeti izle Youtube Bein Sports TS Giresun BeşiktaşFutbol Takımı Ümraniyespor Galatasaray Maçıcanlıizle kaçak GS Ümraniye saat önce ーÜmraniyespor Galatasaray maçınıbedava bein sports canlıyayın izle bedava Ümraniyespor Galatasaray maçlinki donmadan Ümraniyespor ONLINE IZLE Ümraniyespor Galatasaray maçözeti saat önce ーAlparslan Büyük Selçuklu son bölüm izle Lig in son Erzurum umraniye canlıizle Fenerbahçe ümraniye maçözeti Galatasaray Erzurumspor erzurumspor maçıcanlı GALATASARAY MAÇI CANLI İZLE maçıcanlıgs ümraniyespor maçıcanli izle galatasaray ümraniyespor maçıcanlıizle ümraniyespor galatasaray canlıizle ümraniye gs maçı YouTube ·Murat GDK · saat önce	2022-08-19 17:49:13
海外TECH	DEV Community	...It Works Fine Locally	https://dev.to/render/it-works-fine-locally-1jam	It Works Fine LocallyOur latest blog post by Support Engineer Alan Pinnell Smith When you re ready to deploy to production it can be frustrating to find that your project that worked perfectly on your machine is now throwing errors in the cloud As you can imagine the Support Engineering team at Render helps customers fix these issues on a regular basis so we ve created a checklist to help prevent them in the first place and save us all some time Writing CodeDeploying a project can feel tough especially when you re starting out Web development used to be so straightforward Open up a text editor write some HTML add a few images FTP it all up to a server and you have a website live on the Internet Simpler times ーboring non dynamic table layout under construction GIF “best viewed on Netscape Navigator hit counter times but certainly a lot simpler Fast forward to today and the number of languages frameworks tools design patterns and a multitude of other aspects surrounding web development are staggering and overwhelming I ve been tinkering on the web since the mid s as you can probably tell from the references above but the sheer number of choices available to the modern day web developer makes me wonder how anyone can ever know where to start In addition to the flood of choices the pace at which these things evolve can be very hard to keep up with I m looking at you JavaScript Luckily there are also a huge number of helpful resources out there guides video courses the obligatory blog to do list tutorials and our very own Render Quickstarts and Examples There s also the ever helpful Stack Overflow when you hit that brick wall of an unexpected error message Tools like project scaffolding ORMs and development servers all make it easier to get started with a new project on your machine But when it comes to deploying your code there isn t enough help online Deploying CodeWhen I made the change in my career from being a web developer mainly Ruby to a Support Engineer a few years ago one phrase quickly became apparent as a common sign off …it works fine locally Along with its bedfellows works for me and works on my machine these are phrases we hear often in development and especially in developer support Don t get me wrong it s certainly good to know that there are no glaring code issues preventing a project from spinning up at all However the considerations required to deploy a project in the cloud are an essential part of being a web developer these days Even if it works fine locally chances are it s not going to work fine when you put your shiny new project on someone else s machine or platform We re all keen to get our work out there on the web as soon as possible but environments will differ ーsometimes by a lot You may develop on Windows or macOS or something more exotic but almost always you will deploy to some flavor of Linux Every language framework and tool will have a particular version and likely a sprawling list of dependencies each with its own version dependency and compatibility requirements goes all the way down Again we re lucky to have some great package management tools to keep all that in check for us Render Native Environments help the most commonly used project configurations get up and running as quickly as possible and we inspect your code to supply some defaults along the way But because every project is different the required configuration can be too Here s a checklist that while focused on Render will help you regardless of where you re deploying your project A Deployment ChecklistThis list won t apply to every case but being mindful of these points may make deploying your application and debugging any issues with that deployment a little more tractable Versioning Explicitly define versions Language package manager and packages Render has default language versions for native environments but we d still recommend you set your own version e g Node Python Ruby etc This way you can be sure it s the same as the one you developed on and will continue to stay the same if the default changes in future Configuration Keep configuration in the environment That may sound familiar if you ve ever looked at The Twelve Factor App External service URLs API keys tokens SMTP config etc will be easier to manage per environment if stored in environment variables or as secret files And if you need to share these across services check out Render s Environment Groups Add a Health Check Create an HTTP endpoint in your app to check if your application is live Web Services on Render allow you to specify a health check path that s used to check that a new deploy is working as expected before transitioning requests to it It is also used to check if your app is still up after a deploy Render automatically restarts your app if the health check endpoint is unresponsive A health check endpoint should touch critical parts of your app for example include a simple database connection in it or ping an API endpoint If your checks pass return a response code between and the deploy will be put live If the health check responds with a code the deployment will be marked as a failure and will not proceed Production Builds Verify the dependencies being installed when you build your app in the cloud Use the same tools you did for development e g npm Yarn Node pip Poetry Python Bundler Ruby etc These tools can also have dependency groups like devDependencies dependencies in Node s package json make sure your packages are in the right group and be aware that production mode may not install development group packages Many frameworks also have dev tooling that does things like hot code reloading or just in time compilation The Rails asset pipeline or a Webpack dev server are good examples of this These development helpers are usually unsuitable for production so you should build precompile transpile as your particular project requires To keep your Render build command s tracked along with your code it can be handy to put it in a shell script and use that to set up the environment A simple Node based example would be render build sh usr bin env bash exit on errorset o errexitnpm installnpm buildBooting your application Make sure you start your app in production mode and are not using a development server If you re having trouble with a deploy it can sometimes help to try starting your app in production mode on your dev machine to see if it still works fine locally For Web Services in particular ensure the app server has its host amp port set to and the PORT environment variable respectively You may also want to consider concurrency settings appropriate for your chosen service plan e g worker counts in Throng Node Gunicorn Python Puma Ruby etc File Storage Service runtime instance filesystems are not persistent Render service filesystems and most platforms are ephemeral meaning files written after they re started do not persist after a restart new deploy If you need to persist uploaded generated files between deploys you will need a Render Disk While an ephemeral filesystem may feel counterintuitive at first why can t I just save my uploads to my instance it makes scaling and recovery from outages much more straightforward Cloud deployed instances benefit from being readily disposable recreatable When you do need to store longer term data you can add a Render Disk for file persistence Depending on your data storage needs it may be also worth considering a dedicated database like PostgreSQL or an object storage service like AWS S It s easy to forget about this during development and end up with your application relying on local filesystem storage Custom domains and SSL TLS Configure and secure your custom domain You re unlikely to be running a dev environment on a custom domain or over HTTPS so you may need to make some configuration updates to ensure your app is aware of how it may receive requests like ALLOWED HOSTS in Django etc You may also want to set up a redirect in your code to from the default service name onrender com to your custom domain to keep it canonical SSL TLS Certificates are fully managed on Render and redirection of HTTP requests to HTTPS is automatic You may need to ensure your assets use HTTPS in production if using a full URL and not just a relative path to avoid any mixed content errors With all that said using Docker can sometimes help reduce the burden of thinking about many of the above items by making your dev environment more closely match the production environment but using Docker also adds a bunch of additional complexity and that s a post for another day We ve touched on a lot of areas to get your project deployed successfully but it s hard to cover everything in a blog post If you find you re still having trouble deploying things on Render we re here to help and you can reach us at support render com or post on community render com	2022-08-19 17:40:15
海外TECH	DEV Community	Getting started with Nodejs/Express	https://dev.to/akinmyde/getting-started-with-nodejsexpress-o8e	Getting started with Nodejs ExpressNodeJS is an open source tools that runs on a JavaScript Engine and can be used to executes Javascript code outside a web browser Having worked with Nodejs I can undoubtedly say that Nodejs is really an impressive tool and the community behind it is a massive one Another interesting thing about NodeJS is that it is a backend cross platform Javascript runtime environment To get started with Nodejs we will cover the following IntroductionSetting up Node js and NPMExample Project writing hello world program Installing a package Introduction To get started this is what you need to know Nodejs is a JavaScript runtime built on Chrome s V JavaScript engine NPM is the package manager for JavaScript and the world s largest software registry which has over packages Express js is a Node js web application server framework designed for building single page multi page and hybrid web applications Setting Up NodeJs NodeJS and NPM are two important tools you need to get started and luckily you can get all in one box by downloading NodeJS After downloading and installing it run to code below to be sure that everything is properly installednpm v to know the version of npm you are running currently node v to know the version of node you are running currently Example Project writing hello world program Create a folder name node hello program on your desktop then open your terminal and run the code below and follow the prompt to generate the package json filenpm initrun npm install express to install expresscreate a file called server js and add the code belowconst express require express const app express app get req res gt return res send hello world app listen gt console log app listening on port run node server js on your terminal to start the node server open your browser to see the changes on localhost Yay We are done kindly drop your feedbacks and also share with your friends Thank you	2022-08-19 17:25:00
Apple	AppleInsider - Frontpage News	Apple's latest security update is important, but the mass-media response is unhinged	https://appleinsider.com/articles/22/08/19/apples-latest-security-update-is-important-but-the-mass-media-response-is-unhinged?utm_medium=rss	Apple x s latest security update is important but the mass media response is unhingedThe latest Apple security update contains some fixes that you should apply to your devices but they are nowhere near warranting the amount of ill informed media attention that they re receiving Apple malwareToday s technology related headlines are currently dominated by stories about security vulnerabilities disclosed in a variety of Apple devices Hyperbole abounds including discussions about how the flaws would allow a hacker to take control of your device Read more	2022-08-19 17:29:39
海外TECH	Engadget	Rivian nixes its entry-level R1T and R1S trims due to low demand	https://www.engadget.com/rivian-explore-trim-discontinued-r1t-r1s-ev-171922341.html?src=rss	Rivian nixes its entry level RT and RS trims due to low demandRivian has discontinued the entry level Explore trim for its RT and RS electric vehicles quot After weighing customer demand Rivian decided to remove Explore Package as an option when configuring an RT or RS quot wrote in a support article quot We realize this news comes as a surprise and apologize to customers who have had their planning impacted quot The company said it initially gave customers two package options to offer them quot more variety quot While Rivian expected that many customers would opt for the Explore package it claimed that only a small percentage of them have done so with quot the vast majority quot selecting the Adventure trim The company said that by narrowing its focus to the Adventure trim it would be able to streamline its supply chain and deliver its EVs more rapidly The move means Rivian s electric truck and SUV are getting more expensive for those looking for the cheapest option ーit marks an increase of across the board The RT truck now starts at while the RS costs at least for new orders the latter starts at for those who pre ordered on March st or earlier Those with a pre order for an Explore trim will need to reconfigure their package to an Adventure model by September st Otherwise Rivian will move them out of the production queue Customers with an Explore package pre order will receive their deposit back if they cancel Those with a binding Explore order agreement can cancel by September th for a full refund Meanwhile the quad motor option has increased in price for new orders in the US by and Canada by CAD Rivian is currently testing dual motor versions of the RS and RT Rivian announced price increases of between and for all models earlier this year After a swift backlash it altered those plans and limited the increases to new RT and RS orders though shareholders brought a lawsuit against the company Rivian recently laid off six percent of staff in order to funnel more resources into increasing production It s struggling to build EVs quickly enough to meet demand and it had to slash its production forecast for the year in half to The company s pre order backlog stood at around as of the end of June not counting the electric delivery vehicles Rivian is making for Amazon	2022-08-19 17:19:22
金融	RSS FILE - 日本証券業協会	はじめての資産運用講座　証券投資のはじめの一歩	https://www.jsda.or.jp/jikan/seminar_info/special/special_hajimete2022.html	資産運用	2022-08-19 17:05:00
ニュース	BBC News - Home	Andrew Tate banned from Facebook and Instagram	https://www.bbc.co.uk/news/technology-62602913?at_medium=RSS&at_campaign=KARANGA	andrew	2022-08-19 17:11:17
ニュース	BBC News - Home	Thomas Tuchel: Chelsea boss receives suspended one-match ban for Antonio Conte bust-up	https://www.bbc.co.uk/sport/football/62611712?at_medium=RSS&at_campaign=KARANGA	Thomas Tuchel Chelsea boss receives suspended one match ban for Antonio Conte bust upChelsea boss Thomas Tuchel receives a suspended one match touchline ban and is fined £ for his confrontation with Antonio Conte at the end of Sunday s derby against Tottenham	2022-08-19 17:48:53
ビジネス	ダイヤモンド・オンライン - 新着記事	ビジネスパーソンなら知っておきたい「他人の成功・失敗から学ぶリスク」とは？ - サイコロジー・オブ・マネー	https://diamond.jp/articles/-/307333	考え方	2022-08-20 02:50:00
ビジネス	ダイヤモンド・オンライン - 新着記事	性格までだらしなく見える 「だらしない字」の共通点 - 簡単ルールで 突然、美文字が書ける	https://diamond.jp/articles/-/307564	字にコンプレックスのある方、字がうまくなることを諦めていた方におすすめです。	2022-08-20 02:45:00
ビジネス	ダイヤモンド・オンライン - 新着記事	【本日は大安吉日！】 2枚同時に見るだけで、ものすごいご縁に恵まれる出雲パワー！ 《神迎祭の夜の稲佐の浜》×《結び》＝ダブル強運貯金の新・方程式。 - 1日1分見るだけで願いが叶う！ふくふく開運絵馬	https://diamond.jp/articles/-/307031	【本日は大安吉日】枚同時に見るだけで、ものすごいご縁に恵まれる出雲パワー《神迎祭の夜の稲佐の浜》×《結び》ダブル強運貯金の新・方程式。	2022-08-20 02:40:00
ビジネス	ダイヤモンド・オンライン - 新着記事	【『世界一受けたい授業』で話題】 なぜこんなにも体がガチガチに硬いのか… フィジカルトレーナー・中野ジェームズ修一が解説！ 高齢者でも“体が柔らかい人”のワケ - 10年後、後悔しない体のつくり方	https://diamond.jp/articles/-/307372		2022-08-20 02:35:00
ビジネス	ダイヤモンド・オンライン - 新着記事	【精神科医が教える】憂うつな気持ちを一瞬で消し去る方法 - こころの葛藤はすべて私の味方だ。	https://diamond.jp/articles/-/308096	精神科医	2022-08-20 02:30:00
ビジネス	ダイヤモンド・オンライン - 新着記事	【素朴な疑問】人間の意識はいったい何の役に立っているのだろうか？ - ダマシオ教授の教養としての「意識」	https://diamond.jp/articles/-/308095	貢献	2022-08-20 02:25:00
ビジネス	ダイヤモンド・オンライン - 新着記事	「開眼した」が口癖の「悟りを開く系女子」になると人生がもっと生きづらくなる理由 - 私の居場所が見つからない	https://diamond.jp/articles/-/308109		2022-08-20 02:20:00
ビジネス	ダイヤモンド・オンライン - 新着記事	国税庁「300万円以下は副業ではない」 サラリーマンなら「2つ目の稼ぎ口」に 今すぐ取り組むが大正解な理由 - 40代からは「稼ぎ口」を2つにしなさい	https://diamond.jp/articles/-/308207	国税庁「万円以下は副業ではない」サラリーマンなら「つ目の稼ぎ口」に今すぐ取り組むが大正解な理由代からは「稼ぎ口」をつにしなさい「このまま」今の仕事を続けても大丈夫なのかあるいは「副業」をしたほうがいいのかそれとも「起業」か、「転職」をすべきなのかこのように感じたとしたら、それは皆さんの考えが正しい。	2022-08-20 02:15:00
ビジネス	ダイヤモンド・オンライン - 新着記事	【これを思い出せばいい】他人へのイライラが1秒で消える方法 - ありがとうの神様――神様が味方をする習慣	https://diamond.jp/articles/-/307561	【これを思い出せばいい】他人へのイライラが秒で消える方法ありがとうの神様ー神様が味方をする習慣年の発売以降、今でも多くの人に読まれ続けている『ありがとうの神様』。	2022-08-20 02:05:00
北海道	北海道新聞	ＪＲ札幌駅「情報館」休止や仮移転　道新幹線工事で９月下旬から	https://www.hokkaido-np.co.jp/article/719619/	北海道新幹線	2022-08-20 02:02:19
GCP	Cloud Blog	Leveling up your data analysis skills as a student	https://cloud.google.com/blog/topics/developers-practitioners/leveling-your-data-analysis-skills-student/	Leveling up your data analysis skills as a studentIf you re a college student like me and are gearing up to enter the “big kids job market as I like to call it then you ve probably been wondering or worrying about how to get ahead of the curve and stand out amongst your peers When I think about which high value fields to target for improving my technical skills and qualifications the one area I keep coming back to is data analysis  Why learn data analysis Data in all forms is becoming increasingly valuable in our technology driven society and that is because of the insights that it brings The amount of data being generated around us is growing exponentially in all fields This is great news for students because now you can benefit from learning data analysis to complement your existing skills whether you re majoring in computer science marketing or even music Having the skills necessary to manipulate process analyze and display data in a meaningful way will push you ahead regardless of your background  What I consider when learning a new skillLearning new tech skills and tools on top of coursework jobs and internships can seem daunting Trust me I know your pain That s why it s so important for us as students to be strategic and efficient in how we discern the best resources to use for learning Whenever I want to learn a new software or skill there are a few factors I take into account that I m sure are important to you too How much is this going to cost me How much time is this going to take How applicable is this to my job prospects CostI m not even going to pretend this isn t one of the first things I think about Knowing how to allocate your financial resources is a vital skill especially when it comes to career oriented self improvement TimeAnd time Well that is a cost as well Time is valuable for us students sometimes even more valuable than money itself We re juggling coursework and studying commute time extracurriculars career development and sometimes even a job to help pay for it all We re looking for skills that are relatively straightforward to learn and that we can learn on our own time on a flexible self paced schedule ApplicabilityLastly I want to be able to learn a skill or tool that is applicable to my job search something that I can list directly on my resume that will be attractive to the type of companies that I will be applying to After all furthering your career is one of the main drivers for this kind of self study That is why I always look for opportunities to learn directly using industry standard software and services Learning data analysis with Google CloudDuring my internship here at Google I ve been given ample opportunities to build my data analysis skills using Google Cloud services In this blog post I focus specifically on two of those services BigQuery and Data Studio What is BigQuery BigQuery is a cloud data warehouse that companies use for running analytics on large datasets It also happens to be a great place for learning and practicing SQL the language for analyzing data The “getting started experience with BigQuery is smooth and saves students tons of time Instead of downloading and installing database software sourcing data and loading it into tables you can login to the BigQuery sandbox and immediately start writing SQL queries or copying sample ones to analyze data provided as part of the Google Cloud public datasets program which you will see for yourself soon What is Data Studio Data Studio is an online business intelligence tool integrated with BigQuery for visualizing data in customizable and informative tables dashboards and reports You can use it to visualize the results of your SQL queries it s also great for analyzing data without SQL and for sharing insights with non technical users Because Data Studio is already part of Google Cloud there s no need to export queried processed data to an external tool Data visualization can be completed through direct connections to the BigQuery environment which saves you lots of time and headaches from having to worry about things like data file compatibility size and so on You can go from the BigQuery Console to visualizing your query results in Data Studio in one click Both BigQuery and Data Studio can be used for little to no cost within the free tier of Google Cloud This tier allocates users a starting amount of data storage if you want to upload your own and allows a certain amount of bytes processed for your queries each month You can even create a BigQuery “sandbox environment that stays within this free tier and doesn t require any credit card to set up I ll give you instructions on how to set one up later So you can get started quickly with BigQuery and Data Studio for free let s talk about applicability Both BigQuery and Data Studio are used across many industries in production workloads today Just search BigQuery or Data Studio on LinkedIn and you ll see what I mean Getting started with BigQuery and Data StudioNow let s get to the action I want to show you just how simple it is to get started with both of these tools so here s a quick tutorial on using BigQuery and Data Studio with a real public dataset Let s dive into an example scenario that BigQuery can help solve Congrats You re a new intern who recently got hired by Pistach io Pistach io is adamant that for the first couple of weeks new hires come into the office for training programs So you must make sure that you show up on time Pistach io is in New York City and the office does not have accessible parking nearby You know that New York City has reimplemented its public bike program so you ve decided to use bike sharing to get to work Because you must be at work on time you need answers to a few key questions  Which nearby stations have bikes you can use in the morning   Where is the drop off location that is closest to the office   What are the busiest stations that you should avoid It would be great to answer these questions using a public dataset Luckily for you BigQuery has tons of datasets available for you to use for no cost The data that you ll be analyzing for this example is in the New York Citi Bike public dataset  Getting set upFirst create a BigQuery sandbox which is essentially an environment for you to work in Follow these steps to set one up In the Google Cloud console go to the BigQuery page documentation In the Explorer pane click  Add Data gt Pin a project gt Enter project name Type “bigquery public data and click Pin This project contains all the datasets available in the public datasets program To see underlying datasets expand the bigquery public data project in the Explorer pane and scroll to find “new york citibike Click to highlight the dataset or expand to see the citibike stations and citibike trips tables You can then highlight the tables themselves to see more details like the schema and a preview of the data  Now time to queryOk on to the analysis Let s figure out which stations are closest to home For this tutorial you will be using the Port Authority Bus Terminal in NYC as your home This query calculates the distance between each Citi Bike station and your home and then returns the result with the closest station listed first The ST DISTANCE function calculates the shortest distance between two points So more like a bird flying than taking a bike to work but it ll work for this use case Next let s find the stations closest to the office Let s use the coordinates for the Google NYC Chelsea Market office since that is where I worked this summer You can use essentially the same query as the last Finally let s identify the most popular Citi Bike stations around the office so that we can avoid them This query uses a subquery to calculate the number of overall trips for each station and then joins it with a list of each station and its distance to the office to list the closest first Looks like I ll be avoiding the th and Greenwich station Query results showing the closest stations to my office and the total number of trips starting at each station Visualize the resultsOne of the great things about BigQuery is that you can visualize your results easily with Data Studio just press the Explore Data button in the query results page This will give you a better idea of what exactly you queried A quick visualization of the results from the final query If you want to try out Data Studio for yourself I recommend following this tutorial It s also about bike share trips but this time in Austin Texas Next steps​​It s really that simple Google Cloud is easy to learn and use so you spend less time “getting started and more time analyzing data and designing visualizations You can see the potential in using something like this in your personal and professional tech development and there are so many ways to boost your skills and early career in data science with Google Cloud tools such as BigQuery You can also supplement what you ve learned in this post by completing the From Data to Insights with Google Cloud specialization on Coursera  That s all I have to share for now If you found this blog post helpful be sure to share You can find more helpful content on the Google Cloud Platform blog	2022-08-19 18:24:00