投稿時間:2022-09-03 14:16:37 RSSフィード2022-09-03 14:00 分まとめ(20件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
python	Pythonタグが付けられた新着投稿 - Qiita	オフラインでPythonライブラリをインストールする方法	https://qiita.com/momiji777/items/8d4f3ea58d61c7526b19	遭遇	2022-09-03 13:09:48
Ruby	Rubyタグが付けられた新着投稿 - Qiita	RailsのStrongParametersについて 管理者権限を変更されないようにするため	https://qiita.com/tyosu/items/ef8eb2e3c38b77c07efe	massassign	2022-09-03 13:33:17
Docker	dockerタグが付けられた新着投稿 - Qiita	JAX/FlaxをAArch64で動かす	https://qiita.com/Kai238/items/1a1516cec58fb9e4d089	aarch	2022-09-03 13:32:05
Ruby	Railsタグが付けられた新着投稿 - Qiita	Herokuをデプロイ(Rails mysql)	https://qiita.com/kakeina/items/75ee173e234c4744a4e5	rubyrailsherokumysqlhe	2022-09-03 13:47:00
Ruby	Railsタグが付けられた新着投稿 - Qiita	RailsのStrongParametersについて 管理者権限を変更されないようにするため	https://qiita.com/tyosu/items/ef8eb2e3c38b77c07efe	massassign	2022-09-03 13:33:17
海外TECH	DEV Community	Migrating Your PostgreSQL Database From Heroku to CockroachDB	https://dev.to/harshhhdev/migrating-your-postgresql-database-from-heroku-to-cockroachdb-bj8	Migrating Your PostgreSQL Database From Heroku to CockroachDBAfter almost a decade Heroku announced that they will eliminate all of their free tier services They ll also delete inactive accounts and associated storage with those accounts that have been inactive for over a year In their blog post they blamed abuse for their demise of free services Quoted from the TechCrunch article In a blog post Bob Wise Heroku general manager and Salesforce EVP blamed abuse on the demise of the free services which span the free plans for Heroku Dynos and Heroku Postgres as well as the free plan for Heroku Data for Redis Our product engineering and security teams are spending an extraordinary amount of effort to manage fraud and abuse of the Heroku free product plans Wise said We will continue to provide low cost solutions for compute and data resources Wise went on to note that Heroku will be announcing a student program at Salesforce s upcoming Dreamforce conference in September but the details remain a mystery at this point This is big news Heroku used to be one of the easiest ways for you to get a free server PostgreSQL database and a Redis cache all in a single location and all for free However starting from November this year all of those free services are going away What does this mean Well with my cursory knowledge of startups free tiers mostly only exist to encourage growth and if the platform isn t growing then there simply isn t much point in having a free tier as companies would just lose money from them With that being said this forces us developers to migrate from Heroku or pay a minimum of a month Even worse if you want to run PostgreSQL you ll have to pay every single month Migrating Away From HerokuI don t know about you but I don t have that much money to throw around However if you use Heroku don t worry Plenty of platforms still have free tiers For instance you can use Netlify or Vercel for free hosting and awesome edge functions Upstash for serverless Redis and CockroachDB for a serverless and distributed PostgreSQL database CockroachDB is compatible with the PostgreSQL ecosystem meaning that migrating won t be hard at all Although it does have features for importing MySQL dump files if you re looking to switch over from other platforms Behind the scenes your data is replicated at least times and you won t face downtime for things like zone outages database upgrades and security patches Even schema changes are online Also CockroachDB is a distributed database where you can store data closest to your users Combine this with Vercel Deno Netlify edge functions and you get really fast and reliable database access at the edge It s not just amazing it s cheap too It has a very generous free tier where you get over GB storage and over M request units per month an absolute steal If you need to scale further it s only for every additional GB of storage you use and only for M request units You can even set spend limits which is used to regulate your use of request units and storage Migrating Your Database From Heroku PostgreSQLLet s move onto actually migrating our database away from PostgreSQL and onto CockroachDB There s a utility in PostgreSQL called pg dump which is used for creating a backup of the database This only backs up a single database and you can use pg dumpall to back up global objects that are common to all databases in a cluster such as roles and tablespaces So let s go into our terminal and run a command I m using Arch Linux which has an awesome PostgreSQL package however if you re on Windows you may run into some errors trying to run this command In case you have a similar issue I suggest you refer to this Stack Overflow question Anyways if you ve installed and configured PostgreSQL already you can just run pg dump host host ec compute amazonaws com port username your username password dbname database name gt db sqlIt ll prompt you for your password just enter that in and you should have a db sql file with generated tables awesome Import Onto CockroachDBNow that we have a backup let s import it onto CockroachDB If you haven t already you can sign up for a free CockroachDB serverless account at cockroachlabs cloud No credit card required After that you can just create a new cluster and configure it to your needs I d suggest keeping AWS as the cloud provider and picking the region geographically closest to you or the majority of your users I ll also change my cluster name to something I like A new cluster will be created within seconds and then you ll have to create a new SQL user with a password Afterwards it ll give you instructions on how to connect to it as well You ll have to begin by downloading the CA certificate and after that your database should be good to go As for importing our data onto CockroachDB we have two options we can either use the IMPORT PGDUMP statement documentation or we could use the IMPORT statement which allows us to migrate local PostgreSQL and MySQL dump files onto CockroachDB We ll be going with the latter as the IMPORT PGDUMP statement requires you to add a billing method and it s primarily for databases hosted on the cloud Copy paste your connection string from the modal and run the following function cockroach import db pgdump db sql url postgresql user password netloc port dbname param value amp ignore unsupported statementsMake sure to pass in the ignore unsupported statements flag at the end as it ignores SQL statements in the dump file that are unsupported by CockroachDB You can also pass in an extra parameter log ignored statements for logging unsupported statements when using ignore unsupported statements to a specified destination You may also need to remove certain statements in your dump file if you re having issues Anyways with that you should get the message successfully imported pgdump file db sql Awesome we ve done it you can simply substitute in your Heroku Database URL with the new one from CockroachDB and everything should work as expected Conclusion and that s it We migrated our entire database from Heroku s PostgreSQL onto CockroachDB serverless We ve not only migrated our database but upgraded it as well P there s simply no comparison between the two Anyways that wraps up today s article Several people are devastated hearing the news of Heroku ending their free plan and as a former Heroku user I was disappointed too I wanted to put out this article helping you all navigate through migrating your PostgreSQL databases from Heroku onto CockroachDB as the process might get complicated at times I hope this saved you some time and effort That s all for today until next time	2022-09-03 04:14:10
海外TECH	DEV Community	Simple MongoDB Database Setup for Discord.JS (Replit)	https://dev.to/w6/simple-mongodb-database-for-discordjs-replit-3i2k	Simple MongoDB Database Setup for Discord JS Replit Here s an easy implementation of MongoDB in a Discord JS bot built on Replit Be sure to follow the steps closely or you might miss something Step Create a models folder in your bot we ll use this to store all the databases in Step IMPORTANT Create a environment variable called mongodb and put your database s connection URI in there It should look something like this mongodb srv username password cluster clusters mongodb net retryWrites true amp w majorityDon t use the example I provided put your own it won t work If you don t have a MongoDB you can create on at MongoDB In your index js file include this const mongoose require mongoose mongoose connect process env mongodb useNewUrlParser true useUnifiedTopology true then console log Connected to Mongodb In the code above we re connecting to your MongoDB database Step Back to the models folder Create a file in there with any name you want I ll use keys js for my example In the file import the schema which you ll use later on const mongo require mongoose const Schema new mongo Schema Guild Number SpecialKey String Here we re specifying the basic schema that we ll use for the database You can change this to fit your bot s functionalities Finally export the schema as follows module exports mongo model yourdatabasename Schema Add that to the bottom of the file If you don t know how to make your own schema you can view some examples here Step This is the final step Go to your bot s command cog you want to use the database in and follow these steps Import the database const Schema require models keys js ExampleThen in your command you can fetch values as follows Schema findOne Guild interaction guild id async err data gt if data respond content This server s special key is data SpecialKey else new Schema Guild interaction guild id SpecialKey Examples save respond content Woah This server doesn t have a key yet I ve just set yours to the default key instead Editing and Deleting DataIf this post does well I ll do a follow up one with a tutorial on how to edit data delete data and more ️If you found this post helpful please give it a Thank you ️Do you want an advanced invite tracker in your discord server Consider adding my verified bot Ayami	2022-09-03 04:13:35
海外TECH	DEV Community	Hot reloading in Rust!	https://dev.to/nickytonline/hot-reloading-in-rust-4i1c	Hot reloading in Rust I ve been learning rust on and off since last fall I m still not proficient in the language as I haven t dedicated as much time to the language as I d like to Still I find pockets of time like tonight to dive in a bit A quick Google of rust hot reloading introduced me to the rust crate cargo watch I installed it as per their instructions cargo install cargo watch From there I went into a rust project I m working on and ran the following from the project s root from the command line cargo watch x run And that was it I was able to start up my program and with every change it reran automatically Finished running Exit status Running cargo run Compiling rusty v Users nicktaylor dev courses rustforjsdevs rusty Finished dev unoptimized debuginfo target s in s Running target debug rusty tobey maguire andrew garfield tom holland Finished running Exit status Running cargo run Compiling rusty v Users nicktaylor dev courses rustforjsdevs rusty Finished dev unoptimized debuginfo target s in s Running target debug rusty tobey maguire andrew garfield tom holland Finished running Exit status Running cargo run Compiling rusty v Users nicktaylor dev courses rustforjsdevs rusty Finished dev unoptimized debuginfo target s in s Running target debug rusty tobey maguire andrew garfield tom holland pete davidson Finished running Exit status Photo by Mackenzie Cruz on Unsplash	2022-09-03 04:13:20
Apple	AppleInsider - Frontpage News	Labor Day weekend deals: $400 off MacBook Pro, $1,000 off LG monitor, free Disney Plus offer	https://appleinsider.com/articles/22/09/02/labor-day-weekend-deals-400-off-macbook-pro-1000-off-lg-monitor-free-disney-plus-offer?utm_medium=rss	Labor Day weekend deals off MacBook Pro off LG monitor free Disney Plus offerFriday s best deals include discounts of up to photography gear for iPhones hundreds off LG OLED monitors and the lowest prices in days on MacBook Pros Labor Day deals knock up to off OLED monitors triple digits off MacBook Air and robot vacuum savings Every day AppleInsider searches online retailers to find offers and discounts on items including Apple hardware upgrades smart TVs and accessories We compile the best deals we find into our daily collection which can help our readers save money Read more	2022-09-03 04:46:22
海外TECH	CodeProject Latest Articles	LogViewer: A fast WPF Control displaying logging information	https://www.codeproject.com/Articles/5340961/LogViewer-A-fast-WPF-Control-displaying-logging-in	information	2022-09-03 04:58:00
ニュース	@日本経済新聞 電子版	日本発のお絵描きアプリ「ibisPaint」が累計2.5億ダウンロードを突破。スマートフォンなどを使って指1本で繊細な絵を描くことができ、世界中で支持を集めています。 https://t.co/agpxw6BI5v	https://twitter.com/nikkei/statuses/1565927608688295938	日本発のお絵描きアプリ「ibisPaint」が累計億ダウンロードを突破。	2022-09-03 05:00:10
ニュース	@日本経済新聞 電子版	コロナワクチン訴訟、「特許のやぶ」で泥沼化の恐れも https://t.co/AoZr1Dqbwk	https://twitter.com/nikkei/statuses/1565917671412994048	訴訟	2022-09-03 04:20:40
ニュース	@日本経済新聞 電子版	大海原・大平原・森林　絶景サウナで味わう非日常 https://t.co/DVh1LLGckG	https://twitter.com/nikkei/statuses/1565915430736531456	絶景	2022-09-03 04:11:46
ニュース	@日本経済新聞 電子版	きょう9月3日昼の日経電子版トップ（https://t.co/2e0od2wSC0）3本です。 ▶英新型原子炉開発に日本参加　30年代初頭にも建造 https://t.co/MS8lFQ9g5R ▶リアル出社は愛犬も一緒　富士… https://t.co/ifns4iyzmK	https://twitter.com/nikkei/statuses/1565915010823602181	きょう月日昼の日経電子版トップ本です。	2022-09-03 04:10:06
ニュース	BBC News - Home	US Open: Serena Williams' career over after Ajla Tomljanovic defeat	https://www.bbc.co.uk/sport/tennis/62775664?at_medium=RSS&at_campaign=KARANGA	US Open Serena Williams x career over after Ajla Tomljanovic defeatSerena Williams waves farewell to the US Open and her illustrious career amid emotional scenes after she is beaten by Australia s Ajla Tomljanovic in New York	2022-09-03 04:01:24
ニュース	BBC News - Home	The Crown cast: Prince William and Kate Middleton actors revealed for season 6	https://www.bbc.co.uk/news/entertainment-arts-62776717?at_medium=RSS&at_campaign=KARANGA	final	2022-09-03 04:03:54
ニュース	BBC News - Home	The Papers: 'Snap election next year' and energy crisis latest	https://www.bbc.co.uk/news/blogs-the-papers-62775312?at_medium=RSS&at_campaign=KARANGA	election	2022-09-03 04:51:13
北海道	北海道新聞	カブス鈴木は４打数２安打　カージナルスに大敗	https://www.hokkaido-np.co.jp/article/725828/	打数	2022-09-03 13:13:00
ビジネス	東洋経済オンライン	左脳の機能失った脳科学者が教える､心軽くする技 ｢90秒ルール｣で自分の感情回路を静観する | 健康 | 東洋経済オンライン	https://toyokeizai.net/articles/-/614637?utm_source=rss&utm_medium=http&utm_campaign=link_back	認知機能	2022-09-03 13:01:00
IT	週刊アスキー	銀だこの好評メニューが期間限定復活！「とろたま明太」で贅沢気分を味わおう	https://weekly.ascii.jp/elem/000/004/104/4104136/	期間限定	2022-09-03 13:30:00