投稿時間:2021-11-13 01:41:23 RSSフィード2021-11-13 01:00 分まとめ(43件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
python	Pythonタグが付けられた新着投稿 - Qiita	【Python】文字列をn文字に分割する	https://qiita.com/jz4o/items/c8e61f3f2c081213375f		2021-11-13 00:14:18
js	JavaScriptタグが付けられた新着投稿 - Qiita	jquery.cookie.js を使いたい。でも SameSiteに対応していない	https://qiita.com/nanakochi123456/items/afba76edb8448fa4feb7	jquerycookiejsを使いたい。	2021-11-13 00:34:09
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	C# の「^」の意味	https://teratail.com/questions/369065?rss=all	cnbsp	2021-11-13 00:51:23
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	【Rust】Print!()とread_line()の実行が前後することへの疑問	https://teratail.com/questions/369064?rss=all	【Rust】Printとreadlineの実行が前後することへの疑問前提・実現したいこと最近Rustを勉強し始めた者です。	2021-11-13 00:50:31
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	VirtualBoxのインストールに失敗し、Macのセキュリティを変更しても失敗します。	https://teratail.com/questions/369063?rss=all	インストール失敗の画面と同時に下記のダイアログが表示されますので「OpennbspSecuritynbspPreferences」をクリックします。	2021-11-13 00:40:41
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	cssについて教えてください。	https://teratail.com/questions/369062?rss=all	cssについて教えてください。	2021-11-13 00:13:59
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	縦書きにするCSS「writing-mode」がスマホで効かないのを解決したい	https://teratail.com/questions/369061?rss=all	縦書きにするCSS「writingmode」がスマホで効かないのを解決したい前提・実現したいこと縦書きにするCSS「writingmode」がスマホで効かないのを解決したい発生している問題・エラーメッセージtableの作成で縦書きにするCSSの「writingmodenbspverticalrl」を使用しましたが、PCでは縦書きで表示されているのに、実機のiPhoneで表示すると表記が横向きになってしまっています。	2021-11-13 00:12:53
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	プロトタイプ宣言を使った計算の簡略化	https://teratail.com/questions/369060?rss=all	プロトタイプ宣言を使った計算の簡略化プロトタイプ宣言を使ってコードを書いたのですが長くなってしまいました。	2021-11-13 00:09:44
Ruby	Rubyタグが付けられた新着投稿 - Qiita	アイコンをランダムにしゃべらせる	https://qiita.com/TatsuyaIsamu/items/930ce9142e0a870e575f		2021-11-13 00:16:13
Ruby	Rubyタグが付けられた新着投稿 - Qiita	rspec に css を反映するにはプリコンパイルが必要	https://qiita.com/TatsuyaIsamu/items/3944178132d97ac9a9ad	railsassetsprecompile上記のコードでプリコンパイルしてみるするとcssが反映された。	2021-11-13 00:10:11
Ruby	Rubyタグが付けられた新着投稿 - Qiita	img タグの src のパスの頭に / を忘れるとHTTPリクエストが飛ぶ	https://qiita.com/TatsuyaIsamu/items/59d91ecb3653ac5384c5		2021-11-13 00:06:13
Ruby	Railsタグが付けられた新着投稿 - Qiita	アイコンをランダムにしゃべらせる	https://qiita.com/TatsuyaIsamu/items/930ce9142e0a870e575f		2021-11-13 00:16:13
Ruby	Railsタグが付けられた新着投稿 - Qiita	rspec に css を反映するにはプリコンパイルが必要	https://qiita.com/TatsuyaIsamu/items/3944178132d97ac9a9ad	railsassetsprecompile上記のコードでプリコンパイルしてみるするとcssが反映された。	2021-11-13 00:10:11
Ruby	Railsタグが付けられた新着投稿 - Qiita	img タグの src のパスの頭に / を忘れるとHTTPリクエストが飛ぶ	https://qiita.com/TatsuyaIsamu/items/59d91ecb3653ac5384c5		2021-11-13 00:06:13
海外TECH	MakeUseOf	What Is a CSV File (and How Do You Create One)?	https://www.makeuseof.com/what-is-a-csv-file/	create	2021-11-12 15:45:22
海外TECH	MakeUseOf	The Top 5 Apps for Hosting a Secret Santa Gift Exchange	https://www.makeuseof.com/secret-santa-gift-exchange-best-apps/	android	2021-11-12 15:23:55
海外TECH	DEV Community	Update on Windows 11 in React Js 💻🌈 (Unofficial)	https://dev.to/blueedgetechno/update-on-windows-11-in-react-js-unofficial-2m87	Update on Windows in React Js Unofficial Hello devs So this is a follow up of my previous post about the remaking of windows in ReactJs Visit win blueedge meGithub blueedgetechno winReactDiscord discord gg qmEZwUhbbAfter a few months of regular updates and huge support from the community we have been able to add dozens of features and lots of enhancements This version presents you Dark mode and ton of CSS optimizations A fully featured and community backed store system to download external applications New apps like Spotify Discord Camera Store updated and a lot more Native features like Context menu Action center Lockscreen Boot Screen A lot more responsive for mobile and tablets And a lot more on my bucket list PreviewOf course There were a lot of hiccups during the development of this project We even faced a backlash from Microsoft for trademark violation but we managed our way through Special thanks to andrewstech for being so helpful during the entire process Visit win blueedge meGithub blueedgetechno winReactDiscord discord gg qmEZwUhbb	2021-11-12 15:49:36
海外TECH	DEV Community	How to make a TailwindCSS SaaS Landing Page in record time	https://dev.to/harishash/how-to-make-a-tailwindcss-saas-landing-page-in-record-time-152b	How to make a TailwindCSS SaaS Landing Page in record timeHi everyone My name is Haris and today I ll be showing you how to make a SaaS Landing Page with TailwindCSS within minutes and the best part is that it ll be totally free So let s jump right in To make this Landing Page we ll be using the blox extension for VS Code You can grab it for free here on VS Code Marketplace Let s start things off with a hero section I ll be using Center Aligned with Image for this Next up we ll add a Feature section Here you can highlight the main features of your product For that purpose Feature will work just fine After the feature section we can add a Pricing section to showcase the offerings of the product We ll go with Cards with Yellow HoverWe ll close things off with a CTA and I think Right Aligned Avatars with Gradient will look perfect for this And just like that we re done with the first draft of the SaaS Landing Page Here s how the end product looks Since blox offers support for other frameworks like React Angular and Vue the same page can be developed for those projects as well So with just a couple of clicks we can set up the structure for our TailwindCSS landing page and make modifications according to the project from that point onwards Hope this helps you save your precious developer hours You can access the page that I made here at Happy Developing	2021-11-12 15:38:11
海外TECH	DEV Community	Editing API Driver API Profiles	https://dev.to/jerodimusprime/editing-api-driver-api-profiles-m63	Editing API Driver API ProfilesRESTful APIs offer a straightforward way for businesses to work with external data and offer access to their own data With more than public APIs providing access to limitless data and the typical enterprise leveraging more than applications teams and developers need more efficient ways to query API data With the CData API Driver it is easier than ever to integrate with APIs at scale for data analytics and application development Why use the API Driver Use simple SQL to access and work with data anywhere there s an API Like all CData Drivers the CData API Driver makes it easier to work with your data With the API Driver and the available API Profiles you can instantly and codelessly query dozens of APIs including any APIs built using the CData API Server from BI data integration and custom applications Thanks to its extensible design organizations and developers can modify API Profiles from API Server to customize integrations and even create their own API Profiles Easily expand the connectivity offered by API Driver to any RESTful API Editing an API ProfileBy default existing API Profiles grant read access to APIs We can edit the API Profiles to gain write access to APIs where supported Unzip the Existing ProfileAPI Profiles apip files are compressed folders that contain a collection of schema files representing the endpoints available for the API When you decompress unzip the file you can edit the schema files individually to extend the functionality Open the Schema FileOnce the Profile is decompressed open the schema file for the API endpoint you wish to modify in your preferred text editor Each schema file has several parts that define how SQL access is enabled for an API endpoint api info This keyword maps API fields to table columns through scripted column definitions attr This element represents a column definition details are below api set attr This keyword attribute sets various parameters for the API integration including paging functionality and information on how to parse the API response via the RepeatElement attribute api script method This keyword defines how read and write functionality is implemented for the API endpoint including which internal operation is called and how specific functionality like filtering is managed Below are the full contents of a the schema file for retrieving Zoom Meetings Meetings rsd api info api push api call api script api script api script api script api script Update Column DefinitionsIf we are going to implement write functionality we need to modify the schema to allow write permissions to the appropriate columns Before we update a column definition for the Profile let s examine a single column definition and discuss the different attributes Id Column Definition Column Definition Attributesname The name of the column in the SQL interface for the API endpoint xs type The data type associated with the column e g string datetime int etc readonly Whether the column allows writes by default this is always true key Whether a column is intended to be a unique identifier for the elements in a table view other xPath The path exact or relative to theRepeatElement in the API response to the column value We can see from the schema file that most of the columns which correspond to various API fields are flagged as read only The first edit we need to make is to change those columns so the API Driver can write to them based on the API specification by removing the read only flags Add INSERT FunctionalityIn this section we walk through modifying the Schema file to support INSERT statements like the following INSERT INTO Meetings Topic Type StartTime Duration TimeZone UserId VALUES Test Meeting T EST user domain com NOTE Topic Type StartTime Duration and TimeZone are all columns in our schema The UserId attr is a pseudocolumn which behaves like a table column but is not actually stored in the table In this case the UserId is used to POST the new meeting to a specific user account In the schema file the SELECT functionality is implemented in the element api push api call api script To implement INSERT functionality we need to modify the element setting the method attribute value to POST setting the input values in a data attribute and calling the appropriate operation apisadoExecuteJSONGet in this case Setting the method Attribute api script Setting the data AttributeThe Zoom Meetings API endpoint allows you to create a new meeting by submitting a JSON object with various fields for the new meeting Values from an INSERT statement are mapped to corresponding fields in an input object and are used to create the data attribute which will be POSTed to the Zoom API topic input Topic type input Type start time input StartTime duration input Duration timezone input TimeZone api set Calling the apisadoExecuteJSONGet OperationOnce the data attribute is set call the apisadoExecuteJSONGet operation using an api call keyword and push the operation to the API Driver with an api push keyword api push api push api call api script Using the Edited ProfileWith the edits made to the schema file you are ready to start INSERTing Meetings to a Zoom account Save the schema file recompress zip the schema files and change the extension of the compressed file to apip Use an application that supports standard connectivity to connect to the API Profile using the API Driver then submit your INSERT statement INSERT StatementINSERT INTO Meetings Topic Type StartTime Duration TimeZone UserId VALUES Test Meeting Edited Profile T EST user domain com Meeting in Zoom More InformationThe CData API Drivers simplify data connectivity for a wide range of popular data tools Connect BI Reporting amp ETL tools to live data from any application database or Web API Built on the same robust SQL engine that powers other CData Drivers the CData API Driver enables simple codeless query access to APIs through a single client interface	2021-11-12 15:28:44
海外TECH	DEV Community	A React Material UI Library to Build Any Form With Only JSON Config	https://dev.to/jeremyling/a-react-material-ui-library-to-build-any-form-with-only-json-config-5ck5	A React Material UI Library to Build Any Form With Only JSON ConfigSuppose we want to create a form to collect shipping address Here s how we can replicate the form below with just JSON config and the open source library I built jeremyling react material ui form builder The JSON Configconst fields title Shipping Address component display text titleProps style fontSize marginTop fontWeight bold userSelect none fontVariant small caps marginBottom col xs label First Name props required true attribute firstName component text field validations label First Name required Required validationType string col xs label Last Name props required true attribute lastName component text field validations label Last Name required Required validationType string label Address Line props required true attribute address component text field validations label Address required Required validationType string label Address Line attribute address component text field validations label Address validationType string col xs label City attribute city component text field validations label City validationType string col xs label State attribute state component text field validations label State validationType string col xs label Postcode props required true attribute postcode component text field validations label Postcode required Required validationType string col xs label Country props required true attribute country component text field validations label Country required Required validationType string options label Same as Billing value true optionConfig key label label label value value attribute sameAsBilling component checkbox group Standard Code For All Formsimport React useRef useState from react import FormBuilder from jeremyling react material ui form builder import Button from mui material import get isEmpty from lodash async function validate refs form var errors for const attribute ref of Object entries refs current if ref validate const error await ref validate get form attribute if error length errors attribute error if isEmpty errors console log errors return false return true export default function ShippingAddress const form setForm useState const refs useRef const updateForm updates gt const copy form for const key value of Object entries updates copy key value setForm copy const handleNext async event gt event preventDefault const ok await validate refs form if ok return console log form return lt gt lt FormBuilder fields fields form form updateForm updateForm refs refs gt lt Button type submit variant contained color primary sx mt onClick handleNext gt Next lt Button gt lt gt ExplanationHere we only use a few components from the library display text text field and checkbox group There are many more you can use You can view the documentation here Just note in general all input components would have these core field props title State Display text above the input label State Input label attribute state Attribute of the form to set control component text field Type of component col Breakpoints and corresponding width xs sm validations Any validations accepted by yup required true length min max matches a z i Can only contain letters email true url true uuid true Concluding RemarksI actually created the form above with clicks and a few renames on FormBlob Try it out and make building forms a breeze If you re a developer contact us and I ll turn on a feature for you to export the forms you build into your own project Alternatively you can even build and deploy a hosted form entirely on FormBlob and embed the form in your own domain If you use this method you don t have to use React in your app and it still works out of the box If data privacy is a concern you can define webhooks to call on each submission to pass the form data to your own backend If you choose FormBlob does not store any data on our servers beyond the form structure	2021-11-12 15:26:13
海外TECH	DEV Community	Understanding Transitional JavaScript Apps	https://dev.to/this-is-learning/understanding-transitional-javascript-apps-27i2	Understanding Transitional JavaScript AppsTransitional JavaScript Apps What Well honestly I m not sure I know completely myself It is an umbrella term for the progress that has been happening in JavaScript frameworks the past few years to represent that things are changing Single Pages as a technology have existed now for over years and Single Page apps today are not the same as they were decade ago or even years ago We ve embraced server side rendering and taking responsibility for the side effects of what abusing the technology looks like As usual this isn t a new idea but sometimes it just takes someone to put a name on it and who better than richharris in his recent talk at JamStack conf Now as some of you know this has been an area of focus for me the last couple years both with Marko and even to some degree with Solid In fact it s kind of been on everyone s mind Dan dan abramov This hits the nail on the head And is matching our long term thinking Client side only is not sustainable We need to move more stuff to the server but without sacrificing seamless composition of interactive pieces twitter com tmcw status … PM May Tom MacWright tmcw okay i mulled over this idea in my head for a month and then just sat down and wrote this in one pass without switching tabs so here it is raw and extra spicy Second guessing the modern web I ve written countless articles about the technologies around these topics but maybe it s time to step back and really appreciate what this means for the average web developer Death of Single Page Apps Well not exactly Every time you touch this topic some Rails developer jumps out of the back of the crowd to tell us DHH had this all figured out in And honestly that developer would probably wish we spent our time building time machines rather than move the web forward But that s not why we are here No Server rendering has been part of the equation for frontend JavaScript frameworks for years now What has changed Why are these suddenly transitional Well very little from a technology perspective It boils down to the fact that in many ways Single Page Apps have set poor expectations for the frontend ecosystem We built them originally to mimic the behavior of mobile applications but in reality not all experiences need to be that way But like any tooling with great Developer Experience people naturally want to use it everywhere The problem is this directs people to pull in tons of JavaScript and often to replace functionality that might already be present natively in the browser And it isn t just people not selecting lean enough libraries It s architectural The new hot library like Svelte or Solid doesn t change the equation on its own Yes I m author of Solid and I m saying this without reservation They are huge improvements and have been able to learn from the lessons of the past but their pedigree is inherent So here is thing Server Side rendering in itself never did anything to reduce the JavaScript bloat If anything it only adds to it as the code to hydrate tends to be larger than the code to render We ve found ways to statically generate pages but the second we need JavaScript bam there is the whole bundle Now for small sites and small framework like Svelte Solid or Preact I mean seriously who cares but we aren t talking silver bullets We are more conscious now than in the past about accessibility and the importance of progressive enhancement allowing for pages to work fine without any JavaScript present But these are implementation considerations and not architectural These are characteristics of being a good citizen of the web and our tools should support this Lost in TranslationI ve publically been a bit critical of the term Transitional Apps mostly because while SPA frameworks are finding ways they can play nicer there has been research and development going into actually solving the problem of sending too much JavaScript And I don t mean resurrecting Rails I mean full JavaScript frameworks designed for this use case No need to juggle multiple apps or not be able to leverage the latest tooling Dan dan abramov A “disappearing framework is certainly cool and worth striving for But it doesn t help much when the framework is of your code Say “disappearing app and I m listening PM May Dan is right on the money again Right now on this front there are only a couple games in town React Server Components might be a consideration once you are in the larger side of things But React and related infrastructure is too large for what I m driving at Let s talk frameworks that can start from nearly kb of JavaScript and disappear your app MarkoQwikAstroilesElderThese have one thing in common They only send the JavaScript you need to the browser They do so in different ways but if you want to live the promise of disappearing app here it is And the reason Because regardless of the authoring experience they don t view the application as a single top down system These solutions also have something else in common They tend to be used as what is being referred to as Multi Page Apps MPAs Yes your next gen static site generator Next Nuxt Gatsby SvelteKit VuePress VitePress SolidStart can generate multiple pages but it is not this Your SPA framework still treats each page as part of the whole and still can t isolate the pieces Before you say but what about If the framework isn t in the list above and it was created before chance it is not doing this Aren t MPAs bad Surprisingly not really so much these days There are a lot of technologies and the browsers themselves that make these experiences quite nice Sure there are certain things you can only do when you can preserve the browser state through navigation but for many things they are kind of great See swyx Svelte for Sites React for Apps This article is actually more a case for Elder than Svelte and it applies to all frameworks above The problem is this conversation is still being had between SPA enthusiasts and our stranded in time classic MPA proponents missing the fact that the world has moved on from this argument MPAs are not old fashioned anymore If anything JavaScript MPAs are as cutting edge as it gets But they aren t your grandfather s MPAs And here s the thing This is a distinction so technical in nature that authors of these MPA JavaScript frameworks are struggling to tell the story in a way their value can be understood by an ecosystem flooded with SPAs The last thing they want to be associated with is SPAs I ve received criticism for misinterpreting Rich Harris intent and for being divisive rather than inclusive But is something inclusive when some of the many of defining parties don t want to be included Misko Hevery mhevery Thanks Glad to see that you understand the difference ️twitter com RyanCarniato s… PM Nov Ryan Carniato RyanCarniato Unpopular opinion There is currently only one transitionalapps framework I m aware of in existence today QwikDev And any attempts of trying to paint SvelteKit or Next or Solid as somehow different than any SPA is basically hollow marketing Matthew Phillips matthewcp Transitional apps is an attempt to rebrand SPA given the poor reputation it has been building the last few years Don t let anyone fool you these are the same old SPAs you ve grown to hate twitter com RyanCarniato s… PM Nov Ryan Carniato RyanCarniato Unpopular opinion There is currently only one transitionalapps framework I m aware of in existence today QwikDev And any attempts of trying to paint SvelteKit or Next or Solid as somehow different than any SPA is basically hollow marketing Now there is no ill intent here We re all fighting different battles Rich is rallying the troops to fend off the time travelers I m just standing up for the little guy Maybe this is a technical distinction that doesn t mean anything But it does to some of us Long Live SPAs Transitional AppsDidn t I just say SPAs are dead and MPAs are the future Not quite Dan Abramov had it right when he said the future is hybrid Hell Rich had it right when he suggested in an ideal future there is no need for MPAs Rich Harris rich harris JakeDohm brianleroux jaffathecake barelyreaper BenLesh AdamRackis Exactly and in the default case a great SPA should also be an MPA insofar as it s SSR d etc so the real question isn t even what can MPA do that SPA can t it s does adding SPA capabilities have intrinsic downsides PM Sep It s just that future is not something that is here yet There are currently unreconciled downsides alongside the numerous benefits Which is why I dislike the term Transitional Apps now because it jumps the gun a bit When we have truly Transitional Apps it d be cool to market them as such But I didn t coin the term so that isn t my call I want to take moment to talk about Qwik again and this is also relevant to the next version of Marko These frameworks support automatic independent hydration without manual islands and hydrating children before for their parent They can deliver experiences with all the benefits of Multi Page apps and scale to Single page experiences seamlessly That is a Transitional App in my view An application that literally can transition from a minimal page to an interactive client navigated experience on demand This is a unique challenge with a whole slew of new tradeoffs You don t get to pick up an existing framework and just do this Maybe this deserves a new term Then next year we can debate the merits of Transitional Apps vs Transformative Apps Is that the better outcome Now there is nothing wrong with any of this inherently so far as that any of these can t be the right solution You have many options This really should start from your requirements of what you are building rather than building what your favorite tool enables you to do When did JavaScript frameworks become the Highlander I might generally be pessimistic about framework agnostic endeavors but I m all for celebrating our differences Each framework is different and that s a good thing	2021-11-12 15:19:34
海外TECH	DEV Community	Electron Adventures: Episode 96: Pywebview Terminal App	https://dev.to/taw/electron-adventures-episode-96-pywebview-terminal-app-5chp	Electron Adventures Episode Pywebview Terminal AppNow that we ve done some hello worlds in Pywebview let s try to build something more complicated a terminal app As I mentioned previously Pywebview lacks any sort of debugging tools on the frontend so it would be a terrible idea to try writing any serious code in it Fortunately we already have a working terminal app and we just need to port it to Pywebview terminal htmlThe document is nearly identical to what we had many times before lt DOCTYPE html gt lt html gt lt head gt lt meta charset utf gt lt link rel stylesheet href terminal css gt lt head gt lt body gt lt h gt Very amazing terminal app lt h gt lt div id terminal gt lt div id history gt lt div gt lt div class input line gt lt span class prompt gt lt span gt lt form gt lt input type text autofocus gt lt form gt lt div gt lt div gt lt script src terminal js gt lt script gt lt body gt lt html gt terminal cssAs so is the styling body background color color fff h font family monospace terminal font family monospace input line display flex input line gt flex input line gt prompt flex padding right rem output padding bottom rem input color ffa output color afa white space pre form display flex input flex font family monospace background color color fff border none terminal jsOnly one thing is new let form document querySelector form let input document querySelector input let terminalHistory document querySelector history function createInputLine command let inputLine document createElement div inputLine className input line let promptSpan document createElement span promptSpan className prompt promptSpan append let inputSpan document createElement span inputSpan className input inputSpan append command inputLine append promptSpan inputLine append inputSpan return inputLine function createTerminalHistoryEntry command commandOutput let inputLine createInputLine command let output document createElement div output className output output append commandOutput terminalHistory append inputLine terminalHistory append output form addEventListener submit async e gt e preventDefault let command input value let output await window pywebview api execute command createTerminalHistoryEntry command output input value input scrollIntoView That thing being let output await window pywebview api execute command The execute command function needs to be exposed by the Python backend terminalAnd finally the Python code usr bin env pythonimport webviewimport subprocessclass App def execute self command result subprocess run command capture output True shell True encoding utf return result stdout result stderrapp App window webview create window Terminal App terminal html js api App webview start We just expose a single method We need to remember to convert it to string with encoding utf as pywebview can t send bytes over even though technically that s a valid JavaScript types these days UintArray ResultsAnd here s the result Oh wait what is this crap in the middle As it turns out our shitty OS specific webview decided to automatically turn into a long dash something nobody ever asked it to do Neither Chrome nor Safari does that nor any other program I ve seen it s just whichever crappy frontend Pywebview is using I already mentioned all the other problems with Pywebview but this just shows again what a terrible idea it is to use whatever happens to be bundled with the OS People often whine about Electron apps being big due to bundled browser but that those few MBs avoid all such issues at once As usual all the code for the episode is here	2021-11-12 15:09:07
海外TECH	DEV Community	AWS Redshift (Part 1)	https://dev.to/aws-builders/aws-redshift-part-1-4nnk	AWS Redshift Part As an AWS solutions architect you must set up a solution that helps the data analysts in your company to process large historical data for some released products The data scientists and the developers suggest collecting all the results of the queries for additional analytics with Amazon EMR Athena and SageMaker What AWS solution can you use in this context To answer this question you need first to know what type of database you are dealing with Generally we can classify databases into two groups according to the approach that they use which affects the type of data we want to extract eventually On Line Transactional Processing databases OLTP Like RDS it has a high transaction volume of simple and short queries OLTP databases rely on four main operations Create Read Update and Delete For example with RDS you can CREATE a table containing products and their corresponding prices you can READ the content of the table UPDATE the names or the prices of the products and DELETE a product that you will no longer sell for the customers On Line Analytical Processing Databases OLAP It has a relatively low transaction volume of sophisticated and long queries that urge aggregations OLAP DBs are used mainly for analytics Through the previous definitions it became obvious that an OLAP is required in our context An example of an OLAP database on AWS is Redshift Redshift is fully managed by AWS It is a petabyte scale data warehouse service Unlike RDS and many other OLTP databases which use rows Redshift uses columns to store data It also uses advanced compression and Massive parallel processing of data This makes it ten times faster than SQL databases Redshift helps to report visualize and analyze collected data You can save the results of your queries to an S data lake so you can do additional analytics with services provided by AWS like Athena and SageMaker Although Redshift is fully managed by AWS it is set up ONLY in ONE availability zone and can t take large data ingestion in real time	2021-11-12 15:03:25
海外TECH	DEV Community	The ultimate guide to cloud cost optimization	https://dev.to/castai/the-ultimate-guide-to-cloud-cost-optimization-mb6	The ultimate guide to cloud cost optimizationThe cloud s scalability is both a blessing and a curse Sure you can experiment with new ideas without having to worry about getting another rack of servers But if you re reading this you know there s a price to pay for this comfort Overprovisioning and cloud sprawl are real They will make even a tech giant CFO s eye twitch at the end of the quarter Take Pinterest as an example During one holiday season the company s cloud bill went way over the initial estimates because of increased usage and Pinterest had to pay AWS million on top of the million worth of reserved resources  The only way you can deal with the long term cost implications of the cloud is by implementing cloud cost optimization And if you don t want optimization to become a drag on your engineering team automating it is the only move that gets you there Check out this guide to optimizing cloud costs step by step Know what you can win by optimizing cloud costsStart by understanding your cloud billChoose the best compute resources for your applicationAchieve greater savings with spot instancesDon t get lured by the promise of savings plansPick the right tool for the jobCloud automation opens the doors to the greatest savingsWhat you re doing in the cloud could be done for less Know what you can win by optimizing cloud costs Is optimizing cloud costs worth your time Take a look at ​​the optimization gains reported by companies in communication entertainment SaaS and e commerce In Q Zoom reported that its gross margin widened to from in the previous quarter primarily because of the effort invested in optimizing public cloud resources Spotify built a custom tool called Cost Insights to track cloud expenses and encourage engineers to take ownership of the cloud spend reducing its annual cloud spend by millions of dollars By making some smart incremental optimization of infrastructure decisions Segment increased its gross margin by and reduced its infrastructure costs by despite experiencing a larger traffic volume all within three months  The e commerce startup La Fourche saw its cloud bill rise dramatically and ran the CAST AI Savings Report to find optimization opportunities By turning automated optimization on the company reduced its monthly cloud bill by without increasing engineer workload Now that you know that it s worth playing the optimization game let s see what methods teams choose to prevent their cloud costs from spiraling out of control Start by understanding your cloud billTake a look at your cloud bill and you re likely to get lost  Bills are long complex and hard to unpack because every service has a defined billing metric Understanding your usage to the point where you can make a decision confidently is next to impossible And we re talking about analyzing costs for only one cloud and one team Try billing for multiple teams or clouds This is where cost allocation comes in and reveals who is using which resources How else can you make anyone accountable for these costs Cost allocation is especially challenging in dynamic infrastructures running on Kubernetes Why is it worth examining and allocating costs based on your cloud bill Because it s a treasure trove of data that will help you forecast your requirements better and secure the right amount of resources and avoid the curse of overprovisioning But estimating your future resource demands is no small feat Here s an example sequence you may follow Gain visibility and analyze your usage reports to identify any patterns in spending Detect peak resource usage scenarios with the help of periodic analytics and crunching your historical usage data Take seasonal customer demand patterns into account and check if they correlate with your peak resource usage If you see that identifying them in advance might get just a tiny bit easier Make sure to monitor resource usage reports regularly and set up alerts to keep cloud costs in check Create an application level cost plan by measuring application or workload specific costs This will also open the doors to calculating the total cost of ownership of your cloud infrastructure  Next take a look at the pricing models of your cloud providers and plan capacity requirements over time Putting all of this data in one place makes understanding your costs easier The tasks listed above aren t one off jobs You need to do that on a regular basis to get results  Learn more about how to analyze your cloud bill here Surprised by your cloud bill common issues amp how to deal with them Choose the best compute resources for your applicationChoosing the right virtual machine can be a huge game changer if your application relies on compute But AWS has almost different instances Similar instance types deliver different performance across cloud providers and even in the same cloud a more expensive instance doesn t equal higher performance Define your minimum requirements Make sure to do it across all compute dimensions including CPU architecture count choice of processor Memory SSD and network connectivity   Select the right instance type You can choose from various combinations of CPU memory storage and networking capacities that come packaged in instance types that are optimized for one such capability   Set the size of your instance Remember that the instance should have enough capacity to accommodate your workload s requirements and include options like bursting if necessary Examine different pricing models The three major cloud providers offer different rates on demand pay as you go reserved capacity spot instances and dedicated hosts Each of these options has its advantages and drawbacks They re covered in detail in this guide How to choose the best VM type for the job and save on your cloud bill  Achieve greater savings with spot instancesIt s smart to buy idle capacity from AWS and other large cloud providers because spot instances are up to cheaper than on demand ones However there is a catch the vendor reserves the right to reclaim these resources at any moment You need to make sure that your application is prepared for that before jumping on the spot bandwagon Here s how to use spot instances Examine your workload to see if it s ready for a spot instanceCan withstand interruptions How long will it take to complete the job Is this a mission critical workload These and other questions aid in the qualification of a workload for Spot Instances Examine the services of your cloud providerIt s a good idea to look at less popular instances because they re less likely to be interrupted and can operate for longer periods of time Check the frequency of interruption of an instance before settling on it Now it s time to bidSet the highest amount you re prepared to pay for your chosen spot instance Note that it will only run as long as the market price meets your offer or is lower Setting the maximum price at the level of on demand pricing is the rule of thumb here Manage spot instances in groupsThat way you ll be able to request numerous instance types at once increasing your chances of landing a spot instance To make all of the above work well prepare to spend a lot of time on configuration setup and maintenance tasks unless you decide to automate it Want to learn more about spot instances Here s a complete guide Spot instances How to reduce AWS Azure and GCP costs by Don t get lured by the promise of savings plansReserving capacity for one or three years in advance at a much cheaper rate seems like an interesting option Why not buy capacity in advance when you know that you ll be using the service anyway But like anything else in the world of the cloud this only seems easy You already know that forecasting cloud costs is hard Even companies that have entire teams dedicated to cloud cost optimization miss the mark here  How are you meant to plan ahead for capacity when you have no clue how much your teams will require in one or three years This is the main issue with products like reserved instances and savings plans Here are a few things you should know about reserving capacity A reserved instance works by use it or lose it every hour that it sits idle is an hour lost to your team with any financial benefits you might have secured When you commit to specific resources or levels of consumption you assume that your needs won t change throughout the contract s duration But even one year of commitment is an eternity in the cloud And when your requirements go beyond what you reserved you ll have to pay the price just like Pinterest did  When confronted with a new issue your team may be forced to commit to even more resources Or you ll find yourself with underutilized capacity that you ve already paid for In both scenarios you re on the losing end of the game By entering into this type of contract with a cloud service provider you risk vendor lock in i e becoming dependent on that provider and whatever changes they introduce for the next year or three  Selecting optimal resources for reservation is complex just check out point above in this article The above is just the tip of the iceberg We wrote an entire article that dives into the details of reserved instances Do AWS Reserved Instances and Savings Plans really reduce costs Pick the right tool for the jobTo gain control over their cloud expenses companies apply various cost management and optimization strategies and solutions in tandem Cost visibility and allocation Using a variety of cost allocation monitoring and reporting tools you can figure out where the expenses are coming from Real time cost monitoring is especially useful here since it instantly alerts you when you re going over a set threshold A computing operation left running on Azure resulted in an unanticipated cloud charge of over k for one of Adobe s teams One alert could have prevented this Cost budgeting and forecasting You can estimate how many resources your teams will need and plan your budget if you crunched enough historical data and have a fair idea of your future requirements Sounds simple It s anything but Pinterest s story shows that really well Legacy cost optimization solutions This is where you combine all of the information you got in the first two points to create a complete picture of your cloud spend and discover potential candidates for improvement Many solutions on the market can assist with that like Cloudability or VMware s CloudHeath But most of the time all they give you is static recommendations for engineers to implement manually Automated cloud native cost optimization This is the most powerful solution for reducing cloud costs you can use This type of optimization doesn t require any extra work from teams and results in round the clock savings of and more even if you ve been doing a great job optimizing manually A fully autonomous and automated solution that can react quickly to changes in resource demand or pricing is the best approach here  Should we continue to rely on software engineers to do all the management and optimization tasks manually  Not with so many automation options at hand Cloud automation opens the doors to the greatest savingsAs you can tell from the points above manual cost optimization is a complex and time consuming process  And regardless of the skill level of engineers many of the cost optimization tasks are just not suited for humans  Allocate comprehend analyze and anticipate cloud expenses and you ll see how hard that is Then you need to make infrastructure adjustments investigate pricing plans spin up more instances and do a variety of other tasks to create a cost effective infrastructure Automation takes many of these tasks off your plate Apart from getting rid of all the tasks above an automated solution adds more value because it Selects the most cost effective instance types and sizes to meet your application s needs Automatically scales your cloud resources up and down to cope with demand spikes and drops Removes resources that aren t in use to eliminate waste Makes use of spot instances and gracefully manages disruptions Automates storage and backups security and compliance management and changes to configurations and settings to help you save money in other areas Most importantly an automated platform implements all of these modifications in real time mastering the point in time nature of cloud cost optimization Automation takes advantage of things you d never imagine to checkWe used a combination of AWS On Demand and spot instances to operate our application running on CPUs and GB of RAM  Then we decided to run it through CAST AI to check if our configuration was optimized The platform suggested moving to a spot instance INF But wait isn t that a pricey ML specialized GPU instance  As it turned out that instance was at that time actually cheaper than the general purpose compute instances we were using We would have lost out on this hidden gem without automation What you re doing in the cloud could be done for lessYou already learned from examples like Zoom Spotify or La Fourche that reducing cloud costs can have a significant impact on your bottom line The low hanging fruit here is cloud cost optimization But standard tactics such as expense monitoring and reporting will only get you halfway there at a significant engineer time cost Discover what automated cloud cost optimization can do for your business Book a quick call with CAST AI the cloud optimization platform for Kubernetes P S You can always check the product out on your own terms and even run a free report Simply register here to get started	2021-11-12 15:03:17
海外TECH	DEV Community	Making the most boring website ever with TypeScript, NestJs, React and others. Part 8.	https://dev.to/nordicbeaver/making-the-most-boring-website-ever-with-typescript-nestjs-react-and-others-part-8-1pjo	Making the most boring website ever with TypeScript NestJs React and others Part This series is about making a generic website for a local business with TypeScript NodeJs NestJs Prisma React and NextJs I m trying to make my videos quite short about minutes each except for the first one while putting as much content there as I can Here is the full playlist In this videos we ll create a User model to store users data on the server and discuss why we need password hashing and salt We ll also add new forms and pages to manage users in the Admin panel Enjoy	2021-11-12 15:01:19
Apple	AppleInsider - Frontpage News	Best deals Nov. 12: Save $11 on Mario Kart Live, $120 off Bose QuietComfort headphones, and more!	https://appleinsider.com/articles/21/11/12/best-deals-nov-12-save-11-on-mario-kart-live-120-off-bose-quietcomfort-headphones-and-more?utm_medium=rss	Best deals Nov Save on Mario Kart Live off Bose QuietComfort headphones and more Friday s best deals include off a Samsung soundbar off a Keurig K Duo off the fifth generation Apple TV K and more Best deals November There are a lot of sales each day but only a handful are worth pursuing So rather than sifting through miles of advertisements we ve hand picked a bunch just for the AppleInsider audience Read more	2021-11-12 15:12:16
Apple	AppleInsider - Frontpage News	China's JD sold $15.6 million of iPhone 13 in first two seconds of sales event	https://appleinsider.com/articles/21/11/12/chinas-jd-sold-156-million-of-iphone-13-in-first-two-seconds-of-sales-event?utm_medium=rss	China x s JD sold million of iPhone in first two seconds of sales eventChina s JD com and Alibaba have reported record breaking earnings from the country s Singles Day sales event chiefly from luxury goods and the iPhone Apple s iPhone ProApple s launch of iPhone preorders in September was so popular that it Chinese retail websites went down under the demand Subsequently it was estimated that over five million preorders were placed and JD com alone took over three million preorders Read more	2021-11-12 15:13:09
Cisco	Cisco Blog	Improving Application Experience with Deep Network Visibility	https://blogs.cisco.com/networking/improving-application-experience-with-deep-network-visibility	Improving Application Experience with Deep Network VisibilityLearn how Deep Network Visibility is the foundation of a network and security operating model that ensures application experience delivered to the workforce and customers meets or exceeds expectations	2021-11-12 15:32:17
海外TECH	CodeProject Latest Articles	Multiplatform Avalonia .NET Framework Programming Advanced Concepts in Easy Samples	https://www.codeproject.com/Articles/5317055/Multiplatform-Avalonia-NET-Framework-Programming-A	design	2021-11-12 15:46:00
海外科学	NYT > Science	Biden to Choose Robert Califf to Lead F.D.A., Despite Drug Industry Ties	https://www.nytimes.com/2021/11/12/us/politics/robert-califf-fda.html	Biden to Choose Robert Califf to Lead F D A Despite Drug Industry TiesDr Robert M Califf an academic and clinical trial researcher who ran the agency in has also consulted for pharmaceutical companies	2021-11-12 15:37:36
金融	金融庁ホームページ	「モデル・リスク管理に関する原則」に対するパブリックコメントの結果等について公表しました。	https://www.fsa.go.jp/news/r3/ginkou/20211112.html	結果	2021-11-12 17:00:00
金融	金融庁ホームページ	火災保険水災料率に関する有識者懇談会（第２回）議事要旨及び資料を公表しました。	https://www.fsa.go.jp/singi/suisai/gijiyousi/20211005.html	有識者懇談会	2021-11-12 17:00:00
金融	金融庁ホームページ	「会計監査の在り方に関する懇談会（令和３事務年度）」論点整理について公表しました。	https://www.fsa.go.jp/news/r3/singi/20211112.html	会計監査	2021-11-12 17:00:00
金融	金融庁ホームページ	バーゼル銀行監督委員会による「グローバルなシステム上重要な銀行（G-SIB）の評価手法のレビュープロセスに関する技術的改訂の最終化」について公表しました。	https://www.fsa.go.jp/inter/bis/20211112/20211112.html	銀行	2021-11-12 17:00:00
金融	金融庁ホームページ	審判期日の予定を更新しました。	https://www.fsa.go.jp/policy/kachoukin/06.html	期日	2021-11-12 16:00:00
ニュース	BBC News - Home	UK bucking Covid trend but concern over winter	https://www.bbc.co.uk/news/health-59262701?at_medium=RSS&at_campaign=KARANGA	europe	2021-11-12 15:49:51
ニュース	BBC News - Home	Caerphilly dog attack: Inquest into Jack Lis death opens	https://www.bbc.co.uk/news/uk-wales-59260354?at_medium=RSS&at_campaign=KARANGA	attack	2021-11-12 15:28:03
ニュース	BBC News - Home	Essex cricket chairman resigns over racist language claim	https://www.bbc.co.uk/sport/cricket/59262824?at_medium=RSS&at_campaign=KARANGA	board	2021-11-12 15:23:21
ニュース	BBC News - Home	AstraZeneca to take profits from Covid vaccine	https://www.bbc.co.uk/news/business-59256223?at_medium=RSS&at_campaign=KARANGA	price	2021-11-12 15:54:11
ニュース	BBC News - Home	Number of migrants crossing Channel to UK tops 1,000 in new daily record	https://www.bbc.co.uk/news/uk-59257107?at_medium=RSS&at_campaign=KARANGA	weather	2021-11-12 15:43:10
ニュース	BBC News - Home	Lampard pulls out of Norwich head coach talks	https://www.bbc.co.uk/sport/football/59256413?at_medium=RSS&at_campaign=KARANGA	coach	2021-11-12 15:48:33
サブカルネタ	ラーブロ	Japanese Soba Noodles 蔦＠代々木上原　「吟麦つけ麺（醤油）、出汁割り」	http://ra-blog.net/modules/rssc/single_feed.php?fid=193615	japanesesobanoodles	2021-11-12 15:01:35
北海道	北海道新聞	道、ふるさと納税返礼品に電子クーポン導入へ　道内旅行で利用可能	https://www.hokkaido-np.co.jp/article/611123/	利用可能	2021-11-13 00:19:45