投稿時間:2023-07-17 20:10:57 RSSフィード2023-07-17 20:00 分まとめ(14件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
python	Pythonタグが付けられた新着投稿 - Qiita	[Python]便利なワンライナー9選	https://qiita.com/to-fmak/items/0fcf78ed7b41a0a15691	記述	2023-07-17 19:46:53
python	Pythonタグが付けられた新着投稿 - Qiita	GPIOでLEDを点滅させる	https://qiita.com/denko-chan/items/df20aebe6e50f9f7d54b	gpioandthe	2023-07-17 19:09:46
AWS	AWSタグが付けられた新着投稿 - Qiita	AWS credentials取得までの流れ(AWS SDK ローカル接続で必要な)	https://qiita.com/sachiko-kame/items/8e98040573d1cbed597c	awscredentials	2023-07-17 19:29:06
Git	Gitタグが付けられた新着投稿 - Qiita	【Git】Push済みのブランチ名を変更する方法	https://qiita.com/dev_tatsu/items/c48c7b88df91b546d039	解説	2023-07-17 19:13:43
技術ブログ	Developers.IO	AWS Step Functions から直接 AWS Batch のジョブ実行開始を試してみた	https://dev.classmethod.jp/articles/tried-starting-aws-batch-job-execution-directly-from-aws-step-functions/	awsbatch	2023-07-17 10:25:36
海外TECH	DEV Community	RLS of Supabase(PostgreSQL) Is Good, but …🤔	https://dev.to/zenstack/rls-of-supabasepostgresql-is-good-but--1394	RLS of Supabase PostgreSQL Is Good but … RLS is the foundation of BaaSThere has been massive innovation in the database and backend space for developers building applications As a consequence the emerging trend is the rise of new database cloud service providers like below Convex MySQL through Vitess It can easily handle quite a large scale and also includes some nice features to speed up and monitor queries Neon  Postgres with separation of storage and compute Uniquely designed for serverless and works with the native Postgres driver supports database branching workflows Supabase  Open source built on pure Postgres  Database   Auth   Storage and more Scales up on pay as you go and working on scale to zero Among all of these my favorite one is Supabase The reason is that Supabase is more than just a managed database providerーit s a game changer that offers a comprehensive Backend as a Service BaaS solution With the all in one package of PostgreSQL database authentication real time subscriptions RESTful API generation and file storage you don t even need an additional backend service for your web application It is usually not possible to achieve this even with API generation because of a simple truth You never expose database directly to the frontendThanks to the powerful Row Level Security RLS of Postgres it is possible to enable secure and controlled access to the database via API generation In a nutshell RLS allows you to define policies that restrict access to rows based on user attributes Here is one simple example with PostgreSQL source CREATE TABLE chat message uuid UUID PRIMARY KEY DEFAULT uuid generate v message from NAME NOT NULL DEFAULT current user message to NAME NOT NULL message subject VARCHAR NOT NULL CREATE POLICY chat policy ON chat USING message to current user OR message from current user WITH CHECK message from current user In human language it says A chat row is only visible when the current user is either the sender or the receiver When a chat row is inserted or updated the sender must be the current user After writing fine grained access policies the database will ensure that only authorized users can access specific data based on the defined rules Now it s safe to expose the API to the frontend while ensuring data privacy and security What more do I want In Microsoft released its server protocol to comply with antitrust regulators in Europe However they faced a challenge when many of their protocols lacked technical documents so teams had to create them based on implementation To ensure accuracy Microsoft created a dedicated team to test these protocol specifications To automate the testing process an internal tool team developed various tool suites I joined the tool team as a fresh graduate and they were developing a new tool to address this issue fundamentally Mistakes in specifications may occur because they are completely segregated from the implementation Sharing a single definition between them would ensure consistency and eliminate the need for testing That s how a new DSL domain specific language called Open Protocol Notation OPN is introduced It is designed to enable developers to model protocol architecture behavior and data It can be used to generate protocol schema files IDL WSDL etc message parsers simulations and technical documents I can still remember the time when I finished an OPN for an RPC protocol that was used to both generate the publicly released technical document and parse display messages And it s the first time I ve heard what people would call it Single source of truth Policies are segregated from the application codeOf course this is the entire point of implementing security with database policy but it hurts when you want to have a wholistic view of your application because a big chunk of logic does not stay with your source code The specific hurtings might be Simplicity and Maintainability Not only does it make the system harder to understand but it also makes it difficult to debug and test Portability Not consistently supported by all database vendors Version Control Although database providers often have their own versioning mechanisms they can t be easily integrated with our application code in Git I think it s the same reason why you seldom see people using stored procedures of databases nowadays despite all the benefits they offer Single source of truth solutionThe first question we need to answer is If we want to move the access policies from the database to be alongside the application code where is the best place for it It is intuitive to think of Object Relational Mapping ORM as the bridge between application code and the database providing a convenient abstract access layer for code So that s the approach we choose to do for the ZenStack OSS project we are building It is built above the Prisma ORM and one of its focuses is to add access control capability Here s an example schema for the same chat scenario that we ve seen previously auth function returns the current user future function returns the post update entity valuemodel User id Int id default autoincrement username String sent Chat relation sent received Chat relation received allow user to read his own profile allow read auth this model Chat id Int id default autoincrement subject String fromUser User relation sent fields fromUserId references id fromUserId Int toUser User relation received fields toUserId references id toUserId Int allow user to read his own chats allow read auth fromUser auth toUser allow user to create a chat as sender allow create auth fromUser allow sender to update a chat but disallow to change sender allow update auth fromUser amp amp auth future fromUser When the application code uses the ORM to talk to the database proper filters are injected into queries and mutations to enforce the security rules For example When you do db chat findMany only chats related to the current user are returned When you do db chat create fromUserId toUserId subject hello the ORM will reject your request if the current user does not have ID See the RLS policy rules have been successfully moved to the application code Some individuals may ask Wait a minute what about this new schema file that s been introduced Doesn t that break the principle of a single source of truth My short answer for it is the schema file is also part of the application code If you think about it the RLS functionality is achieved without compromising simplicity portability and version control mentioned above Additionally the schema file is transpiled into Typescript code during the building process This is just one of two different approaches to ORM code first like TypeoRM or schema first like Prisma While it s possible to achieve this using the code first approach it may be difficult and non intuitive for developers to express the desired access policy without a schema The schema first approach offers additional benefits through code generation If you re interested you can check out another post I wrote on this topic Is Code Generation a Bad Idea JS for ZenStack・Jun webdev javascript development api FinallyTo be fair I cannot deny some of the advantages that RLS has over our approach such as the ability of policies to work across multiple applications and its language agnosticism However we all know that there is no one size fits all solution It always involves a trade off that needs to be made As long as some people believe it s the right way to go then all the current disadvantages are just issues to be resolved by us Are you one of them If so check out our Github for more detail	2023-07-17 10:25:18
海外TECH	DEV Community	AI USE CASES & APPLICATIONS ACROSS MAJOR INDUSTRIES	https://dev.to/jasperstewart/ai-use-cases-applications-across-major-industries-3clo	AI USE CASES amp APPLICATIONS ACROSS MAJOR INDUSTRIESIn today s rapidly evolving world artificial intelligence AI has emerged as a transformative technology with a wide range of applications across various industries From healthcare to finance manufacturing to marketing AI is revolutionizing the way businesses operate improving efficiency accuracy and decision making processes In this article we will explore some of the significant AI use cases and applications across major industries highlighting the potential benefits and challenges they present Artificial intelligence refers to the simulation of human intelligence in machines enabling them to perform tasks that typically require human cognitive abilities With advancements in machine learning natural language processing computer vision and robotics AI has become increasingly versatile finding applications in a multitude of industries Healthcare IndustryThe healthcare industry has embraced AI in various ways from diagnostics and drug discovery to patient care and administrative tasks AI powered systems can analyze vast amounts of medical data aiding in disease diagnosis and treatment planning Additionally AI algorithms can predict patient outcomes and identify patterns in medical records to improve clinical decision making Finance and BankingIn the finance and banking sector AI has revolutionized fraud detection risk assessment and algorithmic trading Machine learning models can analyze large datasets to identify suspicious transactions and patterns indicative of fraudulent activities AI chatbots also assist customers with basic inquiries reducing the workload on human customer service representatives Manufacturing and AutomationAI plays a crucial role in enhancing manufacturing processes and automation Intelligent robots equipped with computer vision and machine learning algorithms can perform intricate tasks with precision and efficiency AI powered predictive maintenance systems help detect machinery failures before they occur minimizing downtime and optimizing production schedules Retail and E commerceIn the retail and e commerce industry AI has transformed customer experiences through personalized recommendations chatbots and virtual shopping assistants By analyzing customer preferences and browsing history AI algorithms can suggest products tailored to individual needs boosting sales and customer satisfaction Virtual shopping assistants provide real time assistance answering customer queries and guiding them through the purchasing process Marketing and AdvertisingAI has revolutionized marketing and advertising by enabling targeted campaigns and personalized messaging Machine learning algorithms analyze customer behavior and demographics to optimize ad placements and deliver relevant content AI powered chatbots can engage with potential customers providing instant support and driving conversions Transportation and LogisticsAI has significantly impacted the transportation and logistics sector improving route optimization demand forecasting and autonomous vehicles Machine learning algorithms analyze historical data and real time traffic information to optimize delivery routes reducing fuel consumption and transportation costs Autonomous vehicles equipped with AI systems can navigate roads improving safety and efficiency Energy and UtilitiesIn the energy and utilities industry AI is employed for optimizing energy consumption predictive maintenance and grid management AI algorithms analyze energy usage patterns to identify areas of improvement and optimize resource allocation Predictive maintenance systems detect equipment failures in real time allowing for timely repairs and minimizing downtime Agriculture and FarmingAI is revolutionizing agriculture by enhancing crop yield monitoring soil conditions and optimizing irrigation Smart farming techniques leverage AI powered sensors and drones to collect data on soil moisture nutrient levels and plant health This information helps farmers make informed decisions regarding irrigation fertilization and pest control leading to improved crop productivity EducationIn the education sector AI is transforming the way students learn and teachers deliver personalized instruction Intelligent tutoring systems use AI algorithms to adapt learning materials to individual student needs providing targeted feedback and support AI powered grading systems can automate the evaluation process saving teachers time and enabling timely feedback ConclusionArtificial intelligence has permeated major industries bringing about remarkable advancements and transforming traditional business practices From healthcare to finance manufacturing to marketing AI is revolutionizing operations driving efficiency and enabling data driven decision making While the benefits of AI are vast it is essential to address ethical concerns privacy issues and the potential impact on jobs as AI continues to evolve	2023-07-17 10:18:01
海外TECH	Engadget	Meta faces a $100,000 daily fine if it doesn't fix privacy issues in Norway	https://www.engadget.com/meta-facing-a-100000-daily-fine-if-it-doesnt-fix-privacy-issues-in-norway-102557370.html?src=rss	Meta faces a daily fine if it doesn x t fix privacy issues in NorwayMeta s practice of tracking Instagram and Facebook users violates their privacy Norway s data protection regulator said in a press release today If the company doesn t take remedial action it will be fined one million crowns per day from August th until November rd quot It is so clear that this is illegal that we need to intervene now and immediately quot said Tobias Judin head of Norway s privacy commission Datatilsynet nbsp The move follows a European court ruling banning Meta from harvesting user data like location behavior and more for advertising Datatilsynet has referred its actions to Europe s Data Protection Board which could widen the fine across Europe The aim is to put quot additional pressure quot on Meta Judin said Norway is a member of the European single market but not technically an EU member Meta told Reuters that it s reviewing Datatilsynet s decision and that the decision wouldn t immediately impact its services quot We continue to constructively engage with the Irish DPC our lead regulator in the EU regarding our compliance with its decision quot a spokesperson said quot The debate around legal bases has been ongoing for some time and businesses continue to face a lack of regulatory certainty in this area quot Meta is facing pressure across Europe over its data privacy actions Earlier this month Ireland s data regulator DPC ruled that Meta can t gather user data for behavioral advertising And back in May it was hit with a record breaking € billion billion fine for transferring EU user data to its servers in the US nbsp In addition Meta s new Twitter rival Threads is not yet available in the European Union due to privacy concerns When Threads debuted Meta said that it was quot not yet prepared the service for a European launch outside the UK which is not fully governed by GDPR or EU privacy rules quot Meta is even going so far as to block EU users from accessing the new social media site with a VPN This article originally appeared on Engadget at	2023-07-17 10:25:57
海外ニュース	Japan Times latest articles	Ukraine grain-export deal collapses after Russia terminates it	https://www.japantimes.co.jp/news/2023/07/17/world/ukraine-grain-deal-collapse/	Ukraine grain export deal collapses after Russia terminates itThe move jeopardizes a key trade route from Ukraine one of the world s top grain and vegetable oil shippers just as its next harvest kicks	2023-07-17 19:10:45
海外ニュース	Japan Times latest articles	Hoshoryu beats Hiradoumi to remain in three-way tie for lead at Nagoya Grand Sumo Tournament	https://www.japantimes.co.jp/sports/2023/07/17/sumo/basho-reports/hoshoryu-three-way-tie-nagoya/	Hoshoryu beats Hiradoumi to remain in three way tie for lead at Nagoya Grand Sumo Tournament I was able to react quickly Hoshoryu said I don t care about the winning record I m just taking things one bout at a time	2023-07-17 19:16:24
ニュース	BBC News - Home	Kerch bridge is hated symbol of Russian occupation	https://www.bbc.co.uk/news/world-europe-66221252?at_medium=RSS&at_campaign=KARANGA	target	2023-07-17 10:36:03
ニュース	BBC News - Home	Women's World Cup 2023: Australia criticise gender pay disparity and question bargaining rights	https://www.bbc.co.uk/sport/football/66219752?at_medium=RSS&at_campaign=KARANGA	Women x s World Cup Australia criticise gender pay disparity and question bargaining rightsAustralia s women s team criticise the gender disparity in World Cup prize money and some nations not having collective bargaining rights	2023-07-17 10:36:14
ニュース	BBC News - Home	Bibby Stockholm: Migrant barge bound for Dorset leaves Falmouth harbour	https://www.bbc.co.uk/news/uk-england-dorset-65919498?at_medium=RSS&at_campaign=KARANGA	dorset	2023-07-17 10:51:23
ニュース	BBC News - Home	Supermarkets urged to back petrol price sharing scheme	https://www.bbc.co.uk/news/business-66214934?at_medium=RSS&at_campaign=KARANGA	competition	2023-07-17 10:04:44