投稿時間:2022-04-02 02:31:39 RSSフィード2022-04-02 02:00 分まとめ(33件)

カテゴリー等 サイト名等 記事タイトル・トレンドワード等 リンクURL 頻出ワード・要約等/検索ボリューム 登録日
AWS AWS Architecture Blog Improve workload sustainability with services and features from re:Invent 2021 https://aws.amazon.com/blogs/architecture/improve-workload-sustainability-with-services-and-features-from-reinvent-2021/ Improve workload sustainability with services and features from re Invent At our recent annual AWS re Invent conference we had important announcements regarding sustainability including the new Sustainability Pillar for AWS Well Architected Framework and the AWS Customer Carbon Footprint Tool In this blog post I highlight services and features from these announcements to help you design and optimize your AWS workloads from a sustainability perspective … 2022-04-01 16:29:03
AWS AWS Media Blog How to use IMDb data in search and machine learning applications https://aws.amazon.com/blogs/media/how-to-use-imdb-data-in-search-and-machine-learning-applications/ How to use IMDb data in search and machine learning applicationsIntroduction The IMDb Essential Metadata for Movies TV OTT licensed data package provides metadata for more than million movies TV shows and video games Many AWS media and entertainment customers license this data through AWS Data Exchange ADX to improve content discovery and increase customer engagement and retention This blog post explains how to transform and … 2022-04-01 16:48:40
python Pythonタグが付けられた新着投稿 - Qiita Pythonを使ってPDFの改行無しの翻訳をDeepLで実行する バージョン2 https://qiita.com/komo135/items/d0d0475920ef8a1621b2 textresubbxexxrnxexxrxexxnbtextencodedecode改行がある場合一段空白をつくり、全ての処理が終えたらクリップボードにテキストをコピーします。 2022-04-02 01:08:50
海外TECH Ars Technica Huawei faces dilemma over Russia links that risk further US sanctions https://arstechnica.com/?p=1845124 ukraine 2022-04-01 16:06:16
海外TECH MakeUseOf The Top 7 Apps that Make You Smarter Every Day https://www.makeuseof.com/top-apps-make-you-smarter/ subject 2022-04-01 16:45:13
海外TECH MakeUseOf What's New in Chrome 100 Now That It's Available? https://www.makeuseof.com/chrome-100-whats-new/ What x s New in Chrome Now That It x s Available Google has released the Chrome update to users with a bunch of new features and changes Here s what s new in the browser update 2022-04-01 16:35:16
海外TECH MakeUseOf 7 Features to Check Out When Using Spark for Your Inbox https://www.makeuseof.com/features-to-check-using-spark-for-inbox/ spark 2022-04-01 16:30:14
海外TECH MakeUseOf NVMe vs. SATA vs. M.2: What's the Difference Between These SSDs? https://www.makeuseof.com/nvme-vs-sata-vs-m2-differences/ NVMe vs SATA vs M What x s the Difference Between These SSDs Choosing the right SSD for your PC can be confusing with all the interfaces and form factors involved So let s compare the most common SSD terms 2022-04-01 16:30:13
海外TECH MakeUseOf Voice Typing Not Working on Windows 11? Here's How to Fix It https://www.makeuseof.com/voice-typing-not-working-on-windows-11-heres-how-to-fix/ typing 2022-04-01 16:15:14
海外TECH MakeUseOf 6 Ways WhatsApp Is Improving Its Voice Messages https://www.makeuseof.com/whatsapp-update-improve-voice-messages/ messages 2022-04-01 16:12:33
海外TECH DEV Community Announcing Appwrite One-Click Droplets on DigitalOcean https://dev.to/appwrite/announcing-appwrite-one-click-droplets-on-digitalocean-1hd8 Announcing Appwrite One Click Droplets on DigitalOceanAppwrite is an open source back end as a service that abstracts all the complexity of building a modern application by providing you with a set of REST APIs for your core back end needs Appwrite takes the heavy lifting for developers and handles user authentication and authorization databases file storage cloud functions Webhooks and much more Appwrite can be self hosted on your own server with Docker installed using a command docker run it rm volume var run docker sock var run docker sock volume pwd appwrite usr src code appwrite rw entrypoint install appwrite appwrite This gives you everything you need to get started quickly when building one or more projects If you re not used to self hosting or you re more comfortable with an already hosted solution this may be a bit of a challenge In order to make deploying and using Appwrite easier for developers of any skillset we re happy to announce availability of One Click Droplets in the DigitalOcean Marketplace Now you can spin up a fully hosted Appwrite instance in a DigitalOcean droplet with a production ready environment To setup your Appwrite instance First visit the Appwrite Droplet in the DigitalOcean Marketplace Sign up or sign in to your DigitalOcean account Next choose a plan for your droplet An Appwrite instance can be run on as little as CPU and GB RAM Next choose an SSH key or a root password And click the Create Droplet to launch the creation of your Droplet with Appwrite configured The process of creating the droplet only takes a few minutes and then you can access your Appwrite instance by the IP address If you connect your domain to your droplet when you access your droplet using the domain an SSL certificate is generated and configured for you automatically We re always looking at ways to lower the friction to get up and running so developers can focus on building cool projects Interested in learning more Join us on April at am ET on the DigitalOcean Tech Talk channel as we build a real time chat application using ReactJS and Appwrite Click here to get more information about the event Learn MoreGetting Started TutorialAppwrite GitHubAppwrite DocsDiscord CommunityIf you liked this click the ️so other people will see it Follow Brandon Roberts and Appwrite on Twitter for more updates 2022-04-01 16:31:52
海外TECH DEV Community WHY IS PYTHON CONSIDERED A DREAM TICKET FOR HIGH-PAYING JOBS? https://dev.to/sandeepk27/why-is-python-considered-a-dream-ticket-for-high-paying-jobs-4hfc WHY IS PYTHON CONSIDERED A DREAM TICKET FOR HIGH PAYING JOBS Python for naïve aspirants is just a coding language but otherwise it is considered the Swiss army knife of coding a muse for developers and users equally Named after a British comedy troupe Monty Python it was created in by Guido van Rossum and has come a long way to gain this enormous popularity Recently it has been ranked as the most in demand coding language by Coding Nomads Python language is used by more than of the developers and turns out it is one of the top highest paying jobs TIOBE index which calculates ratings for programming languages based on search engine hits reported a increase in ratings in the last month alone In TIOBE predicted it would replace C and JAVA as top popular languages and it did Therefore it is no wonder why most job seekers ensure they learn Python to land their dream job Analytics Insights has some interesting facts listed for you as to why Python is gaining enormous popularity among job aspirants Python is a high paying programming languageAccording to Stack Overflow survery Python was only second to Swift in salaries at median value There is no better indicator for the popularity of a skill than the number of job postings it has As per TIOBE survey Python jobs saw a significant increase in postings from in September to in February Given its versatility and adaptability to different industries such as artificial intelligence data science web development etc it is only natural to expect humongous increase in its demand by companies so much so that a website Python Jobs is created where only Python related jobs are posted Python goes well with dataAs organizations have started depending on data in their ambitious endeavours of transforming the business Python programming has found a new citadel of glory in data science With every person generating around MB of data every day there will be lot of work in a data scientist s hands and Python can make a good companion for its easy syntax and user friendly tools It is an object oriented programming language with cross functionalities and easy to use libraries well suited for streamlining large and complex data sets It is vastly used for scripting as well because of its dynamic semantics and rapid application development capabilities Take a walk on the cake Learn PythonUnlike other programming languages its syntax is pretty much clean and simple Reading the code would feel like reading English as it doesn t need too many technical terms to be included This implies it is amenable to even those who do not have prior knowledge in programming language and precisely because of this reason Python is seeing more and more developers jumping into the pool According to a report around of Python developers have less than a year or zero experience in programming Python AI s trusted partnerAI projects vary significantly from other software projects in terms of technology stack skills set and the kind of research required Given Python s versatility stability and flexibility and the tool kits it has it makes a right combination for AI project From development to deployment Python makes the best fit for AI and ML based projects It helps developers be flexible and confident of the software projects they are building Jean Francois Puget a software engineer at IBM based on trend search results on indeed com opined that Python is the most popular language for artificial intelligence and machine learning Here is an example to demonstrate what tools can do in terms of extracting insights from the data Skyscanner a travel industry giant was successful in predicting the behaviour of new airplane routes using a Python algorithm They compared thousands of origins and destinations to determine the criteria for route choice “It s clear that Python is an extremely useful and beloved language and is here to stay for decades more to come 2022-04-01 16:17:14
海外TECH DEV Community Day 13: 100 Days of SwiftUI https://dev.to/johnkevinlosito/day-13-100-days-of-swiftui-4994 Day Days of SwiftUI Protocols extensions and checkpoint ProtocolsProtocols define a blueprint of methods and properties that we expect a data type to support The protocol can then be adopted or conformed by a class struct or enum The protocol can then be adopted by a class structure or enumerationprotocol Vehicle var name String get var currentPassengers Int get set func estimateTime for distance Int gt Int func travel distance Int struct Car Vehicle let name Car var currentPassengers func estimateTime for distance Int gt Int distance func travel distance Int print I m driving distance km func openSunroof print It s a nice day func commute distance Int using vehicle Vehicle if vehicle estimateTime for distance gt print That s too slow I ll try a different vehicle else vehicle travel distance distance let car Car commute distance using car ExtensionsExtensions let us add functionality to any type whether we created it or someone else created it even one of Apple s own types extension String func trimmed gt String self trimmingCharacters in whitespacesAndNewlines var quote The truth is rarely pure and never simple let trimmed quote trimmed Checkpoint Make a protocol that describes a building adding various properties and methods then create two structs House and Office that conform to it Your protocol should require the following A property storing how many rooms it has A property storing the cost as an integer e g for a building costing A property storing the name of the estate agent responsible for selling the building A method for printing the sales summary of the building describing what it is along with its other properties Solution here 2022-04-01 16:13:47
海外TECH DEV Community How Dare you!!! Nevermind https://dev.to/carleii/how-dare-you-nevermind-16pe How Dare you Nevermind 2022-04-01 16:11:22
海外TECH DEV Community 11 Best CSS Grid Layout Generators https://dev.to/lambdatest/11-best-css-grid-layout-generators-5203 Best CSS Grid Layout GeneratorsHTML CSS and JavaScript are the three most popular languages for building a website Earlier developers would have to learn programming before explicitly creating responsive web design However with the recent trends in web development things have gotten a lot easier with tools that can help you build the website of your dreams with zero code knowledge although knowing how to code does not hurt One of those tools is a CSS grid layout generator It creates responsive grids that you can later incorporate into a website for the design layout CSS grids are elements on the screen that help you neatly segregate an area of your page into responsive divisions There are containers that hold these grids which in turn have placeholders for texts images buttons and other website elements that make a website highly responsive Grids can be scaled to change shape and size depending on how a user views a website Grids are handy for giving your website structure and a more polished appearance This CSS grid tutorial talks about CSS grid layout generators that can help in the fast prototyping and front end design of CSS layouts for your projects Let s dive in with the best CSS grid layouts generators New to CSS Selectors Check out this Ultimate CSS Selector cheat sheet to boost your web designing career Top CSS Grid Layout GeneratorsThe following CSS layout generators are the best grid layout tools available on the Internet GriddyGriddy is a CSS grid layout generator that lets you design your boxes with considerable ease It has a sidebar that enables you to add or delete rows and columns It also allows you to align the components of the container as per your preferences You can use the appropriate options to justify items and manipulate the grid gaps Pros Overall it is clean and gets the job done It has a tidy interface and the grid alignment can be manipulated conveniently Griddy is also user friendly Cons It only produces the CSS component which might not be convenient for non coders and beginners Their team could work on this aspect container display grid grid template columns fr px fr fr fr grid template rows fr px grid column gap px grid row gap px justify items stretch align items center Given below is the image of how the grid looks on the Griddy website LayoutitLayoutit is probably one of the best CSS layout generators on the Internet The interface is user friendly with simple easy to use options But most importantly Layoutit is a treat for the eyes The visual elements are perfect and can be manipulated without touching either sidebar Pros The website is neat has colorful labeling options it is almost like using post its in school It produces an all encompassing code for you to try later Layoutit is also the only CSS grid layout generator in this list that allows the code to be exported to CodePen with one button Brownie points for that Cons I loved Layoutit and have no complaints against this tool I suggest our readers try using this CSS layout generator and let us know if they particularly like anything We are always happy to explore unchartered domains Code HTML lt div class container gt lt div class A Fun Project gt lt div gt lt div class Hi gt lt div gt lt div class Coding is fun gt lt div gt lt div class Try it out may be gt lt div gt lt div class Do you code gt lt div gt lt div class Bye gt lt div gt lt div class See you soon gt lt div gt lt div gt CSS container display grid grid template columns fr fr fr grid template rows fr fr fr fr fr gap em px grid auto flow row grid template areas A Fun Project A Fun Project A Fun Project Hi Coding is fun Coding is fun Do you code Try it out may be Try it out may be Bye Try it out may be Try it out may be See you soon See you soon See you soon A Fun Project grid area A Fun Project Hi grid area Hi Coding is fun grid area Coding is fun Try it out may be grid area Try it out may be Do you code grid area Do you code Bye grid area Bye See you soon grid area See you soon html body container height margin container border px solid red position relative container after content attr class position absolute top left width height display grid align items center justify content center The image below shows the Layoutit interface Angry ToolsAngry Tools is user friendly and helps you create designs without hassles The visuals are pretty and let you mess around with colors a little Angry Tools was a happy discovery mainly because I had a lot of fun playing around with this tool Pros It is convenient for beginners or non coders as it allows you to work only with the pre made grid outlines For someone at a more advanced level they have a navigation bar towards the top that helps you make better numerical choices Towards the end of the page the website lets you look at the comprehensive output without the shenanigans on the screen Both the outputs are attached below Cons Yet again they never produce the HTML version of the code which could cause a problem for those not well acquainted with the same Code lt style gt angry grid display grid grid template rows fr fr fr grid template columns fr fr fr fr fr gap px height item background color ecf grid row start grid column start grid row end grid column end item background color bd grid row start grid column start grid row end grid column end item background color b grid row start grid column start grid row end grid column end item background color e grid row start grid column start grid row end grid column end item background color de grid row start grid column start grid row end grid column end item background color CD grid row start grid column start grid row end grid column end Output Output CSS Grid Layout GeneratorCSS Grid Layout Generator is another top CSS layout generator by Dmitrii Bykov Its interface was confusing at first and it can be quite a challenge unless one follows the tutorial video But once that is done it is quite a neat tool Pros It has a pre made grid that you can manipulate and see the results just beside the same The sidebar has multiple options that let you add remove and manipulate items in the container Cons The code however is not produced well It might not be conducive for beginners looking to understand the generated code If you are an intermediate or advanced HTML and CSS programmer you will have to make hefty changes before the code produces desirable results outside of the website interface On top of this it is cumbersome to understand the tool without referring to their tutorial video first Code HTML lt div class container gt lt div class item gt lt div gt lt div class item gt lt div gt lt div class item gt lt div gt lt div class item gt lt div gt lt div class item gt lt div gt lt div class item gt lt div gt lt div gt CSS container display inline grid grid template columns fr fr fr grid template rows fr fr fr fr grid gap em em justify items stretch item grid area item grid area item grid area item grid area item grid area item grid area CSS Grid GeneratorCSS Grid Generator by Sarah Drasner is yet another popular choice among the crowd With CSS Grid Generator you will need to specify the number of rows columns and gaps across rows and columns It will then generate a CSS class with a single button click Pros It has a user friendly interface The grid looks clean and is easy to design Every other option is neatly arranged on the screen Cons The code is not well produced The tool might not be suitable for beginners who don t know much about CSS This tool might not be a good choice for coders who want to embed the HTML and CSS code into their website One might be required to make many more additional changes to work well Code HTML lt div class parent gt lt div class div gt lt div gt lt div class div gt lt div gt lt div class div gt lt div gt lt div class div gt lt div gt lt div class div gt lt div gt lt div class div gt lt div gt lt div class div gt lt div gt lt div class div gt lt div gt lt div class div gt lt div gt lt div class div gt lt div gt lt div class div gt lt div gt lt div class div gt lt div gt lt div class div gt lt div gt lt div class div gt lt div gt lt div class div gt lt div gt lt div class div gt lt div gt lt div class div gt lt div gt lt div class div gt lt div gt lt div gt CSS parent display grid grid template columns repeat fr grid template rows repeat fr grid column gap px grid row gap px div grid area div grid area div grid area div grid area div grid area div grid area div grid area div grid area div grid area div grid area div grid area div grid area div grid area div grid area div grid area div grid area div grid area div grid area Output cssgr idCssgr id is another best CSS layout generator on this list due to its visually stunning and user friendly interface It hardly takes a minute to make a grid with different elements and it does a marvelous job with the neat sidebar You can add text placeholders and choose from a checklist of pre defined grids Here Gallery was used and modified to look like the final result Pros The code is a clean one too Beginners can easily understand and implement the program More advanced users can make desired changes to enhance the layout Cons The layout of the tool may not be to everyone s taste as it is essentially minimal Overall cssgr id serves as a good experience for coders and non coders alike Code HTML lt div class grid gt lt div class span col span row gt Item lt div gt lt div class span col gt Item lt div gt lt div class span row gt Item lt div gt lt div class span col span row gt Item lt div gt lt div gt Item lt div gt lt div gt Item lt div gt lt div class span row gt Item lt div gt lt div class span col span row gt Item lt div gt lt div class span col span row gt Item lt div gt lt div class span row gt Item lt div gt lt div gt Item lt div gt lt div gt Item lt div gt lt div gt Item lt div gt lt div gt Item lt div gt lt div gt CSS grid display grid grid template columns repeat fr grid gap px span col grid column span auto span col grid column span auto span row grid row span auto span row grid row span auto Flex Layout AttributeFlex Layout Attribute is a lesser known gem in the CSS community It is based on the CSS flexbox standard and serves as a quick flexbox shorthand by utilizing two custom elements layout and self Pros The minimal interface makes the website easy to use The container for the grid is pre defined to create a nice boundary area around your screen It helps you adjust your grids holistically while designing your grid Towards the bottom of the page are the controls that help you change the configurations of the boxes as well as their alignments Cons The code here is only in HTML There are no CSS components explicitly generated or could be seen by the user This is a curious flaw that their team can further enhance the website Code lt div layout rows center justify gt lt div self size x left gt lt div gt lt div self size x gt lt div gt lt div self size x gt lt div gt lt div self size x gt lt div gt lt div gt Output Vue Grid GeneratorVue Grid Generator is a modest CSS grid layout generator with an all encompassing user interface that lets you customize your grid designs There are also a few available formats under the Presets tab that help you choose an initial layout to modify Here the articleList option was used and then altered Pros The interface is user friendly The design is simple and involves only the essential components It is a good tool for beginners to start with The preset options are helpful to create a basic design first before the chosen format is further modified to suit the user s unique needs Cons A few more alignment options could be explicitly included to make things a tad easier Code HTML lt div class container gt lt div class header gt header lt div gt lt div class side gt side lt div gt lt div class article gt article lt div gt lt div class article gt article lt div gt lt div class side gt side lt div gt lt div class side gt side lt div gt lt div class article gt article lt div gt lt div class article gt article lt div gt lt div class footer gt footer lt div gt lt div gt CSS container display grid width height grid template areas header header header side article article side article article side article article side article article footer footer footer grid template columns px fr fr grid template rows fr fr fr fr fr px container gt div border px dashed header grid area header side grid area side article grid area article article grid area article side grid area side side grid area side article grid area article article grid area article footer grid area footer Output Bootstrap Interface Builder by LayoutitBootstrap Interface Builder is another Layoutit product that outperforms many competitors Pros The options are neatly organized in the sidebar Users can easily add remove and modify the grids with minimum numerical values directly from the sidebar One can add headings and images to the structure itself thus giving them a clear idea of what it will look like when they use it in their project Cons Here is another tool that I found no issues with The interface was great to use and caused no hassles whatsoever But if our readers face trouble we will only be too happy to investigate the tool further Code container display grid width height grid template areas header header header side article article side article article side article article side article article footer footer footer grid template columns px fr fr grid template rows fr fr fr fr fr px container gt div border px dashed header grid area header side grid area side article grid area article article grid area article side grid area side side grid area side article grid area article article grid area article footer grid area footer Output CSS Layout GeneratorCSS layout generator by Braid Design System has a comprehensive arrangement of the options and the aesthetic vibes it gives off Pros Designing your grid using this tool is simple and takes only a few minutes The boxes are neatly marked to help you gauge the grid better Cons Too many options may confuse a beginner You may require a thorough walkthrough to avoid mistakes Code HTML lt section className myGrid gt lt div gt lt div gt lt div gt lt div gt lt div gt lt div gt lt div gt lt div gt lt div gt lt div gt lt div gt lt div gt lt div gt lt div gt lt div gt lt div gt lt div gt lt div gt lt section gt CSS myGrid width px height px display grid grid template columns repeat fr grid template rows repeat fr grid gap px grid auto flow column dense justify content space between align content start myGrid gt div background gray Output Grid GuideGrid Guide is a minimal CSS layout generator for creating pixel perfect grids in your designs You need to specify the requirements and it will generate all the possible pixel combinations Pros The designs are easy to download and share Cons It produces the grids in the form of a PNG file It is not as user friendly and has a confusing interface It did not generate a code Grid Guide allows generic and minimum modifications There is not much scope for your design using this website Browser Support For CSS Grid Layout GeneratorsCSS grid layout is unprefixed in Safari Chrome Opera Firefox and Edge except in Internet Explorer This is because all browsers support the properties and values of the CSS grid layout generator It implies that if you develop Grid Layout code in Firefox it should also work in Chrome After implementing CSS grid layout in websites and web apps it is crucial to perform browser compatibility testing of CSS grid layout to ensure that they render correctly on major and legacy browsers and operating systems Various cross browser testing platforms are available in the market such as LambdaTest With LambdaTest you can run browser compatibility tests online across browsers and operating systems combinations without the hassle of maintaining an in house infrastructure Responsiveness Test Of CSS Grid Layout GeneratorsA responsive web design is crucial for an excellent online presence Google prefers responsiveness for SEO since such web pages tend to increase user satisfaction Hence responsiveness tests of the website components are essential However performing tests to check responsiveness can be cumbersome It is nearly impossible to own devices of all sizes to see how a website performs on all of them unless there is enough support to set up that infrastructure This is where LT Browser ーa mobile friendly checker tool by LambdaTest comes into the picture with its pre installed device viewports spanning across all the major operating systems Moreover LT Browser has advanced developer tools to help you with testing Some below are the top notch features of LT Browser Device sync feature to scroll on two devices simultaneously Network throttling feature to test websites on different network conditions Capture full page screenshots of the web page Generates performance reports powered by Google Lighthouse Video recording of a running test session and much more Here is a short tutorial on how to get started with LT Browser You can also go through the LambdaTest YouTube Channel to stay updated with more videos on Selenium Testing Cypress Testing and more ConclusionCSS grid layout generators help create responsive state of the art websites This CSS grid tutorial aims to give our readers an overview of tools that can make the website creation process easier especially for beginners or non coder You can leverage LambdaTest and LT Browser for browser compatibility and responsive testing needs for seamless user experience across different browsers OS and mobile devices I hope this CSS grid tutorial will help you select the best CSS grid layout generator for your project Also share your thoughts after using these CSS grid layout generators in the comment section below 2022-04-01 16:10:49
海外TECH DEV Community My first release on GitHub.. https://dev.to/carleii/my-first-release-on-github-cb7 github 2022-04-01 16:09:56
海外TECH DEV Community Understand how microservices can improve edge and embedded systems projects. https://dev.to/luos/understand-how-microservices-can-improve-edge-and-embedded-systems-projects-3j5k Understand how microservices can improve edge and embedded systems projects By developing Luos we created an open source embedded system architecture that makes electronics universal modular scalable and progress through distributed developments You can help us and make your contribution to this beautiful project by reading and sharing this article 2022-04-01 16:05:29
海外TECH DEV Community Directus on YugabyteDB https://dev.to/yugabyte/directus-on-yugabytedb-4fpl Directus on YugabyteDBHere is my first attempt to run Directus on YugabyteDB Currently YugabyteDB is not one of the database supported but because we are PostgreSQL compatible it worths a try isn t it Directus is described on as Directus is the world s first Open Data Platform for instantly turning any SQL database into an API and beautiful no code appIn my mind having been working a lot with Oracle Database this translates to an open APEX equivalent If you try to initialize a Directus project directly on a YugabyteDB you may encounter some errors like alter table directus relations alter column sort field type varchar using sort field varchar This ALTER TABLE command is not yet supported This is because with the current version of YugabyteDB there are some DDL which are not yet supported The support is tracked in YugabyteDB is PostgreSQL compatible by re using PostgreSQL code for the SQL processing layer However maintaining the catalog in a distributed environment need more considerations and this is why the support for ALTER TABLE has to be considered one by one This DDL is generated by the Directus database migration scripts which use Knex js I m not a big fan replaying the life of the datamodel for each deployment DDL is never cheap but I understand the agility of it No problem even if some DDL are not yet supported it is easy to move from one database to the other when they are compatible I ll initialize in PostreSQL and move it to YugabyteDB You may ask why not staying in PostgreSQL YugabyteDB is distributed you can add nodes to scale out The connections SQL processing read and writes and data are automatically balanced And replicated for High Availability with application continuity I start a PostgreSQL database podman run name pg d e POSTGRES PASSWORD secret p postgrespodman exec pg psql h localhost U postgres c create database directus I initialize a Directus project npm init directus project example projectI fill in the database connection information This in addition to initializing the database creates a project directory where I move to cd example projectNow starting a YugabyteDB database podman run name yb d p yugabytedb yugabyte latest bin yugabyted start daemon falsepodman exec yb ysqlsh h localhost U yugabyte c create database directus Of course you may have your database already like in the Yugabyte cloud free tier and you will just use the connection information for it Copying the schema from PostgreSQL to YugabyteDB is easy with pg dump podman exec pg pg dump h localhost U postgres d directus podman exec i yb bin ysqlsh h localhost U yugabyte d directusIn the project directory a env file holds all connection information It was generated for the PostgreSQL database so I change it to my YugabyteDB one sed e DB PORT s e DB USER s postgres yugabyte i envStarting Directus I m following the Quickstart Guide npx directus startThe http port is mentioned when starting Now welcome to the GUI where I can login with the credentials mentioned during the initialization and stored in the database I can create a Collection which is actually a table in the database You can choose the primary key as generated by a sequence or a UUID Both work and are scalable as by default YugabyteDB with HASH distribute on the first primary key column I can add Items which are rows in the table All this is visible in the database That s the beauty of it real SQL stuff where you may add indexes triggers or any PostgreSQL feature you need for optimization opc dev example project psql h localhost p U yugabyte directuspsql server YB b Type help for help directus d Franck Table public Franck Column Type Collation Nullable Default id integer not null nextval Franck id seq regclass status character varying not null draft character varying sort integer user created uuid date created timestamp with time zone date updated timestamp with time zone my date timestamp without time zone Indexes Franck pkey PRIMARY KEY lsm id HASH Foreign key constraints franck user created foreign FOREIGN KEY user created REFERENCES directus users id directus select from Franck id status sort user created date created date updated my date draft ba d ab af eeebc row directus Finally here is a simple dashboard based on the table This is the beauty of No Code database application development the consistency and availability of data is guaranteed by the SQL database and building the presentation layer on top of it is easy and nice 2022-04-01 16:05:02
海外TECH Engadget Amazon warehouse workers vote to unionize in Staten Island https://www.engadget.com/amazon-staten-island-jfk8-warehouse-vote-to-unionize-161459629.html?src=rss Amazon warehouse workers vote to unionize in Staten IslandThere should be at least one unionized Amazon warehouse in the US CNBCreports Workers at the company s JFK facility in Staten Island have voted in favor of joining a union in a late March election While the official count isn t yet available the remaining uncounted and challenged ballots aren t expected to sway the outcome The decision came after numerous challenges Workers had to file a second petition with the National Labor Relations Board after they didn t get enough signatures last fall The NLRB has also accused Amazon of interfering with unionization efforts at JFK including firing pro union workers and intimidating them through surveillance and questioning The Amazon Labor Union at the heart of the vote has made multiple demands Its requests include higher pay quot more reasonable quot productivity targets and additional time off Amazon has faced multiple claims it relies on unrealistic quotas and discourages time away from work stations We ve asked Amazon for comment It s likely to be unhappy with the results though Amazon spent million on anti union consultants just in and the internet shopping giant was accused of interference elsewhere The Retail Wholesale and Department Store Union even claimed Amazon interfered with a second unionization vote in Bessemer Alabama that the NLRB deemed necessary due to obstruction during the first election Provided the election results hold the vote would make JFK the first Amazon warehouse with a union There s no guarantee this will lead to other warehouses following suit The second Bessemer vote was close enough that it will likely be decided by challenged ballots to start A second Staten Island location is due to vote April th though and this initial win for the pro union camp might just influence other votes 2022-04-01 16:14:59
海外科学 NYT > Science Researchers Find Another Clue in the Dyatlov Pass Mystery https://www.nytimes.com/2022/04/01/world/europe/dyatlov-pass-avalanche-russia.html Researchers Find Another Clue in the Dyatlov Pass MysteryThe mystery of nine hikers who died in Russia has baffled people for more than years The authors of a recent paper think they ve found another clue 2022-04-01 16:01:43
海外TECH WIRED Amazon Staten Island Workers Unionize in Historic Win https://www.wired.com/story/staten-island-amazon-elections amazon 2022-04-01 16:39:43
金融 金融庁ホームページ 「金融商品取引業等に関する内閣府令等の一部を改正する内閣府令(案)」について公表しました。 https://www.fsa.go.jp/news/r3/shouken/20220401/20220401.html 内閣府令 2022-04-01 17:00:00
金融 金融庁ホームページ 「個人情報の保護に関する法律に基づく処分に係る審査基準」について公表しました。 https://www.fsa.go.jp/news/r3/sonota/20220401/220401.html 個人情報の保護に関する法律 2022-04-01 17:00:00
金融 金融庁ホームページ 「行政機関の保有する情報に関する法律第9条に基づく処分に係る審査基準」について公表しました。 https://www.fsa.go.jp/news/r3/sonota/20220401/220401-2.html 審査基準 2022-04-01 17:00:00
金融 金融庁ホームページ 「金融事業者リスト」に係る今後の取扱いについて公表しました。 https://www.fsa.go.jp/news/r3/kokyakuhoni/202204/fd_2021.html 金融事業 2022-04-01 17:00:00
ニュース BBC News - Home Infosys: Tech firm part-owned by Chancellor Rishi Sunak's wife closing Russia office https://www.bbc.co.uk/news/uk-politics-60952063?at_medium=RSS&at_campaign=KARANGA russia 2022-04-01 16:19:19
ニュース BBC News - Home War in Ukraine: Russia accuses Ukraine of attacking oil depot https://www.bbc.co.uk/news/world-europe-60952125?at_medium=RSS&at_campaign=KARANGA russian 2022-04-01 16:54:03
ニュース BBC News - Home Who allowed the energy price cap to rise so much? And other questions https://www.bbc.co.uk/news/business-60954102?at_medium=RSS&at_campaign=KARANGA bills 2022-04-01 16:30:21
ビジネス ダイヤモンド・オンライン - 新着記事 ロシア「インドが購入希望なら何でも供給」 貿易で協力へ - WSJ発 https://diamond.jp/articles/-/300910 購入 2022-04-02 01:14:00
北海道 北海道新聞 帯畜・樽商・北見工大統合「道内経済発展に貢献」 新機構発足 https://www.hokkaido-np.co.jp/article/664449/ 北見工業大 2022-04-02 01:30:53
北海道 北海道新聞 「信頼回復、早急に」旭医大新学長の西川氏が会見 https://www.hokkaido-np.co.jp/article/664499/ 信頼回復 2022-04-02 01:19:42
北海道 北海道新聞 停戦交渉再開 譲らぬプーチン氏、領土帰属で深い溝 ウクライナ遠い中立化 https://www.hokkaido-np.co.jp/article/664483/ 交渉再開 2022-04-02 01:11:03
北海道 北海道新聞 調和技研増資、3億円調達 北大発ベンチャー AI開発強化 https://www.hokkaido-np.co.jp/article/664546/ 人工知能 2022-04-02 01:08:00

コメント

このブログの人気の投稿

投稿時間:2021-06-17 05:05:34 RSSフィード2021-06-17 05:00 分まとめ(1274件)

投稿時間:2021-06-20 02:06:12 RSSフィード2021-06-20 02:00 分まとめ(3871件)

投稿時間:2020-12-01 09:41:49 RSSフィード2020-12-01 09:00 分まとめ(69件)