投稿時間:2021-05-18 02:34:53 RSSフィード2021-05-18 02:00 分まとめ(47件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
AWS	AWS Partner Network (APN) Blog	AWS Honored with 5-Star Rating in the 2021 CRN Partner Program Guide	https://aws.amazon.com/blogs/apn/aws-honored-with-5-star-rating-in-the-2021-crn-partner-program-guide/	AWS Honored with Star Rating in the CRN Partner Program GuideAWS has earned a Star rating by CRN a brand of The Channel Company in its Partner Program Guide This annual guide provides a conclusive list of the most distinguished partner programs from leading technology companies The Star rating is awarded to an exclusive group of companies that go above and beyond with their partner programs AWS was honored based on a range of investments made by the AWS Partner Network APN to help businesses build market and sell their products services and solutions	2021-05-17 16:48:14
AWS	AWS The Internet of Things Blog	Part 2/2: Building Reliable IoT Device Software Using AWS IoT Core Device Advisor	https://aws.amazon.com/blogs/iot/part-2-2-building-reliable-iot-device-software-using-aws-iot-core-device-advisor/	Part Building Reliable IoT Device Software Using AWS IoT Core Device AdvisorIntroduction This is the second blog in a two part series In the first blog I explained the importance of testing IoT devices and how AWS IoT Core Device Advisor works In this blog I share my experience using Device Advisor to debug a software application on an IoT device with a real world industrial condition monitoring …	2021-05-17 16:49:12
AWS	AWS Management Tools Blog	Reinventing automated operations (Part II)	https://aws.amazon.com/blogs/mt/reinventing-automated-operations-part-ii/	Reinventing automated operations Part II The first post in this series Reinventing automated operations Part I covered the importance of operations in the cloud and how deferring the creation of an operations plan can slow down your migration In this post I ll share the primary mechanism of iterative improvement aka flywheel that AWS Managed Services AMS uses to increase operational …	2021-05-17 16:24:31
AWS	AWS	Zigbang: A Hybrid API of Serverless and ECS, Infra as a Code via CDK	https://www.youtube.com/watch?v=0F7KDLz-kIQ	Zigbang A Hybrid API of Serverless and ECS Infra as a Code via CDKZigbang is a real estate brokerage application with market share in Korea In a sudden spike in traffic caused by online and mobile ads learn how Zigbang is handling the traffic by using AWS Serverless services and Amazon ECS in a hybrid manner as well as utilizing the AWS CDK Cloud Development Kit Check out more resources for architecting in the AWS​​​cloud ​ AWS	2021-05-17 16:48:40
python	Pythonタグが付けられた新着投稿 - Qiita	駆け出しpythonエンジニアのまとめ デザインパターンまとめ6(adapter)	https://qiita.com/speedingrenchon/items/54c5e7f61c538e7b6847	クラス図とシーケンス図wikipediaより引用実装方針継承を利用する場合利用したいクラスAdapteeを継承したAdapterクラスを作る。	2021-05-18 01:52:35
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	Access SQlエラー（FROM句の構文エラーです）	https://teratail.com/questions/338878?rss=all	AccessSQlエラーFROM句の構文エラーですSELECTコード項目名金額FROMSELECTFROM支給項目一覧fileUNPIVOT金額FOR項目名IN手当手当ASunpvtORDERBYunpvtコードdesc上記SQL文をACCESSにて作りましたが、「FROMnbsp句の構文エラーです。	2021-05-18 01:34:19
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	Next.jsのreact-hook-formが動作しない...	https://teratail.com/questions/338877?rss=all	このIDの入力が存在すれば、ヘルパーが起動する方針です。	2021-05-18 01:20:03
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	WP Mail SMTPでピア認証をオフにした際のSSLの取り扱われ方について	https://teratail.com/questions/338876?rss=all	WPMailSMTPでピア認証をオフにした際のSSLの取り扱われ方についてwordpressにcontactnbspformnbspを導入したところ、送信ボタンは押せたのですが、「独自ドメインにのみメールが送信されない」という現象が起きました。	2021-05-18 01:20:02
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	SPA化したデータベース（mysql）のサイトをアップロードするにはどうすればいいですか？	https://teratail.com/questions/338875?rss=all	SPA化したデータベースmysqlのサイトをアップロードするにはどうすればいいですかnodejsmysqlnbspjavascriptreactでSPA化したウェブサイトをアップロードしたいのですがどうすればできるのでしょうかgithubにアップロードできるといいのですが可能でしょうかreactはcreatnbspreactnbspappを使っているので余計にわからなくなっていますフォルダは・サーバーフォルダはjindexjsファイルのみ・フロントフォルダはcreatnbspreactnbspappの生成ファイルとappjsindexjsappcssの三つを編集しました。	2021-05-18 01:16:54
Ruby	Railsタグが付けられた新着投稿 - Qiita	【rails】bootstrap導入時のExecJS::ProgramErrorの解消法	https://qiita.com/SawaShuya/items/05d0172908386bd76f25	動作環境railsrubylinuxエラーの原因にリリースされたexecjsが依存関係にあるautoprefixerrailsに対応していないことが可能性として高いです。	2021-05-18 01:37:24
海外TECH	Ars Technica	City pays $350,000 after suing “hackers” for opening Dropbox link it sent them	https://arstechnica.com/?p=1765448	records	2021-05-17 16:27:59
海外TECH	Ars Technica	It’s not enough to trust science on vaccines—others have to as well	https://arstechnica.com/?p=1765440	additive	2021-05-17 16:03:34
海外TECH	DEV Community	10 cool links for developers that I think you'll like	https://dev.to/mbcrump/10-cool-links-for-developers-that-i-think-you-ll-like-18o8	cool links for developers that I think you x ll likeHello everyone As I stumble around the internet I typically find some links that simply stand out compared to the others Here is a list of my best finds over the past couple of weeks Code in the form of a donut that produces a donut YUM Great advise on life in general Create a working API for testing in seconds Learn Git with a game Works on Windows Linux and MacOS Learn CORS without setting up a database Are you on a budget but want to develop a cloud app for FREE Then check here first MacOS emulation that is really a job portfolio Update a Twitter Banner with Emojis Starting that next big web project get a little help with a great template You think you know HTML Try reading this and surely you will learn something Generate a README MD file easily with this site Check the video below if you want to watch me walk through these sites Video mins ConclusionFeel free to checkout my Twitch streams as we learn about security and app development or you can watch the condensed version of all of my streams by subscribing to my YouTube Stay connected with me on social platforms for daily software development news Twitter Twitch Instagram YouTube GitHub Website	2021-05-17 16:23:58
海外TECH	DEV Community	Python dili ile basit Blokzincir uygulaması yazma	https://dev.to/aciklab/python-dili-ile-basit-blokzincir-uygulamasi-yazma-169f	Python dili ile basit Blokzincir uygulamasıyazmaBir süredir boşvakitlerimde blokzincir e bakıyordum Tabi ki birikim olarak coin ler değil de biraz daha teknik konular Bu kapsamda hem öğrenmek için hem de aktarabilmek için küçük bir blokzincir uygulamasıyapmak istedim Herhangi bir algoritmanın en hızlışekilde uygulanmasıiçin Python dilinin kullanılmasının çok hoşolduğunu düşünerek bu dille yapılan örnekleri inceledim ve olabildiğince basit olanıseçmeye çalıştım Bu nedenle bu yazıyıbüyük bir coin altyapısıolarak değil öğrenme olarak düşünmeniz gerekir Python ile blokzincir e girişPython ile belki onlarca çeşit alternatif olmasına rağmen belgelendirmede şifreleme algoritmalarıiçin hashlib kütüphanesi kullanılmış Bloklarımız ise json formatında tutulmasıiçin yine bu kütüphane kullanılıyor Çeşitli yerlerde de time kütüphanesiyle zaman ile ilgili işlemler yapılacaktır Blokzincir sınıfıoluşturmaEn temelinde basit bir sınıf oluşturmamız gerekir Aşağıdaki gibi bir sınıf oluşturalım Bu sınıf ilk oluşturulurken içinde zincir ve bekleyen işlemler diye dizi oluşmakta Ve tabi ki temel bir yeni blok eklenmekte class Blockzincir object def init self self zincir self bekleyen islemler self yeni blok onceki saglama Herhangi bir içerik delil Yeni blok ekleme fonksiyonuYeni adımda sınıfta girişolarak kullandığımız yeni blok fonksiyonunu oluşturarak başlıyoruz Yeni blok oluşturulurken bekleyen işlemleri görüyor ve bu işlemleri blok içinde ekliyor işlemler adıaltında Ve tabi ki bunun bir zaman damgasıve bir önceki sağlama fonksiyonun kontrolüsağlanıyor def yeni blok self delil onceki saglama None blok index len self zincir timestamp time transactions self bekleyen islemler proof delil previous hash onceki saglama or self saglama self zincir self bekleyen islemler self zincir append blok return blok Son blok u çekme fonksiyonuYeni bir işlem fonksiyonunda kullanılacak son blok fonksiyonunu zincir dizisindeki son blok json unu almak için hazırlıyoruz property def son blok self return self zincir Yeni bir işlem fonksiyonuŞimdi gönderici alıcıve gönderilecek büyüklüğün girildiği bir yeni işlem fonksiyonu oluşturuyoruz def yeni islem self gonderici alici miktar islem gönderici gonderici alıcı alici miktar miktar self bekleyen islemler append islem return self son blok index Görüldüğügibi aslında işlem fonksiyonu işlemi sadece bekleyen işlemlere eklemekte Sağlama hash fonksiyonuSağlama yani hash kısmıtüm uygulamamızın en önemli kısımlarından birisi Burada çok basit şekilde sha lıbir şifreleme yöntemi seçildi Sağlama fonksiyonu bir blok değeri girdisini alıp sağlama hex değeri çıktısıvermekte Ve bu fonksiyonu yeni blok ekleme fonksiyonu içinde zincirdeki son blok değerine göre sağlama yapılmasıiçin kullanılıyor def saglama self blok string object json dumps blok sort keys True blok string string object encode raw saglama hashlib sha blok string hex saglama raw saglama hexdigest return hex saglama Ve UygulamaVe şimdi uygulama yaparsak örneğin her bir blok içinde işlem yaptığımızıdüşünelim ve her işlemden sonra bir blok oluşturup zincire ekliyoruz Daha sonradan bu blok içindeki tüm işlemlerin sağlamasıyapılıp bir sonraki zincir bloğuna eklenmişoluyor Ayrıca örnekteki yeni blok oluştururken delil proof oluşturmak da konuya bir açıdaha katmakta Bunu yapmadan da geliştirilen basit algoritmalar bulunmakta blokzincir Blockzincir t blokzincir yeni islem Ali Veli bloklira t blokzincir yeni islem Zeki Deli bloklira t blokzincir yeni islem Deli Ali bloklira blokzincir yeni blok t blokzincir yeni islem Ali Deli bloklira t blokzincir yeni islem Veli Zeki bloklira t blokzincir yeni islem Zeki Deli bloklira blokzincir yeni blok jsonStr json dumps blokzincir zincir print jsonStr blockid sağlamasıkontrolü print blokzincir saglama blokzincir zincir ÇıktıÇıktıaşağıdaki gibi olmasıgerekmekte index timestamp transactions proof previous hash Herhangi bir içerik olsun index timestamp transactions gönderici Ali alıcı Veli miktar bloklira gönderici Zeki alıcı Deli miktar bloklira gönderici Deli alıcı Ali miktar bloklira proof previous hash fabbeaaabadeccceefefebbdd index timestamp transactions gönderici Ali alıcı Deli miktar bloklira gönderici Veli alıcı Zeki miktar bloklira gönderici Zeki alıcı Deli miktar bloklira proof previous hash eebeaeaebadabfffaabfde Kaynak	2021-05-17 16:10:04
Apple	AppleInsider - Frontpage News	Deals: Roku Ultra hits record low $69, $299 iPad, Apple Watch 6 $329	https://appleinsider.com/articles/21/05/17/deals-roku-ultra-hits-record-low-69-299-ipad-apple-watch-6-329?utm_medium=rss	Deals Roku Ultra hits record low iPad Apple Watch Monday specials are in effect now with a record breaking price drop on the Roku Ultra which is currently off inch iPads are also on sale for while Apple Watch styles are up to off Monday Apple dealsKicking off the week Amazon has issued an aggressive price drop on the Roku Ultra streaming player which is currently on sale for With HomeKit and AirPlay support the Roku Ultra is also compatible with the Apple TV app making it a viable alternative to the Apple TV K which starts at with AppleInsider exclusive coupons Read more	2021-05-17 16:29:39
Apple	AppleInsider - Frontpage News	How to listen to Apple Music Lossless Audio and what you need	https://appleinsider.com/articles/21/05/17/how-to-listen-to-apple-music-lossless-audio-and-what-you-need?utm_medium=rss	How to listen to Apple Music Lossless Audio and what you needApple claims that all Apple Music users will gain improved audio with Apple Music Lossless but to get the full benefit there are software and hardware requirements Here s what AirPods headphones or other hardware you need All Apple Music users are to get the new improved audio as part of their current subscriptionApple Music is to get its first ever major update with the June launch of Spatial Audio Dolby Atmos and Lossless Audio to the service While initially available on million songs Apple plans to have its entire library of million tracks streaming in the new higher quality Read more	2021-05-17 16:49:56
Apple	AppleInsider - Frontpage News	Eufy owners privacy breached for an hour, app showed wrong cameras	https://appleinsider.com/articles/21/05/17/eufy-owners-privacy-breached-as-app-shows-wrong-cameras?utm_medium=rss	Eufy owners privacy breached for an hour app showed wrong camerasIn a major security and privacy lapse for an hour on Monday morning users of Eufy cameras discovered that cameras owned by other users were viewable in their app instead of their own and settings could be changed by those granted bogus access as well Many connected cameras bought for security offer app based viewing and playback of video feeds for convenience On Monday it appears that there s a problem with the app in that it shows feeds of cameras that aren t owned by users Initially spotted on Reddit Eufy cam owners are reporting that attempts to log into the app provide complete access to another camera setup seemingly in another country As part of this access the users are also able to see and change settings on the account and connected hardware turn lights on and off and also retrieve details like the camera owner s email address Read more	2021-05-17 16:57:58
海外TECH	Engadget	Nintendo shows off 'Mario Golf: Super Rush' speed golf and battle royale modes	https://www.engadget.com/mario-golf-super-rush-trailer-speed-golf-battle-royale-nintendo-switch-160224931.html	battles	2021-05-17 16:02:24
海外TECH	Network World	Pure Storage inches toward a cloud business model	https://www.networkworld.com/article/3618846/pure-storage-inches-toward-a-cloud-business-model.html#tk.rss_all	Pure Storage inches toward a cloud business model Pure Storage is upgrading to its Portworx Enterprise software that improves the scale of Kubernetes while simplifying the process of supporting multiple platforms Portworx Enterprise features new integrations across Pure s line of products and services and with VMware Tanzu VMware s container orchestration software It comes with dynamic storage provisioning on Pure s FlashArray and FlashBlade hardware and offers unified visibility and support via Pure Pure s AI drive operations software Read about backup and recovery Backup vs archive Why it s important to know the difference How to pick an off site data backup method Tape vs disk storage Why isn t tape dead yet The correct levels of backup save time bandwidth space This allows volumes and file systems to be provisioned using Kubernetes without the need to directly interface with the backing storage arrays That means containerized workloads can run seamlessly across the cloud bare metal infrastructure Pure Storage arrays and even storage solutions from other vendors To read this article in full please click here	2021-05-17 16:05:00
Cisco	Cisco Blog	Analyst Insights: What’s Driving 400G Forward?	https://blogs.cisco.com/datacenter/analyst-insights-whats-driving-400g-forward-2	centers	2021-05-17 16:17:15
海外科学	NYT > Science	Experts Urge Air Quality Standards as Safeguard Against Coronavirus	https://www.nytimes.com/2021/05/13/health/aerosols-covid-workplace.html	Experts Urge Air Quality Standards as Safeguard Against CoronavirusThe researchers issued a call to action to improve indoor air quality as a safeguard against the spread of contagions like the coronavirus	2021-05-17 16:14:09
海外科学	NYT > Science	Should We Wear Masks for Cold and Flu Season?	https://www.nytimes.com/2021/05/13/science/masks-covid-flu-cold.html	illnesses	2021-05-17 16:18:46
金融	金融庁ホームページ	入札公告等を更新しました。	https://www.fsa.go.jp/choutatu/choutatu_j/nyusatu_menu.html	公告	2021-05-17 17:25:00
金融	金融庁ホームページ	「違法な金融業者に関する情報について」を更新しました。	https://www.fsa.go.jp/ordinary/chuui/index.html	Detail Nothing	2021-05-17 17:00:00
金融	金融庁ホームページ	諸外国における保険会社のグループガバナンス等の調査について公表しました。	https://www.fsa.go.jp/common/about/research/20210517/20210517.html	保険会社	2021-05-17 17:00:00
ニュース	ジェトロ ビジネスニュース（通商弘報）	医療用品・医療機器の輸入関税免除、2022年3月末まで延長	https://www.jetro.go.jp/biznews/2021/05/be3abae72ee9410f.html	医療機器	2021-05-17 16:30:00
ニュース	ジェトロ ビジネスニュース（通商弘報）	世界銀行、新型コロナ禍でも中・低所得国向け送金減少は限定的と発表	https://www.jetro.go.jp/biznews/2021/05/96073d5aa9715dc0.html	世界銀行	2021-05-17 16:20:00
ニュース	ジェトロ ビジネスニュース（通商弘報）	欧州委、2021年のEUとユーロ圏のGDP成長率予測をともに上方修正	https://www.jetro.go.jp/biznews/2021/05/4f9663962e0ef922.html	上方修正	2021-05-17 16:10:00
海外ニュース	Japan Times latest articles	Japan panel to decide on Moderna and AstraZeneca vaccine approval Thursday	https://www.japantimes.co.jp/news/2021/05/17/national/moderna-astrazeneca-vaccine-approval/	cases	2021-05-18 02:51:24
海外ニュース	Japan Times latest articles	State-run mass vaccination centers in Tokyo and Osaka start accepting bookings	https://www.japantimes.co.jp/news/2021/05/17/national/mass-vaccination-sites-reservations/	rollout	2021-05-18 02:45:09
海外ニュース	Japan Times latest articles	Family of Sri Lankan woman who died after Japan detention visits facility	https://www.japantimes.co.jp/news/2021/05/17/national/wishma-sandamali-sri-lanka-nagoya-immigration-death/	Family of Sri Lankan woman who died after Japan detention visits facilitySupporters of year old Wishma Sandamali say when they last met her there was foam around her mouth and her fingers were stiff and that her	2021-05-18 02:42:57
海外ニュース	Japan Times latest articles	Tokyo COVID-19 cases dip below 500 for first time since April 26	https://www.japantimes.co.jp/news/2021/05/17/national/japan-coronavirus-may-17/	deaths	2021-05-18 02:42:23
海外ニュース	Japan Times latest articles	One year into the pandemic, Sendai schools confront the new normal	https://www.japantimes.co.jp/news/2021/05/17/national/sendai-schools-pandemic/	standard	2021-05-18 02:00:28
海外ニュース	Japan Times latest articles	A Xinjiang solar giant breaks ranks in bid to woo the West	https://www.japantimes.co.jp/news/2021/05/17/business/xinjiang-solar-human-rights/	A Xinjiang solar giant breaks ranks in bid to woo the WestDaqo must be careful that in defending itself it doesn t appear to be agreeing with Western human rights criticisms or failing to show solidarity with	2021-05-18 01:20:36
海外ニュース	Japan Times latest articles	Tyson Fury promises to ‘smash’ Anthony Joshua during title fight	https://www.japantimes.co.jp/sports/2021/05/17/more-sports/boxing-2/fury-joshua-fight/	Tyson Fury promises to smash Anthony Joshua during title fightBritish heavyweight champion Tyson Fury has promised to smash compatriot Anthony Joshua in a video published on Twitter on Sunday that is confirmation of their	2021-05-18 02:47:39
海外ニュース	Japan Times latest articles	Roki Sasaki makes highly anticipated NPB debut with Marines	https://www.japantimes.co.jp/sports/2021/05/17/baseball/japanese-baseball/sasaki-makes-npb-debut/	Roki Sasaki makes highly anticipated NPB debut with MarinesThe monster finally made landfall on May Pitcher Roki Sasaki was Japan s most hyped rookie in some time when the Chiba Lotte Marines won his rights	2021-05-18 02:34:43
海外ニュース	Japan Times latest articles	Takefusa Kubo secures Getafe’s spot in La Liga with stunning goal	https://www.japantimes.co.jp/sports/2021/05/17/soccer/kubo-secures-spot-in-la-liga/	Takefusa Kubo secures Getafe s spot in La Liga with stunning goalTakefusa Kubo scored a stunning late winner Sunday that gave Getafe a victory over Levante and secured its place in the Spanish top flight	2021-05-18 02:16:07
海外ニュース	Japan Times latest articles	Forget the vaccine patent waiver	https://www.japantimes.co.jp/opinion/2021/05/17/commentary/world-commentary/covid-19-vaccine-patent-waiver/	countries	2021-05-18 02:00:34
ニュース	BBC News - Home	Covid: Indian variant cases in 86 council areas - Hancock	https://www.bbc.co.uk/news/uk-57150131	health	2021-05-17 16:38:15
ニュース	BBC News - Home	Covid-19: Indian variant cases up by 1,000, as surge vaccination picks up pace	https://www.bbc.co.uk/news/uk-57146180	coronavirus	2021-05-17 16:39:53
ニュース	BBC News - Home	Pembrokeshire school bus crash: Car driver dies and 17 children hurt	https://www.bbc.co.uk/news/uk-wales-57142836	morning	2021-05-17 16:35:57
ニュース	BBC News - Home	School protests force U-turn after sick pupil banned from wearing cap	https://www.bbc.co.uk/news/uk-england-derbyshire-57124276	goodwin	2021-05-17 16:03:19
ニュース	BBC News - Home	India variant: Why was India not put on the red list sooner?	https://www.bbc.co.uk/news/56801288	bangladesh	2021-05-17 16:55:54
ニュース	BBC News - Home	Covid-19 in the UK: How many coronavirus cases are there in your area?	https://www.bbc.co.uk/news/uk-51768274	cases	2021-05-17 16:34:51
IT	週刊アスキー	Apple Musicがロスレスオーディオ＆Dolby Atmosによる空間オーディオに対応	https://weekly.ascii.jp/elem/000/004/055/4055223/	apple	2021-05-18 01:45:00
GCP	Cloud Blog	Lower development costs: schedule Cloud SQL instances to start and stop	https://cloud.google.com/blog/topics/developers-practitioners/lower-development-costs-schedule-cloud-sql-instances-start-and-stop/	Lower development costs schedule Cloud SQL instances to start and stopWhen you re using a Cloud SQL instance as a development server you likely don t need to have it running constantly If so you can greatly reduce the cost of using Cloud SQL by scheduling your development server to start every morning when your work day starts and stop it each evening when you re done with your development work Configuring your instances to run this way can save you up to of the cost to run an instance per week versus having it continuously running  This blog post will walk you through the steps to configure your Cloud SQL instance to start and stop each workday using Cloud Functions Cloud Pub Sub and Cloud Scheduler I ll be demonstrating this process using a SQL Server instance but the overall approach will also work for MySQL or PostgreSQL instances running in Cloud SQL Create a Google Cloud Platform projectTo get started we ll need a Google Cloud Platform project If you already have a project you can skip this step Follow the documentation for creating and managing projects to create a new project Create a SQL Server instanceOnce your project is created click the Cloud Console s left menu and select “SQL to open the Cloud SQL section We can now create our instance Click the “CREATE INSTANCE button and select the “Choose SQL Server option Enter a valid Instance IDExample sql server devEnter a password for the “sqlserver user or click the “Generate button For Database version select “SQL Server Standard Select a Region where the instance should be located like us west For the Region s zone since the instance is for development and we re optimizing for the lowest cost select Single zone Under Customize your instance click Show configuration options to configure a low cost development instance Click and expand the Machine type section and select a Lightweight machine type which has vCPU and GB of RAM Click and expand the Storage section and select the minimum option of GB Click and expand the “Backups section and select “ PM to PM as the window for automatic backups Backup operations can only be done while the instance is running so this selection needs to be within the timeframe of AM to PM when our instance will be running With all of that information provided the create instance form should look something like this Click “CREATE INSTANCE to complete the process of creating the instance Create a Cloud Function to Start or Stop a Cloud SQL instanceWith your Cloud SQL instance created the next step is to create a Cloud Function that will start or stop the instance Go to the Cloud Functions section of the Cloud Console and click the CREATE FUNCTION button Enter the following information Specify a Function name Example start or stop cloud sql instanceSelect a Region where the Function will run Example us westFor Trigger type select “Cloud Pub Sub We ll create a new Pub Sub Topic named “InstanceMgmt to be used for Cloud SQL instance management Within the “Select a Cloud Pub Sub Topic drop down menu click the “CREATE A TOPIC button In the “Create a Topic dialog window that appears enter “InstanceMgmt as the “Topic ID and click the “CREATE TOPIC button Then click the “SAVE button to set “Cloud Pub Sub as the “Trigger for the Cloud Function With all those values entered the completed “Configuration section of the “Create function form should look something like the following Click the “NEXT button at the bottom of the “Create function form to move on to the next step where we enter the code that will power the function Now in the “Code step of the “Create function form select “Go as the “Runtime and enter “ProcessPubSub as the code “Entry point Then copy and paste the following code into the code section of the “Source code ーInline Editor The completed “Code section of the “Create function form should look something like this Click the “DEPLOY button to deploy the Function It will take a minute or two for the deployment process to complete Grant Permission for the Cloud Function to Start or Stop Cloud SQL instancesNext we need to grant our Cloud Function s Service account permission to run Cloud SQL Admin methods like Patch used to start or stop instances Go to the IAM section of the Cloud Console and find the service account used by Cloud Functions named “App Engine default service account It has the suffix “ appspot gserviceaccount com Click its pencil icon to edit it In the “Edit permissions dialog window click the “ADD ANOTHER ROLE button Select the “Cloud SQL Admin role to be added and click the “SAVE button Verify that the Cloud Function works as expectedExcellent We re now ready to test out our Cloud Function We can do so by posting a message to our Pub Sub topic which is set as the trigger for our function  First we ll test out stopping the instance Go to the Pub Sub section of the Cloud Console and select the InstanceMgmt Topic Click the PUBLISH MESSAGE button and paste in the following JSON message replacing lt your project id gt with your actual Project ID The Pub Sub message to be published should look something like this Drum roll click the PUBLISH button to publish the message which will trigger our Cloud Function and stop the instance  Going back to your Cloud SQL instance details you should see that your instance is now stopped Now let s publish another Pub Sub message to start the instance Go to the Pub Sub section of the Cloud Console and select the InstanceMgmt Topic Click the PUBLISH MESSAGE button and paste in the following JSON message this time with start as the Action Be sure and replace lt your project id gt with your actual Project ID Click the PUBLISH button to publish the message which will trigger our Cloud Function and restart the instance Back on the Cloud SQL instance details page you should see that your instance has been restarted after minutes Create Cloud Scheduler Jobs to trigger the Cloud Function Great Now that we ve confirmed that the Cloud Function is working correctly the final step is to create a couple of Cloud Scheduler jobs that will start and stop the instance automatically  Go to the Cloud Scheduler section of the Cloud Console and click the “SCHEDULE A JOB button Enter a “Name for the scheduled job Example start cloud sql dev instanceEnter a “Description for the scheduled job Example Trigger Cloud Function to start Cloud SQL development instanceFor the “Frequency of when the job should be run enter “ which schedules the job to be run at am every day Monday Friday Select your timezone from the Timezone selector Under the “Configure the Job s Target section select the “Target type to be “Pub Sub and for the “Topic specify “InstanceMgmt For the “Message body enter the same start JSON message you used when you tested the Cloud Function earlier in this post Don t forget to replace lt your project id gt with your actual Project ID The completed “Create a job form should look something like this With all that information supplied click the “CREATE button to create the start Cloud Scheduler job  Now we ve got a scheduled job that will start our Cloud SQL instance every weekday at am The only thing left to do is to create one more scheduled job to stop the instance every weekday evening Click the Cloud Scheduler “SCHEDULE A JOB button again to create it  Enter a “Name for the scheduled job Example stop cloud sql dev instanceEnter a “Description for the scheduled job Example Trigger Cloud Function to stop Cloud SQL development instanceFor the “Frequency of when the job should be run enter “ which schedules the job to be run at pm every day Monday Friday See the Cloud Scheduler documentation for more information on setting frequency Select your timezone from the Timezone selector Under the “Configure the Job s Target section select the “Target type to be “Pub Sub and for the “Topic specify “InstanceMgmt For the “Message body enter the same stop JSON message you used when you tested the Cloud Function earlier in this post Don t forget to replace lt your project id gt with your actual Project ID With all that information supplied click the “CREATE button to create the stop Cloud Scheduler job After the job creation completes you ll see the job list with the start and stop jobs you ve just created Now it s time to take a second and appreciate the smart steps you ve just performed to ensure that your development database will only be running when you need it then bask in the glory of having set up an extremely cost efficient Cloud SQL instance for the development of your next project Great job Next stepsUse the Cloud Console to see the current state of your Cloud SQL instance and to create more instances	2021-05-17 17:00:00
GCP	Cloud Blog	Meet the inspiring folks behind Google Cloud Public Sector	https://cloud.google.com/blog/topics/public-sector/meet-inspiring-folks-behind-google-cloud-public-sector/	Meet the inspiring folks behind Google Cloud Public SectorAt Google Cloud being a strategic partner is part of our DNA Whether it s listening closely to our customers helping to build team skills for innovation or simply being there since we know the cloud is we get excited about working hands on with customers to deliver new solutions  As we look to solve decades old challenges with new technologies in workforce productivity cybersecurity and artificial intelligence machine learning we know that we are only as good as the people behind the technology Today we re proud to spotlight a few of the inspiring folks behind Google Cloud Public Sector and celebrate their recognition in the industry  Melissa Adamson Head of Government Channels at Google Cloud has been named to the highly respected Women of the Channel list for This annual list recognizes the unique strengths leadership and achievements of female leaders in the IT channel The women honored this year pushed forward with comprehensive business plans marketing initiatives and innovative ideas to support their partners and customers Melissa was brought on to build the Public Sector channel from scratch The initial focus was building the channel for the US government team and has since expanded to include education Canada and Latin America Having a career background at both Microsoft and Accenture Melissa leveraged her extensive professional network to build the organic partnerships needed to accelerate the Public Sector partner ecosystem This helped her drive two key wins US Postal Service and PTO and personally recruit top cloud partners in the industry Melissa loves card games and is learning a new language Todd Schoeder Director of Global Public Sector Digital Strategy was recently featured in the “Top Cloud Executives to Watch in by Wash Exec Recognized for his work in helping customers navigate through the impact of COVID and developing innovative solutions to meet mission challenges he says “New partnerships are required to solve for the problems of the future Challenges that were previously thought of as insurmountable too risky or expensive are actually quite the opposite ーas long as you have the right partner that is working in your best interest with you Josh Marcuse Head of Strategy amp Innovation received his second Wash Award for leading a digital transformation team that works to drive the development of public sector solutions including cyber defense smart cities and public health Josh has launched services to support collaborative team operations including Workspace for Government and an artificial intelligence based customer service platform to support remote work needs His work also includes leading Google Cloud s partnerships with organizations to improve data sharing in the public health community contact tracing activities and supporting research efforts across national laboratories  Like Melissa Josh was brought on to build a new team dedicated to strategy and innovation This team s purpose is to bring an intense focus to public sector mission outcomes and the public servants who own them Josh spent a decade pushing digital modernization and workforce transformation at the U S Department of Defense and co founded the Federal Innovation Council at the Partnership for Public Service and now brings that domain expertise to supporting government workers who are driving digital transformation Join us in celebrating these folks for their leadership and contributions	2021-05-17 17:00:00