投稿時間:2021-05-16 07:11:55 RSSフィード2021-05-16 07:00 分まとめ(14件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
python	Pythonタグが付けられた新着投稿 - Qiita	yukicoder contest 295 参戦記	https://qiita.com/c-yan/items/bbc7f90596755ba933a1		2021-05-16 06:18:56
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	Unity GooglePlayの定期購入のレシートの取得、ローカル検証の基本的な流れがわかりません	https://teratail.com/questions/338533?rss=all	UnityGooglePlayの定期購入のレシートの取得、ローカル検証の基本的な流れがわかりませんCodelessIAPnbspを使ってIAPnbspButtonから定期購入のテスト購入まではできました。	2021-05-16 06:47:15
AWS	AWSタグが付けられた新着投稿 - Qiita	Spring-Bootアプリをパソコンを切ってもEC2上で起動させておく手順(デーモン化)	https://qiita.com/NoOne/items/d95092222102ed55cfb4	SpringBootアプリをパソコンを切ってもEC上で起動させておく手順デーモン化configurationタグの箇所行を記入したjarファイルを作ります。	2021-05-16 06:44:41
Ruby	Railsタグが付けられた新着投稿 - Qiita	バリデーションの種類	https://qiita.com/hayatoganbaru/items/159eb1218271fbbe3134	バリデーションの種類validatesnamepresencetruepresencetureは名前が空欄だとデータの登録ができないというバリデーションです。	2021-05-16 06:44:20
海外TECH	DEV Community	Bloomly, a new full-stack project to manage your content online	https://dev.to/pjeziorowski/bloomly-a-new-full-stack-project-to-manage-your-content-online-43gb	Bloomly a new full stack project to manage your content onlineIn the previous post I announced that I start my days of blogging challenge I also released a mini CLI tool that publishes articles to all the major developer blogging platforms dev to hashnode medium with one command The tool lacks some features though and I saw that people have the same problem as I have they need a centralized place to manage their articles or avoid publishing their content manually on multiple sites Automating stuff saves time This is why I decided to help them and myself by creating a service that allows you to write your articles publish them and manage them on all the previously mentioned platforms in one place Pain to solveIn general I want to create a tool that will reduce the friction and effort you need to put in to create and distribute your content as a developer In the future it should also help you reach more people and let you analyze what works best and what your audience like to read about FeaturesThe MVP will cover writing articles and integrations with all the platforms publishing updating and deleting articles It also covers all the basics like signups creating projects and adding collaborators Next steps I have in my mind if the project gains traction or if I find it helpful to my blogging journey displaying article statistics from all platforms in one placegenerating article covers adjusting stuff best for the given platform e g cover sizes in general reducing the effort of publishingmarketing integrations with Twitter LinkedIn Instagram Facebook to help you announce to the world that your articles are published Tech stackTo quickly build the backend and GraphQL API I decided to go with Hasura It s not the only backend component to perform custom business logic I need a separate microservice or serverless functions that Hasura will call on certain events For this I decided to go with Golang and a great Echo HTTP framework I m still thinking though if I should use Node js as Hasura provides some excellent tooling that helps you generate code for your serverless functions For the frontend React js with Next and Tailwind I ve been a fan of those technologies since their humble beginnings so the choice here was pretty easy for me For deploying and hosting the app I ll use Qovery it s a startup that aims to provide great developer experience in deploying and building full stack applications in the cloud For disclosure I m building this platform during my working hours P ProgressI ve just started today coding the backend part most of the MVP API and data modelling is done I still need to implement the custom actions interactions with APIs of the publishing platforms in the Golang microservice When it s done I ll jump into coding the frontend part Collaborators are welcomeI can do everything by myself but it would be much more pleasant to work in a group so if you are interested in building this kind of project or you feel the pain that it aims to solve feel free to reach out to me we can build it together Backend frontend UI UX designers everyone s help would come in handy Just leave a comment or find me Twitter Leave your feedback and feature ideasIf you have any feedback or an idea that I could integrate into this project feel free to leave a comment or reach out to me Twitter	2021-05-15 21:10:12
海外TECH	DEV Community	Arel Notes	https://dev.to/paramagicdev/arel-notes-hf0	Arel Notes Notes from RailsConf Link to talk What is Arel Arel stands for A Relational Algebra In actuality Arel is an AST Abstract Syntax Tree parserthat takes Ruby code and turns it into SQL syntax Arel knows nothing about your tables or database Its purely a Query Builder that uses Ruby to talk to ActiveRecord Arel HelpersWhat do they do They reduce the verbosity of Arel syntax Example Post select id using ActiveRecordPost arel table id using bare ArelPost id using Arel Helpers What are Terminal methodsPost select id count to sql gt NoMethodError undefined method to sql for Integer count is a Terminal Method meaning it will terminate the SQL chain and not allow for continuous chaining Adding functionsLets say you need to add a function thats not part of the Arel functions IE non standard SQL methods that may vary from database to database Heres how that would happen Post select Arel Nodes NamedFunction new LENGTH Post arel table text as length to sql gt SELECT LENGTH posts text AS length from posts To reduce verbosityinclude Arel NodesPost select NamedFunction new LENGTH Post text as length to sql gt SELECT LENGTH posts text AS length from posts Arel Star Substitute with Arel star Post select gt SELECT from posts Post select Arel star gt SELECT from posts Select FromPost select id from Post select id text ast to sql gt SELECT id FROM SELECT id text FROM posts ast will give you the constructed AST for a given Arel function WherePost where title Arel is Cool to sql using ActiveRecordPost where Post title eq Arel is Cool to sql Using ArelPost where title Arel is Cool to sql Using AR gt SELECT posts from posts WHERE title Arel is Cool Post where Post title not eq Arel is Cool to sql Using Arel gt SELECT posts from posts WHERE posts title Arel is Cool Post where Post title not eq nil to sql gt SELECT posts FROM posts WHERE posts title IS NOT NULL Greater thanPost where Post visitors gt to sql gt SELECT posts FROM posts WHERE posts visitors gt Less thanPost where Post visitors lt to sql gt SELECT posts FROM posts WHERE posts visitors lt Greater than or equal toPost where Post visitors gteq to sql gt SELECT posts FROM posts WHERE posts visitors gt Less than or equal toPost where Post visitors lteq to sql gt SELECT posts FROM posts WHERE posts visitors lt Chaining AND ORPost where Post title eq Arel is Cool and Post id eq or Post id eq to sql gt SELECT posts FROM posts WHERE posts title Arel is Cool AND posts id OR posts id Using INPost where Post title eq Arel is Cool and Post id in gt SELECT posts FROM posts WHERE posts title Arel is Cool AND posts id IN Using our NamedFunctionPost where Post title eq Arel is Cool and NamedFunction new LENGTH Post slug gt to sql gt SELECT posts title Arel is Cool AND LENGTH posts slug gt Using joins SetupWe ll assume the following setup class Post lt ApplicationRecord has many commentsendclass Comment lt ApplicationRecord belongs to post has one authorendclass Author lt ApplicationRecord belongs to commentend Using itTo use a regular INNER JOIN you would do the following Author joins Author arel table join Comment arel table on Comment id eq Author comment id join sources where Post id eq to sqlTo use an OUTER JOIN you would do the following Author joins Author arel table join Comment arel table Arel OuterJoin on Comment id eq Author comment id join sources where Post id eq to sql Cleaning up with ArelHelpersTo clean up the above code we can use ArelHelpers join association method include ArelHelpers JoinAssociation INNER JOINAuthor joins join association Author comment where Post id eq to sql OUTER JOINAuthor joins join association Author comment Arel OuterJoin where Post id eq to sql join association blockJoin associations can also yield a block and we can use that block to further specify join conditions Author joins join association Author comment do assoc name join conds join conds and Comment created at lteq day ago end where Post id eq to sql Join Tables SetupGiven the following setup class Course lt ApplicationRecord has and belongs to many teachersendclass Teacher lt ApplicationRecord has and belongs to many coursesend possibilities A teacher can teach many coursesA course can have many teachersThis means there are tables Courses tableTeachers tableCoursesTeachers tableCourse arel table gt coursesTeacher arel table gt teachers No model for courses teacher join table To create a join table you would do courses teachers Arel Table new courses teachers Using the above variable we can then construct the following query Course joins Course arel table join Teacher arel table on Course id eq courses teachers course id and Teacher id eq courses teachers teacher id join sources Order Using ActiveRecordPost order views Post order views reverse order Using ArelPost order Post views desc to sqlPost order Post views asc to sql INPost where Post arel table title in Post select title where id ast Like Queries with MatchesPost where Post title matches arel to sql gt SELECT phrases from phrases WHERE phrases key LIKE x c Query Builder Patternclass QueryBuilder extend Forwardable attr reader query def delegators query to a to sql each def initialize query query query end protected instantiates a new class and allow chaining def reflect query self class new query endend Using itdef with title matching title reflect query where post title matches title endPostQueryBuilder new with title matching stimulus reflex def with comments by usernames reflect query joins comments author where Author username in usernames endPostQueryBuilder new with comments by hopsoft leastbad def since yesterday reflect query where post created at gteq day ago endPostQueryBuilder new with title matching stimulus reflex with comments by hopsoft leastbad since yesterday Scuttle Turns your SQL into Arel code Thanks for sticking with me this is more of a reference for myself for the future Bonus To see all the available matchers like gt gteq lt lteqYou can run the following in the rails console bundle exec rails consoleArel Predications instance methods gt eq eq any between not	2021-05-15 21:09:08
Apple	AppleInsider - Frontpage News	Apple's push for 3D will require voxel map of the world, claims VR evangelist	https://appleinsider.com/articles/21/05/15/apples-push-for-3d-will-require-voxel-map-of-the-world-claims-vr-evangelist?utm_medium=rss	Apple x s push for D will require voxel map of the world claims VR evangelistApple is preparing for another paradigm shift that embraces D according to VR and AR evangelist Robert Scoble with predictions that Apple s strategy involves creating a realtime D map of the entire planet as well as more work on D audio and a headset like the often rumored Apple Glass Apple is thought to be working on Apple Glass wearable augmented reality or smart glasses that can provide users with a mix of digitally produced and real world views While the bulk of rumors and speculation have revolved around the hardware Robert Scoble has forecast the kind of user experience to expect from Apple over the coming years Starting at WWDC Apple will start to make announcements throughout the year about technological advances that it will be incorporating into its products writes Scoble on Saturday The announcements will apparently lead into many new products services and experiences that will come for decades Read more	2021-05-15 21:01:42
海外TECH	Engadget	'Final Fantasy XIV Online' Endwalker expansion arrives on November 23rd	https://www.engadget.com/final-fantasy-xiv-online-endwalker-november-23rd-214301453.html	november	2021-05-15 21:43:01
海外TECH	Engadget	Amazon debuts another free video streaming service, this time in India	https://www.engadget.com/amazon-minitv-free-video-service-india-211208270.html	india	2021-05-15 21:12:08
ニュース	BBC News - Home	Israel Gaza conflict: Biden calls leaders amid escalating violence	https://www.bbc.co.uk/news/world-middle-east-57131272	diplomatic	2021-05-15 21:30:51
ニュース	BBC News - Home	Santander banking services working again after day of technical problems	https://www.bbc.co.uk/news/uk-57131476	problemsthe	2021-05-15 21:32:30
ニュース	BBC News - Home	Andy Murray chooses to miss French Open	https://www.bbc.co.uk/sport/tennis/57130124	court	2021-05-15 21:25:04
ニュース	BBC News - Home	Chelsea 0-1 Leicester: Gary Lineker & James Maddison go wild for Youri Tielemans screamer	https://www.bbc.co.uk/sport/av/football/57131642	Chelsea Leicester Gary Lineker amp James Maddison go wild for Youri Tielemans screamerWatch as Gary Lineker and James Maddison react to Youri Tielemans FA Cup screamer as Leicester City lifted the trophy for the first time in their history with victory over Chelsea at Wembley	2021-05-15 21:23:12
ニュース	BBC News - Home	Hammers' top-four hopes suffer big blow with draw at Brighton	https://www.bbc.co.uk/sport/football/57034890	brighton	2021-05-15 21:45:50