投稿時間:2020-08-21 02:39:01 RSSフィード2020-08-21 02:00 分まとめ(43件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
python	Pythonタグが付けられた新着投稿 - Qiita	Pythonでデーモンを作ってみた	https://qiita.com/Lycolia/items/e0e4c2bcd6c179e08afd		2020-08-21 01:07:39
js	JavaScriptタグが付けられた新着投稿 - Qiita	様々なJavaScriptの資格を紹介する	https://qiita.com/risto24/items/88252686c95e50467919	MicrosoftTechnologyAssociateMTA認定は、プログラミングからデータベース管理、セキュリティに至るまで、Webを開発する上で必要な基本的な知識と必要なスキルを候補者が持っていることを確認するプログラムになります。	2020-08-21 01:58:23
js	JavaScriptタグが付けられた新着投稿 - Qiita	Youtube に『ここすき』ボタン入れてみた：時間コメント自動入力	https://qiita.com/John_give_me_a_break/items/ac539cc1e6a65656d0de	ここを参考にしました。	2020-08-21 01:33:16
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	VCCodeのSystem.outに波線の表示	https://teratail.com/questions/286224?rss=all	ebefadbaeafeapng	2020-08-21 01:38:25
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	PythonのKivyで押したボタンのidを関数に渡したい。	https://teratail.com/questions/286223?rss=all	前提・実現したいことkivyでボタンを個配置し、押したボタンに応じて、ラベルの表示を変えることをしたい。	2020-08-21 01:26:11
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	スケッチわかりやすく解説お願いします。	https://teratail.com/questions/286222?rss=all	スケッチわかりやすく解説お願いします。	2020-08-21 01:25:27
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	Python ローカル変数の値をforで使いたい	https://teratail.com/questions/286221?rss=all	error	2020-08-21 01:13:08
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	Djangoでseleniumを使ってスクレイピングした複数のデータをリストにいれて表示させることができない。	https://teratail.com/questions/286220?rss=all	Djangoでseleniumを使ってスクレイピングした複数のデータをリストにいれて表示させることができない。	2020-08-21 01:12:26
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	IAMロールについて	https://teratail.com/questions/286219?rss=all	IAMロールについてこちらの質問からです。	2020-08-21 01:11:55
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	テキストファイルを書き込みでオープン	https://teratail.com/questions/286218?rss=all	テキストファイルを書き込みでオープン下のような感じで成績をランダムに個表示してそれの合計と平均を出すプログラムを作ってみました。	2020-08-21 01:08:58
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	cakephp3.9がインストールできない。	https://teratail.com/questions/286217?rss=all	cakephp が インストール でき ない 。	2020-08-21 01:01:15
Ruby	Rubyタグが付けられた新着投稿 - Qiita	Active Record のアソシエーション（has_many, belongs_to）に条件を付けるときは一番最初の引数に lambda を渡さなければならない	https://qiita.com/ikamirin/items/28559456411affd17361	ActiveRecordのアソシエーションhasmanybelongstoに条件を付けるときは一番最初の引数にlambdaを渡さなければならない概要ActiveRecordのアソシエーションhasmanybelongstoに条件付けをしたはずなのに、その条件が動作しない場合があるので共有です。	2020-08-21 01:59:01
Ruby	Railsタグが付けられた新着投稿 - Qiita	Active Record のアソシエーション（has_many, belongs_to）に条件を付けるときは一番最初の引数に lambda を渡さなければならない	https://qiita.com/ikamirin/items/28559456411affd17361	ActiveRecordのアソシエーションhasmanybelongstoに条件を付けるときは一番最初の引数にlambdaを渡さなければならない概要ActiveRecordのアソシエーションhasmanybelongstoに条件付けをしたはずなのに、その条件が動作しない場合があるので共有です。	2020-08-21 01:59:01
技術ブログ	Developers.IO	Notion : Personal Kanban board	https://dev.classmethod.jp/articles/notion-personal-kanban-board/	Notion Personal Kanban boardสวัสดีค่ะทุกคนบล็อกครั้งนี้นอกจากจิ๋วจะเขียนเกี่ยวกับวิธีการใช้Notion แอพจัดการข้อมูลที่เคยแนะนำทุกคนไปเมื่อ	2020-08-20 16:14:49
Apple	AppleInsider - Frontpage News	Lyft suspends rideshare in California, Uber likely to follow	https://appleinsider.com/articles/20/08/20/lyft-suspends-rideshare-in-california-uber-likely-to-follow	Lyft suspends rideshare in California Uber likely to followThe car transport company Lyft has declared that it will shut down its ridesharing operation in response to local politicians push to revamp its business model and change the employment status of its drivers ーand Uber is likely right behind it Lyft has announced that it will cease all of its rideshare operations throughout California from PT today August It is in response to the State s proposal to revise how its drivers are to be classified as employees instead of independent contractors This is not something we wanted to do as we know millions of Californians depend on Lyft for daily essential trips said the company in a statement We re personally reaching out to riders and drivers to share more about why this is happening what you can do about it and to provide some transportation alternatives Read more	2020-08-20 16:48:48
Apple	AppleInsider - Frontpage News	Apple secretly acquired a camera startup and has already used its AR technology	https://appleinsider.com/articles/20/08/20/apple-secretly-acquired-a-camera-startup-and-has-already-used-its-ar-technology	Apple secretly acquired a camera startup and has already used its AR technologySometime between and Apple quietly acquired an Israeli computer vision company ーand has already adapted its developments into current products Credit Andrew O Hara AppleInsiderApple AR technology and related developments have picked up the pace since the release of ARKit in And per a new report some of that development may have been the result of secretive acquisitions instead of internal research Read more	2020-08-20 16:50:17
Apple	AppleInsider - Frontpage News	Apple must face sex bias lawsuit from janitorial service, California judge rules	https://appleinsider.com/articles/20/08/20/apple-must-face-sex-bias-lawsuit-from-janitorial-service-california-judge-rules	Apple must face sex bias lawsuit from janitorial service California judge rulesApple must contend with a lawsuit that accuses it of canceling a janitorial services contract because the owner is a woman a judge ruled Wednesday Credit AppleThe original complaint Industrial Janitorial Service v Apple Inc was lodged in a California state court in and accused the Cupertino based company of sex bias in its decision to terminate its contract with the plaintiff Read more	2020-08-20 16:19:29
Apple	AppleInsider - Frontpage News	Affordable Apple Watch, Apple game controller coming says prolific leaker	https://appleinsider.com/articles/20/08/20/affordable-apple-watch-apple-game-controller-coming-says-jon-prosser	Affordable Apple Watch Apple game controller coming says prolific leakerApple wants to build its own game controller and may release a cheaper Apple Watch soon according to avid leaker Jon Prosser The upcoming iPhone lineThe public Twitter Q A took place on Thursday morning and the conversation with Prosser spanned a large swath of Apple s product line Read more	2020-08-20 16:32:18
Apple	AppleInsider - Frontpage News	Apple has a clear path to a $3 trillion valuation with 5G, health	https://appleinsider.com/articles/20/08/20/loup-ventures-says-apple-has-a-clear-path-to-a-3-trillion-valuation	Apple has a clear path to a trillion valuation with G healthApple recently hit a trillion market capitalization milestone and Loup Ventures Gene Munster said the company has a clear path to trillion Credit Laurenz Heymann UnsplashThe Cupertino tech giant hit a trillion valuation on Wednesday with shares briefly hitting in intra day trading Apple s stock price has rallied more than since the beginning of Read more	2020-08-20 16:33:29
Apple	AppleInsider - Frontpage News	Western Digital announces My Passport SSD in 500GB and 1TB capacites	https://appleinsider.com/articles/20/08/20/western-digital-announces-my-passport-ssd-in-500gb-and-1tb-capacites	Western Digital announces My Passport SSD in GB and TB capacitesWestern Digital s palm sized My Passport SSD offers fast transfer speeds with USB C connectivity in a portable package My Passport SSD boasts read speeds of MB s and write speeds of up to MB s It features a USB type C port and includes a USB C cable and a USB A adapter for older devices Use of the USB A adapter will effectively cut drive speeds in half though This SSD features shock and vibration resistance and is drop resistant up to feet Users can protect their sensitive information thanks to its password enabled bit AES hardware encryption Read more	2020-08-20 16:48:35
海外TECH	Engadget	Korg's Volca Sample 2 is a huge upgrade in almost every way	https://www.engadget.com/korg-volca-sample-2-upgrade-midi-usb-sampler-164549834.html	Korg x s Volca Sample is a huge upgrade in almost every wayKorg s Volca Sample is one of the most beloved members of beloved family of affordable and portable instruments But it s far from perfect Now after almost six years since its introduction the Sample is getting a sequel The Volca Sample is visu	2020-08-20 16:45:49
海外TECH	Engadget	Lyft will stop running in California at midnight	https://www.engadget.com/lyft-california-operations-drivers-employees-163230295.html	Lyft will stop running in California at midnightLyft will suspend its operations in California at PM Pacific Time An injunction that requires the company to reclassify its drivers as employees is set to take effect on Friday Earlier this month Lyft and Uber both said they would temporarily	2020-08-20 16:32:30
海外TECH	Engadget	DoorDash adds on-demand grocery delivery to its app	https://www.engadget.com/doordash-on-demand-grocery-delivery-app-161736445.html	DoorDash adds on demand grocery delivery to its appSince the pandemic began DoorDash has been steadily expanding its on demand delivery portfolio Today the company announced that it s adding on demand grocery delivery to its app More than items will be available for delivery in under an ho	2020-08-20 16:17:36
海外TECH	Engadget	'Control' publisher doubles down on limited next-gen upgrades	https://www.engadget.com/control-505-games-no-free-ps5-xbox-series-x-upgrade-explanation-160316740.html	x Control x publisher doubles down on limited next gen upgradesControl is an atmospheric stunner of a game so it s no surprise that publisher Games wants to introduce it to new players in the form of an Ultimate Edition Even better decided to offer a complimentary next gen upgrade so people who own t	2020-08-20 16:03:16
海外TECH	Network World	BrandPost: Securing Remote Workers Should be Part of an Integrated Security Strategy	https://www.networkworld.com/article/3572289/securing-remote-workers-should-be-part-of-an-integrated-security-strategy.html#tk.rss_all	BrandPost Securing Remote Workers Should be Part of an Integrated Security Strategy Ongoing business transformation has put IT teams under enormous pressure to continually expand and retool networks to keep up This is especially true for cybersecurity devices which have traditionally been deployed to monitor and secure largely static network environments But now because of the rapid and continuous pace of digital innovation those security tools are struggling to keep up The quick transition to a remote workforce which essentially inverted the network by placing most workers outside the traditional security border is just the latest example Now more than ever it is essential that security tools no longer be deployed as separate elements of the network And they don t need to be linked to network components but networking and security elements need to be woven together into a single solution To read this article in full please click here	2020-08-20 16:36:00
海外TECH	CodeProject Latest Articles	How to Access Remote Scanners from Mobile Web Browsers via Network	https://www.codeproject.com/Articles/5276938/How-to-Access-Remote-Scanners-from-Mobile-Web-Brow	How to Access Remote Scanners from Mobile Web Browsers via NetworkWith Dynamic Web TWAIN v and a few lines of code web developers can rapidly build cross browser web apps to control remote scanners which are to PCs servers or embedded devices	2020-08-20 16:01:00
海外科学	NYT > Science	Covid-19 News: Live Updates	https://www.nytimes.com/2020/08/20/world/covid-19-coronavirus.html	Covid News Live UpdatesOverburdened health care specialists are finding themselves on the front lines as schools reopen India s crisis is now spreading to the hinterlands along its southern coastline	2020-08-20 16:53:20
海外科学	NYT > Science	Pediatric Doctors Group Apologizes for Racist Past Toward Black Physicians	https://www.nytimes.com/2020/08/20/health/pediatrics-medicine-racial-discrimination.html	Pediatric Doctors Group Apologizes for Racist Past Toward Black PhysiciansThe American Academy of Pediatrics recently joined other prominent medical organizations in confronting its history of discrimination	2020-08-20 16:12:36
金融	金融庁ホームページ	金融審議会「市場ワーキング・グループ」（第30回）議事録を公表しました。	https://www.fsa.go.jp/singi/singi_kinyu/market_wg/gijiroku/20200715.html	金融審議会	2020-08-20 17:00:00
海外ニュース	Japan Times latest articles	Prosecutors arrest lawmaker Akimoto over witness tampering in bribery case	https://www.japantimes.co.jp/news/2020/08/20/national/crime-legal/tsukasa-akimoto-witness-tampering-casino-bribery/	Prosecutors arrest lawmaker Akimoto over witness tampering in bribery caseThe prosecutors want to confirm whether Akimoto was involved in three men s attempt to have suspected bribers commit perjury in a case linked to a	2020-08-21 02:04:32
海外ニュース	Japan Times latest articles	Virus forces tourism rethink in Bangkok, the world’s most visited city	https://www.japantimes.co.jp/news/2020/08/20/asia-pacific/coronavirus-tourism-rethink-bangkok/	Virus forces tourism rethink in Bangkok the world s most visited cityA record million foreign visitors visited Thailand last year accounting for percent of gross domestic product This year a maximum of million	2020-08-21 01:18:21
海外ニュース	Japan Times latest articles	Japan criticized for weak presence in responding to Mauritius oil leak	https://www.japantimes.co.jp/news/2020/08/20/national/mauritius-oil-leak-japanese-response/	Japan criticized for weak presence in responding to Mauritius oil leakThe government has maintained a distant attitude about the crisis compared with countries such as France and India according to residents and environmental groups	2020-08-21 01:02:24
海外ニュース	Japan Times latest articles	Railway stamp books proving popular across Japan	https://www.japantimes.co.jp/life/2020/08/20/general/railway-stamp-books-proving-popular-across-japan/	different	2020-08-21 02:00:08
ニュース	BBC News - Home	Coronavirus: Portugal added to UK exemption list as Croatia is removed	https://www.bbc.co.uk/news/uk-53854948	secretary	2020-08-20 16:46:08
ニュース	BBC News - Home	Steve Bannon charged with fraud over Mexico wall funds	https://www.bbc.co.uk/news/world-us-canada-53853297	border	2020-08-20 16:25:16
ニュース	BBC News - Home	Coronavirus: Quarantine lifted for Portugal travel, and a back garden beauty salon	https://www.bbc.co.uk/news/uk-53852418	outbreak	2020-08-20 16:37:39
ニュース	BBC News - Home	Alexei Navalny: 'Poisoned' Russian opposition leader in a coma	https://www.bbc.co.uk/news/world-europe-53844958	siberian	2020-08-20 16:13:38
ニュース	BBC News - Home	Coronavirus: Singing 'no more risky than talking'	https://www.bbc.co.uk/news/health-53853961	similar	2020-08-20 16:43:06
北海道	北海道新聞	富里浄水場は復旧完了　胆振東部地震２年　被災地の工事現場公開	https://www.hokkaido-np.co.jp/article/452330/	工事現場	2020-08-21 01:28:00
北海道	北海道新聞	畑岡が７４、上田が７５　全英ゴルフ、渋野苦戦	https://www.hokkaido-np.co.jp/article/452273/	女子ゴルフ	2020-08-21 01:11:54
北海道	北海道新聞	小樽市立病院、新規外来・入院を休止　クラスター発生受け	https://www.hokkaido-np.co.jp/article/452326/	小樽市立病院	2020-08-21 01:13:43
北海道	北海道新聞	夕張メロン９月中旬まで販売　品種改良、五輪需要見据え作付け	https://www.hokkaido-np.co.jp/article/452259/	品種改良	2020-08-21 01:02:08
GCP	Cloud Blog	3 reasons to consider Cloud Spanner for your next project	https://cloud.google.com/blog/products/databases/spanner-relational-database-for-all-size-applications-faqs/	reasons to consider Cloud Spanner for your next projectA database is a key architectural component of almost every application When you design an application you ll invariably need to durably store application data Without persisting data to a shared database there are neither options for application scalability nor for upgrades to the underlying hardware More disastrous any data will be immediately lost in the case of infrastructure failure  With a reliable database though you enable application scalability and ensure data durability and consistency service availability and improved system supportability A database is a key architectural component of almost every application Google Cloud s Spanner database was built to fulfill needs around storing structured data for products here at Google and at our many cloud customers Spanner is part of Google s core infrastructure trusted to safeguard our businessーso you can too regardless of your industry or use case Before Spanner our products predominantly used sharded MySQL for database use cases where transactions were needed The goal of the development effort as described in the Spanner paper was to create a data storage service for those applications that have complex evolving schemas or those that want strong consistency in the presence of wide area replication One of the first concepts that comes up when considering Spanner is its ability to scale to arbitrarily large database sizes Spanner does indeed support Google applications such as Gmail and YouTube that provide features for billions of our users so scalability must be a first class feature  In this post we ll explore how Spanner is designed for applications that operate at any scale big or small across a variety of use cases how it provides a low barrier to entry for developers and how it lowers total cost of ownership TCO Here s what you need to know Start anywhere and scale as you growSpanner can handle data volumes at a massive scale so it s useful for applications of many sizes not just those large ones Further your organization can benefit from standardizing on a single database engine for all workloads that require an RDBMS Spanner provides a solid foundation for all kinds of applications with its combination of familiar relational database management system RDBMS features such as ANSI SQL DML Foreign Keys and unique features such as strong external consistency via TrueTime and high availability via native synchronous replication  We d like to take a moment to challenge what smaller scale may be perceived as that smaller applications are not important or that they do not have lofty availability goals or the need for transactional fortitude This categorization does not indicate that an application is any less business critical than a massive scale application Nor does it imply that a given application will not eventually require higher scale than at its initial rollout While your application might have a small user base or transaction volume to start this Spanner scalability advantage should not be overlooked An application designed with a Spanner back end will not require a rewrite or any sort of database migration if success results in future data volume or transaction growth  For example if you are a gaming company developing the next cool groundbreaking game you want to be prepared to meet user growth if the game is a runaway success on launch day No matter the scale of your application there are strong benefits when you choose Spanner including transaction support high availability guarantees read only replicas and effortless scalability  Transaction support and strong external consistencySpanner provides external consistency guarantees via TrueTime Spanner uses this fully redundant system of atomic clocks to obtain timestamps from what amounts to a virtual distributed global clock Since Spanner can apply a timestamp from a globally agreed upon source to every transaction upon commit the transaction commit sequence is unequivocal External consistency requires that all transactions be executed sequentially Spanner satisfies this strong consistency guarantee  Strong consistency is required by many application types especially those where quantities of goods or currency are maintained and for which eventual consistency would not be at all suitable That includes but is not limited to supply chain management retail pricing and inventory management and banking trading and ledger applications If your database does not have strong consistency transactions must be split into separate operations If a transaction is not atomic that means that the transaction can partially fail Imagine that you use a digital wallet to divide expenses such as the cost of dinner with friends If a money transfer from your wallet to their wallets were not handled within a strongly consistent transaction you could find yourself in the position where half of the transaction has failed the funds are in neither your nor your friend s wallet  The undesirable characteristics of eventual consistency is in the name immediately after a database operation the overall database state is inconsistent only eventually will the changes be served back to all requesters In the interim disparate client requests may return different results If you use a social media service for example you have likely experienced a lag time between pressing the button to post a picture and the moment that the image is shown on your timeline Niantic the creators of Pokemon GO choose Spanner specifically to avoid this type of inconsistency in their social application You can find more detail in this blog post on strong consistency Essentially what we ve learned at Google is that application code is simpler and development schedules are shorter when developers can rely on underlying data stores to handle complex transaction processing and keeping data ordered To quote the original Spanner paper “we believe it is better to have application programmers deal with performance problems due to overuse of transactions as bottlenecks arise rather than always coding around the lack of transactions High availability guaranteesSpanner offers up to availability with zero downtime for planned maintenance and schema changes Spanner is a fully managed service which means you don t need to do any maintenance Automatic software updates and instance optimizations happen in the background This is achieved without any maintenance windows Moreover in case there is a hardware failure your database will seamlessly recover without downtime A Spanner instance provides this high availability via synchronous replication between three replicas in independent zones within a single cloud region for regional instances and between at least four replicas in independent zones across two cloud regions for multi region instances Spanner regional instances are available in various regions in our Asia Pacific Americas and Europe Middle East and Africa geographies multi region instances are offered in various combinations of regions across the globe This protects your application from both infrastructure and zone failure for regional instance configurations and region failure for multi regional instance configurations Read only replicasIf you re working with read requests that can tolerate a minor amount of data staleness you can take better advantage of the computing power made available by these replicas and receive results with lower average read latency This reduction of latency can be significant if you are using a multi region instance configuration with replicas in geographic proximity to your application client For queries that can accept this constraint replicas are able to provide direct responses to your stale read queries without consulting the read write replica the split leader In the case of multi region instance configurations the replicas may be much closer geographically to the application client which can markedly improve the read performance  This capability is comparable to horizontal scaling that s achieved when traditional RDBMS topologies are deployed with asynchronous read replicas However unlike a typical relational database Spanner delivers this feature without incurring additional operational or management overhead Effortless horizontal upscaling and downscalingSpanner decouples compute resources from data storage which makes it possible to increase decrease or reallocate the pool of processing resources without any changes to the underlying storage This is not possible with traditional open source or cloud based relational database engines This means that with a single click or API call horizontal upscaling is possible so you can serve higher operations per second capacity as required by your application even if data throughput remains low Moreover the additional compute resources added can process both reads and writes  Scaling down is just as simple Spanner provides this capability at the press of a button as instance nodes can be added or removed easily as your needs change and these changes take effect in just a few seconds In other databases both relational and NoSQL significant effort is required to grow a cluster horizontally to support additional write capacity Further it may not be straightforward or even possible to remove the capacity once added Spanner stands out as a general use databaseThe relational database is based on concepts outlined in a paper written by E F Codd and despite being the oldest continually used database technology the RDBMS retains its position as the database of choice for most new projects  The relational database is trusted technology and many successful companies have published lore relating to their initial choice of MySQL or PostgreSQL Companies choose the technology because developers know SQL and because the relational model is flexible during the product development process To the point made earlier it is worth mentioning that in many cases these origin stories go on to discuss the extreme management effort associated with relational databases once data volumes exceed an unmanageable level Of course with Spanner there are more abstract concepts involved Spanner is a distributed database and its strong external consistency is provided by a robust system featuring redundant local and remote atomic clocks located on the server racks and available via GPS signal respectively Yet it still presents the familiar ANSI SQL compliant interface of a relational database As a result application developers can quickly achieve proficiency  The database technology has proven its worth for countless applications at Googleーinternal and external big and small Spanner is firmly seated as a foundational technology that enables a low barrier of entry for developers and thus the freedom to try new ideas  While our user bases can be extremely large and transaction volumes can be exceptionally high for some product applications there are other less frequently used applications that serve smaller cohorts Spanner serves as the back end data storage service for both application categories And Google Cloud customers across various verticals have used Spanner successfully for numerous core business use cases gaming Lucille Games fintech Vodeno healthcare Maxwell Plus retail L L Bean technology Optiva and media and entertainment Whisper Here are examples of how those in various industries use Spanner Spanner lowers TCO with a simpler experience When considering the total cost of ownership TCO Spanner costs less to operate Moreover when you consider opportunity cost the return on investment ROI can be even higher Before you solely evaluate the operating expense of Spanner using the per hour price compare it to other database options by contrasting holistically the various costs of an alternate choice with the value provided by Spanner First consider the cost of running a production grade database There are three cost categories resource operational and opportunity Resource cost is relatively straightforward to calculate as it is based on published list prices Operational costs are somewhat more difficult to calculate as this cost is equivalent to the number of team members required to complete various tasks Opportunity cost calculation is less tangible but should not be ignored When you choose to expend organizational budget in currency or in hours toward one effort category there will be less budget available for other opportunities For this exercise we ll first discuss resource cost by comparing the list price of Spanner compared with that of a self managed open source database running on virtual machines Then we ll compare the operational burden and cost of the same environments Finally we ll address some opportunity value provided by Spanner To start when you consider a single database engine running on a small virtual machine Spanner may appear costly However it is not recommended to run a production database on a single compute node More likely you will be running on a medium sized virtual machine with sufficient memory and attached persistent disk provisioned with sufficient headroom for short to medium term growth Also likely is that you will have provisioned a high availability database topology which includes an online database replica with the same specifications as your production virtual machine Further you may maintain an additional replica database specifically for read only workloads  If this is the case you have the compute and storage topology equivalent as provided by Spanner You have three copies of the data and three running virtual machines one virtual machine to manage writes a second as a high availability replica and a third to serve read only workloads This reflects the core philosophy behind Spanner that you should operate with at least three replicas to ensure high availability Now let s consider the relative list price of Spanner to that of a database running on Compute Engine The list price for Spanner database storage is approximately twice that of zonal persistent disk However since you have three copies of data stored in persistent disk the total cost will be higher In this topology for the same amount of application data Spanner database storage costs approximately one third less than the price of traditional database storage Additionally with Spanner you only pay for what you use which saves cost since you will not need to pre provision initially unused space And if your data decreases in size unlike a traditional database no migration will be required to materialize reduced storage costs Compute resource price comparison is a bit more complex as performance is dependent upon your workload You can compare the price of your three way replicated traditional RDBMS on production size virtual machines to an equivalent count of Spanner nodes to get a sense of the relative price However the scenario does not end here As you know the operational cost of managing your own databases is not insignificant Also every operational task introduces an additional amount of risk to system uptime Spanner was designed to provide a high level of service with a low level of operational overhead In most cases the operational cost for Spanner approaches zero To start Spanner reduces the operational effort required to obtain and retain database backups Spanner requires no maintenance windows or planned downtime There is never a need for manual corruption remediation or index rebuilding with Spanner Nor is any effort required to increase the available storage size for your database Unless you deem “effort the button click to increase the instance node count Most important There is no effort required again unless you count the button click to achieve horizontal or vertical scaling since Spanner automatically provides dynamic data resharding and data replication The Enterprise Strategy Group quantified the total cost of ownership TCO savings of Spanner in their report Analyzing the Economic Benefits of Google Cloud Spanner Relational Database Service What they found was that due to the TCO savings and the benefits provided by improved flexibility and innovation every customer they interviewed preferred Spanner over other database options Spanner s total cost of ownership is lower than on premises databases and lower than other cloud options With this reduction in operational effort you can focus on other things that can make your business more successful This is the opportunity value provided by Spanner  Getting startedSpanner is incredibly powerful but is also incredibly simple to operate Spanner has been battle tested at Google and we re proud to provide this technology to customers There are strong pun intended reasons why Spanner is a great choice for your next project regardless of the workload scope or size We choose to use Spanner internally at Google Cloud to guarantee object listing in Cloud Storage and the same choice is made by our customers such as Colopl which chose Spanner to help bring you Dragon Quest Walk Spanner provides familiar relational semantics and query language and shares the powerful flexibility that has made relational databases the top choice for data storage No matter the size of your application or your business goals there is a good chance that Spanner would make a great choice for you as well  Learn moreTo get started with Spanner create an instanceor try it out with a Spanner Qwiklab	2020-08-20 16:30:00