投稿時間:2023-03-14 01:19:07 RSSフィード2023-03-14 01:00 分まとめ(21件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
AWS	AWS - Webinar Channel	Improving performance with Amazon RDS Optimized Writes & Optimized Reads - AWS Databases in 15	https://www.youtube.com/watch?v=fp8G3C2GmSc	Improving performance with Amazon RDS Optimized Writes amp Optimized Reads AWS Databases in At re Invent Amazon RDS customers gained access to a number of exciting new features and capabilities Two of these were Amazon RDS Optimized Writes and Amazon RDS Optimized Reads Optimized Writes built on top of the new AWS Nitro System Torn Write Prevention feature allow you to improve your database s write transaction throughput by up to x in RDS for MySQL at no additional cost For customers looking for faster query processing capabilities can use Optimized Reads to achieve up to x faster query processing in Amazon RDS for MySQL and Amazon RDS for MariaDB at no additional cost In this webinar learn more about each of these features how they help improve the performance of your databases and how to enable them if you aren t already benefitting from them today Learning Objectives Objective Get an introduction to the new Amazon RDS Optimized Writes and Amazon RDS Optimized Reads features Objective Learn how these features work and how they can improve the performance of your Amazon RDS databases Objective Determine if your databases are already using Optimized Writes and Optimized Reads today and if not how to enable them on your workload To learn more about the services featured in this talk please visit To download a copy of the slide deck from this webinar visit	2023-03-13 15:15:02
js	JavaScriptタグが付けられた新着投稿 - Qiita	Chart.jsのラベルをグラフ(pie)の中で表示させる	https://qiita.com/nasu_105/items/2290429c707b080c450f	chartjs	2023-03-14 00:33:06
AWS	AWSタグが付けられた新着投稿 - Qiita	Amazon ECSのタスク定義のリビジョンが削除できるようになった	https://qiita.com/t_tsuchida/items/8f62aa8a218d5b9121fb	amazonecs	2023-03-14 00:09:47
AWS	AWSタグが付けられた新着投稿 - Qiita	[翻訳][Redshift調査プロジェクト]Auto-Vacuum	https://qiita.com/shinonome_taku/items/1c4c23b4dc1638f12f56	autovacuum	2023-03-14 00:01:14
技術ブログ	Developers.IO	特定のIPアドレスが設定されたセキュリティグループルールを指定したIPアドレスに変更するシェルスクリプトを作成してみた	https://dev.classmethod.jp/articles/shell-script-to-change-a-security-group-rule-with-a-specific-ip-address-to-a-specified-ip-address/	awscli	2023-03-13 15:25:00
海外TECH	DEV Community	What is a database Foreign Key? A beginner's tutorial	https://dev.to/educative/what-is-a-database-foreign-key-a-beginners-tutorial-17do	What is a database Foreign Key A beginner x s tutorialThis article was written by Brittney Parker a writer for Girls Write Tech who specialize in technical writing content They aim to encourage more female developers to share their knowledge There is an overabundance of data types and structures in the database world and determining which to use is often a hotly debated topic Understanding various keys can help you see how to best leverage a specific system for your unique needs As the complexity of data structures continues to evolve databases have shifted to the relational databases and multi modal databases that are most often used today Now we can relate various tables in a meaningful way using foreign keys A foreign key is a column or group of columns used in a relational database to link data between tables A foreign key servers to reference the primary key of another existing table Today this tutorial will introduce you to foreign keys and show you how to use them in SQL We will learn What is a Foreign Key in a Database Constraint FKForeign Key versus Primary KeyForeign Key versus Composite KeyForeign Key Referential ActionsForeign keys in SQL and MySQLWhat to learn next What is a Foreign Key in a Database Foreign keys are structured into a database as a common component linking together two tables A foreign key must always reference a primary key elsewhere The original table is called the parent table or referenced table and the referencing table with a foreign key is called a child table Foreign key references are stored within a child table and links up to a primary key in a separate table The column acting as a foreign key must have a corresponding value in its linked table This creates referential integrity We must be careful when we create tables or alter tables such as inserting or deleting data from the foreign key column to avoid altering or destroying the linkage between them Say we have two tables called customer and order We can use a foreign key to create a relationship between them In the orders table we create a key that references customer i e CUSTOMER ID in the other table The CUSTOMER ID in the order table becomes the foreign key that references parent or primary keys in the customer table Note To insert an entry into the order table the foreign key constraint must be satisfied If we try to input into CUSTOMER ID using data not present in the customer table we ve damaged the integrity of the table s referential powers Constraint FKBridging data accurately is a prime directive Software integrations and the ability to securely share data between applications are all dependent on data integrity and database relationships This is where constraint comes in Foreign keys are often constrained to ensure the user cannot take actions that would damage dependency links between tables This also constrains users from entering invalid data We can use foreign key restraints to help maintain referential integrity of our foreign key relationships There are many referential actions we can use for constraint including Cascade when deleting primary key values the matching column in the child table are deletedSet null when a referenced row is deleted altered the referencing values in the foreign key are set to nullRestrict Values in the parent table cannot be deleted if they are referred by a foreign key Set default The foreign key values in the child table are set to a default value if the parent table is altered deletedWhen it comes to foreign key constraint naming we need to follow these general rules The CONSTRAINT symbol value is used and it must be unique in the database For InnoDB tables a constraint name is generated automatically if the constraint symbol clause is not definedFor NDB tables the FOREIGN KEY index name value is used or a constraint name is generated automatically Foreign Key versus Primary KeyUnlike a foreign key a primary key works within a relational database to uniquely identify specific records Primary keys must be unique to the table and are often used as an absolute reference point for other types of database keys Foreign keys are used more as a link than as a unique identifier of a specific row or record While multiple foreign keys can be utilized within a specific table or relational database only one primary key is permitted per database Duplicate values are permitted for foreign keys as well as null values Null values are not permitted for primary keys and references to any primary keys within a table must be deleted before removing a primary key row record Foreign Key versus Composite KeyComposite keys within a relational database are used to combine two or more columns within a specific table creating a unique identifier for that combination of columns While technically a candidate key as the composite key verifies uniqueness composite keys are only formed when the particular column or columns are used in combination with each other Like foreign keys composite keys can be used to link together multiple tables within a relational database Unlike foreign keys composite keys can be defined as a primary key during the creation of some SQL tables Foreign Key Referential ActionsReferential integrity is constrained by foreign keys ensuring that values in a particular table match values that are found in a different table These referential actions reinforce the integrity of the table structure reducing the possibility of error by ensuring that referenced columns only contain unique sets of values Foreign keys can also accept null values but it s important to note that this may restrict their ability to protect the integrity of the referenced column as null values are not checked Tip Best practices indicate using a NOT NULL constraint when creating foreign keys to maintain the structural integrity of the database Creating a data structure that is flexible and extensible enough for long term use can become increasingly difficult as data complexity and volume soars The addition of unstructured data can easily result in errors Foreign keys are an extremely valuable component helping ensure that your database is clear consistent and able to rapidly deliver accurate results Foreign keys in SQL and MySQLLet s take a look at some syntax using SQL and MySQL The following example creates a FOREIGN KEY on the PersonID column Learn more about different database types hereMySQL CREATE TABLE Orders OrderID int NOT NULL OrderNumber int NOT NULL PersonID int PRIMARY KEY OrderID FOREIGN KEY PersonID REFERENCES Persons PersonID SQL Server CREATE TABLE Orders OrderID int NOT NULL PRIMARY KEY OrderNumber int NOT NULL PersonID int FOREIGN KEY REFERENCES Persons PersonID The following syntax allows us to name FOREIGN KEY constraint CREATE TABLE Orders OrderID int NOT NULL OrderNumber int NOT NULL PersonID int PRIMARY KEY OrderID CONSTRAINT FK PersonOrder FOREIGN KEY PersonID REFERENCES Persons PersonID SQL real world exampleNow let s get more specific Below the Actors table is the referenced table and called the parent table Here the referencing table DigitalAssets is the child table We declare a column as a foreign key in a child table only if the column has an index defined on it If the column doesn t have an index it can t be used as a foreign key For our example we alter our DigitalAssets and set the ActorID column to be the foreign key as follows ALTER TABLE DigitalAssetsADD FOREIGN KEY ActorId REFERENCES Actors Id Now if we add a row in the DigitalAssets table with an actor ID that doesn t exist in the Actors table an error is reported INSERT INTO DigitalAssetsVALUES www dummy url instagram We can also create a foreign key constraint on a table itself For example this could be an employees table with a column to identify the manager Since the manager is also an employee a row identifying them will also be present The manager s ID will reference the employee ID in the same column and the employee ID will act as a foreign key What to learn nextCongrats You should now have a good idea how foreign keys can be used in your databases to make them more useful and secure There is still a lot to learn Next you should check out Drop a foreign key constraintsSQL foreign key on alter tableTriggersForeign keys with MariaDBTo get started with these concepts check out Educative s course Database Design Fundamentals for Software Engineers to learn about the fundamental concepts of databases You ll learn why and when they re used what relational databases are and entity relationship diagrams If you already have some experience with databases Educative s course An Introductory Guide to SQL is another great step You ll learn the basics of SQL such as how to create a database how to insert query and update data Happy learning Continue reading about databases and SQL on EducativeThe complete guide to system design in What are SQL Joins Types of SQL joins explainedWhat are database schemas minute guide with examples Start a discussionWhat is your favorite case of data usage in today s world Was this article helpful Let us know in the comments below	2023-03-13 15:35:14
海外TECH	DEV Community	Medusa vs Shopify	https://dev.to/sophyia/medusa-vs-shopify-1h45	Medusa vs ShopifyThere are many options for building an ecommerce web app Two of the most popular options are Medusa and Shopify which offer a range of strengths and weaknesses This article will explain Medusa and Shopify comparing their features prices and overall capabilities to help you decide which platform is the best fit for your ecommerce needs Whether you are a small business owner or a large enterprise this comparison will provide valuable insights into what each platform has to offer and see which suits you best MedusaMedusa is an open source composable commerce platform It has fantastic developer experience with unlimited customizations and plugins for merchants to scale their e store It is best suited for business owners and entrepreneurs looking to manage their stores with a development team Medusa offers third party plugins including payment integrations notification integrations shipping integrations content management system integration search integration analytics and some plugins that could be used to extend the store s features such as SendGrid integration which sends SMS and Email notification to buyers In addition it offers an easy to use admin dashboard where merchants can easily manage their sales and customer records Medusa offers a storefront for developers to get started check it out here Advantages of Using MedusaMedusa has impressive benefits for those who can use it Flexibility amp Customization Options  Medusa offers flexibility to integrate your e store backend with multiple services from CMS to payment to shipping to analysis and lots more Such integrations could be used to extend or create new features Medusa offers complete control of the codebase for developers when building using their platform Unique Admin Interface  Medusa offers an easy to use admin interface where merchants can manage their products customers and sales records and maintain their e store Medusa also offers a ready to use storefront Open Source  Medusa is an open source tool hence as a developer you can modify the codebase to suit your business needs and requirements and contribute to the platform to help other developers Pricing  Medusa is a free and open source platform meaning businesses do not have to pay license fees or monthly subscription charges Although Medusa offers Premium support that has more dedicated support for users Large Ecosystem amp Plugins Medusa has ready to use plugins with documentation to aid you in integration Some integrations may include payment analytics reporting search engine and shipping integrations to your e store You can also create your own plugin to extend an existing feature or create a new feature on the codebase Community Driven  Medusa has a large and active community of developers and merchants users who contribute to the platform and provide support and assistance to other users Multiple Languages  Medusa currently has more than languages to aid international buyers in purchasing goods and products easily Disadvantages of Using MedusaEvery tool has drawbacks here are some of Medusa s Technical Knowledge Required  Medusa is an easy tool and it has friendly guides and documentation but the downside is that Medusa is created for developers Hence it requires technical knowledge to use it Limited Support  Medusa is community driven meaning businesses won t have the support a sole proprietary platform would provide and the support would also be limited This is because Medusa does not have a dedicated support team for businesses Limited Language Support Medusa does not offer multiple languages so ecommerce websites built would have a complex getting sales from international buyers ShopifyShopify is a proprietary closed source ecommerce platform allowing individuals and businesses to create and manage online stores It is best suited for small business owners entrepreneurs and individuals looking to manage their stores with minimal technical experience Advantages of using ShopifyHere are some benefits of using Shopify Easy to Use and Set up  Shopify is a tool that has an excellent user friendly interface for creating ecommerce websites and it is straightforward to set up with or without a technical team Large Ecosystem and Plugins  Shopify has ready to use plugins to extend and add new features to your online store Shopify s plugins aim to manage your store Multiple Languages and Currencies  Shopify currently has more than languages and currencies to aid international buyers in purchasing goods and products quickly Robust Customer Support  Shopify has an impressive and ever ready to help customer support team Generally the customer experience when building an e store on Shopify is bliss Hosting and Security  Shopify provides an easy way to host and secure your online store this makes it easy for businesses to worry about other aspects of the store as it manages their servers and secures the website Store Scalability  Shopify can handle a larger volume of customers orders and data without crashing SEO Friendly  Shopify provides built in SEO features such as meta descriptions meta tags customized URLs and header tags This helps improve the visibility of the store on search engines Disadvantages of Using ShopifyLimited Customization Options  Although Shopify offers many plugins it is closed source Hence customizing the core functions could be tricky It could make it difficult to create a unique and customer tailored store Pricing Although Shopify pricing plans are affordable the additional options such as themes custom developments etc cost more and it could quickly add up This will make it difficult for businesses on a tight budget to leverage the platform and expand its capabilities Limited Data Control  Shopify has an internal server for hosting ecommerce websites which means the business or store owners will have little to no control over the data Also it will take a lot of work to migrate to another platform in the future Monolithic Architecture Medusa has the website design the database and the checkout process which are all put together in one big package Shopify s monolithic architecture makes it difficult to scale parts of the ecommerce websites without affecting the entire system this is an issue for businesses with rapid growth or high traffic Medusa vs ShopifyMedusa and Shopify are both ecommerce platforms but they have different target audiences and are pretty different in terms of features and capabilities Here are some unique differences between the two platforms Customization Medusa is highly customizable as it is an open source platform while Shopify is a closed source platform with limited customization Medusa customization offers a flexible means for users to develop their plugins to help their online stores and Medusa is better and more flexible in terms of customization Plugins amp Extensions  Shopify has plugins and extensions which businesses can use to extend the platform s functionality Medusa has official and community plugins businesses can use third party plugins and extensions or develop custom plugins that are compatible with the platform Shopify has more plugins than Medusa but not all plugins are free as Medusa s Hosting and Security  Shopify takes care of hosting and security for the online store making it easy for businesses to maintain their stores as they don t need to manage their servers Medusa is open source so businesses are required to manage hosting and security themselves Store Scalability  Medusa has better scalability than Shopify because as a developer you can add or develop resources for your store as needed Shopify controls business infrastructure so it will be difficult to add or remove resources as you want SEO Friendly Features  Shopify offers built in SEO features like meta description and tags and allows customization of URLs this feature helps improve the visibility of the online store on search engines Medusa is open source so it offers more flexibility in terms of SEO customization and may require more technical expertise to implement As an open source ecommerce platform Medusa offers a high degree of flexibility and customization but less support Shopify a closed source ecommerce platform is easy to use and provides a broader range of apps and plugins but less flexibility and control over the codebase ConclusionMedusa and Shopify are two of the leading ecommerce platforms available today each with advantages and disadvantages The choice between Medusa and Shopify will depend entirely on the business s unique requirements and team Medusa would be suitable for you if you want a highly customizable and unique frontend experience for your ecommerce websites while Shopify helps with functionalities to manage your ecommerce websites Both platforms can help businesses create manage and maintain their online stores Medusa is best for businesses or developers that want a customizable scalable and flexible ecommerce platform Here is an article that explains how to create a BB store using Medusa To begin building with Medusa get started here	2023-03-13 15:22:41
海外TECH	DEV Community	Creating Custom Animations with React.js and GreenSock	https://dev.to/haszankauna/creating-custom-animations-with-reactjs-and-greensock-36eb	Creating Custom Animations with React js and GreenSock IntroductionAnimations are an important component of modern web development They improve the user experience by making web pages more interactive and engaging Two popular tools for creating custom animations are React js and GreenSock In this article we will look at how to make custom animations with React js and GreenSock as well as the most recent features and updates React jsReact js is a well known JavaScript library for creating user interfaces It was developed by Facebook and has since become one of the most popular front end libraries Developers can use React js to create reusable UI components and manage the state of their applications One advantage of using React js for animations is that it helps to keep the code organized and simple to maintain Animations can be defined as components in React js and these components can be easily reused throughout the application GreenSockMany web developers use GreenSock a JavaScript animation library to create custom animations GreenSock is well known for its high performance and simplicity of use It has many features that make it ideal for creating complex animations GreenSock is highly customizable which is one of its many advantages The library can be used by developers to create custom animations that meet their specific requirements GreenSock also provides a variety of plugins and tools that make it simple to create animations for various platforms and devices Using React js and GreenSock to Create Custom AnimationsWe will use the following steps to create custom animations with React js and GreenSock Step Download and install GreenSock First we ll use npm to install GreenSock We can accomplish this by issuing the following command npm install gsap Step Create a React Component for the AnimationThen we ll make a React component that will be used to render the animation This can be accomplished by creating a new file called Animation jsx and inserting the following code import React useRef useEffect from react import TweenMax Power from gsap const Animation gt const animationRef useRef null useEffect gt TweenMax from animationRef current opacity y ease Power easeOut return lt div ref animationRef gt lt h gt Hello World lt h gt lt div gt export default Animation We create a new React component called Animation in this code We use the useRef hook to create a reference to the animated div element To create the animation with GreenSock we also use the useEffect hook Step Render the Animation ComponentFinally in our main app file we must render the Animation component We can accomplish this by including the following code in our App jsx file import React from react import Animation from Animation const App gt return lt div gt lt Animation gt lt div gt export default App ConclusionUsing React js and GreenSock to create custom animations is a powerful way to improve the user experience of web applications With the latest features and updates creating complex animations that meet the specific needs of your application is easier than ever This article covered how to make custom animations with React js and GreenSock We discussed the advantages of using React js and GreenSock for animations as well as a step by step tutorial for creating a simple animation With this knowledge you can begin creating custom animations that will distinguish your web applications and provide an engaging and interactive user experience Experiment with various animations and customizations using GreenSock s extensive set of tools and plugins to create one of a kind and visually stunning animations	2023-03-13 15:03:14
Apple	AppleInsider - Frontpage News	This MacBook Air M2 with 16GB RAM is on sale for $1,249, plus $40 off AppleCare	https://appleinsider.com/articles/23/03/13/this-macbook-air-m2-with-16gb-ram-is-on-sale-for-1249-plus-40-off-applecare?utm_medium=rss	This MacBook Air M with GB RAM is on sale for plus off AppleCareExclusive savings knock off the upgraded M MacBook Air with GB memory and a W USB C power adapter Plus get three years of AppleCare for Apple M MacBook Air offApple s M MacBook Air is a highly capable ultraportable laptop and the in demand configuration with GB of memory is in stock in the gorgeous Midnight finish at Apple Authorized Reseller Adorama Read more	2023-03-13 15:19:56
Apple	AppleInsider - Frontpage News	New Sonos speakers, Ring doorbell, and smart baby tech	https://appleinsider.com/articles/23/03/13/new-sonos-speakers-ring-doorbell-and-smart-baby-tech?utm_medium=rss	New Sonos speakers Ring doorbell and smart baby techOn this week s episode of the Homekit Insider podcast Faith O Hara joins us to discuss baby tech that works and doesn t work HomeKit InsiderBefore diving into the smart baby products we start off with the week s news The most notable was the launch of the new Sonos Era line Read more	2023-03-13 15:19:44
海外TECH	Engadget	'The Last of Us' creators won't restrict 'Part II' to one season of the HBO show	https://www.engadget.com/the-last-of-us-creators-wont-restrict-part-ii-to-one-season-of-the-hbo-show-150530168.html?src=rss	x The Last of Us x creators won x t restrict x Part II x to one season of the HBO showThe first season of HBO s The Last of Us nbsp wrapped up on Sunday night and the show s creators are already looking ahead to the challenge of adapting the second game HBO swiftly greenlit a second season after the show became an immediate success but that won t be enough to contain the events of The Last of Us Part II as Craig Mazin and Neil Druckmann confirmed quot No No way quot Mazin said when GQ nbsp asked if the second season would explore the entire story of Part II the interview contains spoilers for the season one finale quot It s more than one season quot Druckmann added though Mazin declined to say whether they d need two or three seasons to cover the events of Naughty Dog s sequel In any case The Last of Us is only officially renewed for season two not a third or fourth one as yet As if the task of adapting the long ambitious Part II didn t already seem daunting enough Mazin and Druckmann have an enormous new audience to appease The show has been a huge hit so far HBO said last week that almost million viewers have watched the first five episodes across all platforms We ll have to wait and see if those folks stick around after spoiler in the chalet basement but the show s creators aren t too concerned quot I don t care How they react is how they react that is completely outside of our control quot Druckmann told GQ in response to a question about the TV audience s reaction to the events of Part II quot So how do we make the best TV show version of that story That s the problem that we wrestle with every day quot Mazin added that he d rather viewers have a strong emotional response than an indifferent one Meanwhile and here s where we ll get into some mild spoilers the pivotal opening scene of the finale was originally conceived as part of an animated short which didn t come to pass According to The Verge Druckmann said he then spoke with an external studio about making a separate game focusing on Ellie s mother Anna but that fell through as well The show gave him a chance to revisit that part of the story which features Ashley Johnson who stars as Ellie in the games as Anna This article originally appeared on Engadget at	2023-03-13 15:05:30
金融	RSS FILE - 日本証券業協会	金融・証券学習テキスト「株式会社制度と証券市場のしくみ」	https://www.jsda.or.jp/gakusyu/edu/curriculum/text.html	証券市場	2023-03-13 15:48:00
金融	RSS FILE - 日本証券業協会	J-IRISS	https://www.jsda.or.jp/anshin/j-iriss/index.html	iriss	2023-03-13 16:00:00
金融	金融庁ホームページ	規制の政策評価（RIA）を公表しました。	https://www.fsa.go.jp/seisaku/r4ria.html	政策評価	2023-03-13 17:00:00
金融	金融庁ホームページ	金融審議会「事業性に着目した融資実務を支える制度のあり方に関する ワーキング・グループ」（第７回） の議事録を公表しました。	https://www.fsa.go.jp/singi/singi_kinyu/jigyoyushi_wg/gijiroku/20230202.html	金融審議会	2023-03-13 16:59:00
金融	金融庁ホームページ	金融審議会「事業性に着目した融資実務を支える制度のあり方に関する ワーキング・グループ」（第６回） の議事録を公表しました。	https://www.fsa.go.jp/singi/singi_kinyu/jigyoyushi_wg/gijiroku/20230125.html	金融審議会	2023-03-13 16:58:00
ニュース	BBC News - Home	Fiona Bruce to step back from Refuge after 'storm' over Stanley Johnson remark on Question Time	https://www.bbc.co.uk/news/entertainment-arts-64942726?at_medium=RSS&at_campaign=KARANGA	Fiona Bruce to step back from Refuge after x storm x over Stanley Johnson remark on Question TimeThe move follows a media storm over a remark the Question Time host made about Stanley Johnson	2023-03-13 15:54:01
ニュース	BBC News - Home	Silicon Valley Bank: Biden says US banking system is safe	https://www.bbc.co.uk/news/world-us-canada-64935170?at_medium=RSS&at_campaign=KARANGA	crisis	2023-03-13 15:49:45
ニュース	BBC News - Home	Swansea: One missing and three hurt in house gas explosion	https://www.bbc.co.uk/news/uk-wales-64941189?at_medium=RSS&at_campaign=KARANGA	explosion	2023-03-13 15:34:32
ニュース	BBC News - Home	Willow oil: US government approves Alaska oil and gas drilling project	https://www.bbc.co.uk/news/world-us-canada-64943603?at_medium=RSS&at_campaign=KARANGA	activists	2023-03-13 15:24:34
ニュース	BBC News - Home	Oscars 2023: An Irish Goodbye wins best short film Oscar	https://www.bbc.co.uk/news/uk-northern-ireland-64903140?at_medium=RSS&at_campaign=KARANGA	short	2023-03-13 15:31:12