投稿時間:2022-07-06 01:21:45 RSSフィード2022-07-06 01:00 分まとめ(26件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
python	Pythonタグが付けられた新着投稿 - Qiita	[dataclasses-json] Dict型のプロパティに文字列を設定しようとすると、"TypeError: Type List cannot be instantiated; use list() instead"が発生した	https://qiita.com/yuji38kwmt/items/80f3af9f7a6cd2bc02f4		2022-07-06 00:52:12
python	Pythonタグが付けられた新着投稿 - Qiita	Bokeh 凡例クリックにカスタムイベントを登録する	https://qiita.com/TKfumi/items/6e0d36ccdc6dc6e192ef	bokeh	2022-07-06 00:09:46
js	JavaScriptタグが付けられた新着投稿 - Qiita	もう一度JavaScriptを理解する part2	https://qiita.com/hu-yu/items/50ca7faafa288dc13140	upampgoingchapterintojava	2022-07-06 00:51:27
js	JavaScriptタグが付けられた新着投稿 - Qiita	【Vue.js】Computed, Watchの使い分け	https://qiita.com/potato_chips/items/aae628a79e05fe9c7e08	computed	2022-07-06 00:46:57
js	JavaScriptタグが付けられた新着投稿 - Qiita	[黙示録] Macでnodebrew を使ってnode.jsをインストールする方法	https://qiita.com/kashiwa_sier/items/2e5bb0b51a35363bb861	homebrewmaco	2022-07-06 00:23:25
海外TECH	MakeUseOf	4 Ways to Use Hashtags on TikTok	https://www.makeuseof.com/ways-to-use-hashtags-on-tiktok/	tiktok	2022-07-05 15:30:14
海外TECH	MakeUseOf	How to Fix Windows Update When It's Stuck in Windows 10	https://www.makeuseof.com/tag/windows-update-stuck/	update	2022-07-05 15:15:14
海外TECH	MakeUseOf	9 Common Tinder Mistakes You Need to Avoid Making	https://www.makeuseof.com/tag/using-tinder-avoid-5-common-mistakes/	matches	2022-07-05 15:05:14
海外TECH	DEV Community	I have been awarded for 9 years in a row as Microsoft MVP	https://dev.to/kasuken/i-have-been-awarded-for-9-years-in-a-row-as-microsoft-mvp-28a5	I have been awarded for years in a row as Microsoft MVPSince many years the st of July this year the date was postponed a few hours before the due date is a special day for me It s the day each year we wait for renewal as Microsoft MVP for another year It s call The F day because we are waiting for the confirmation email of the award For me it s the th year in a row but each time is like the first time I am proud and honored to have been a part of this family for so long and hope to be a part of it for much longer Talking by numbersThis year I tried to summarize my activities with some objective numbers ️ blog posts since ️ events as a speaker‍ events in person keynote events as a producer organizer️ hours on Twitch even I didn t stream since January ️ interviews as guest Best moment of the yearThis is the timelapse of my keynote at Codemotion Italy with more than thousand people connected After this session I received a lot of questions about my setup and the tools I use for online sessions This is the reason why after a few days I wrote a blog post about my setup during a conference Tools I use for my online sessions at events Emanuele Bartolesi・Mar ・ min read speaking tooling event If you want to know more about my setup in general instead click on the picture below to find out about my current setup ConclusionI think years are a good achievement but now I d like to get to the year mark And of course I just started to work on it	2022-07-05 15:24:09
海外TECH	DEV Community	How to Effectively Integrate a Typography System in React Native	https://dev.to/rootstrap/how-to-effectively-integrate-a-typography-system-in-react-native-20hd	How to Effectively Integrate a Typography System in React Native The ProblemIf there is one thing that most react native apps have in common it is how they display text Some simple apps show very little but most apps display a lot That is why it s vital to put the right system in place to ensure adding and refactoring texts in your app is as simple as possible Now you might be thinking why am I reading an article on how to manage such a simple component It s just text right Yes but more often than not you need to apply styles and properties to said text to make it look the way you want When you have to do it for all the texts in your app it adds up This of course begs the question how can I reduce the amount of code repetition Over the years I have seen my fair share of attempts at solving this problem and I can finally say that I have landed on one solution that left me quite pleased The SolutionThe solution is quite simple but it s based on following best UI practices What do I mean Having predefined styles for headings paragraphs and other texts that you might need What is important is that all the texts of your app fall into one of those definitions and that the amount doesn t get out of hand It s good to keep the number of definitions short so it s easier to remember what to put when coding and that your app is consistent in its respective styling which in turn gives you usability and accessibility points Without any further ado here is the aforementioned code of the component and supplementary files Once you have all of that in place you can simply import the component and use it as follows It s as simple as that and usually you will only have to apply extra styles to a particular text component instance if you need to add spacing color or wrapping Taking the naming convention and hierarchy of text components from the web makes it very easy to understand and remember As you may have noticed with the use of prop types it is very easy to notice if you misspelled a type when setting it on an instance of said component Although adding custom fonts to your React Native project is out of scope for this article you might find link here this article useful where we cover that subject How to customize fonts in React Native ConclusionAs you can see the solution is very clean and simple but it fixes a problem in a component that is so basic that it is also often overlooked Putting a bit of time and thought into these kinds of components that make up the core DNA of our apps can go a long way I hope you find this article helpful and that you end up implementing this solution in your projects	2022-07-05 15:17:34
海外TECH	DEV Community	Speeding Up Bulk Loading in PostgreSQL	https://dev.to/supabase/speeding-up-bulk-loading-in-postgresql-41g5	Speeding Up Bulk Loading in PostgreSQL Speeding Up Bulk Loading in PostgreSQLTesting ways to bulk load data into PostgreSQL The Need For SpeedIf you only need to load a few hundred records into your database you probably aren t too concerned about efficiency But what happens when try to insert thousands or even millions of records Now data loading efficiency can mean the difference between success and failure for your project or at the very least the difference between a project that s delivered timely and one that s woefully overdue PostgreSQL has a great copy command that s optimized for this task But that s only a good solution if your data is specifically in a CSV or Binary file But what if you need to load data from pure SQL Then what s the fastest way Four Ways to Insert Data Basic Insert CommandsLet s look at the structure for some basic SQL insert commands create table users id integer firstname text lastname text insert into users id firstname lastname values George Washington insert into users id firstname lastname values John Adams insert into users id firstname lastname values Thomas Jefferson Now we have some basic SQL for inserting records into our user table This will get the data into our table alright but it s the slowest way to get data into our table Let s look at some ways we can speed things up TransactionsA quick and easy way to speed things up is simply to put large batches of insert statements inside a transaction begin transaction insert into users id firstname lastname values George Washington insert into users id firstname lastname values John Adams insert into users id firstname lastname values Thomas Jefferson commit In my Windows test this doubled the speed of the insert of k user records Under MacOS the speed tripled While you can technically create batches with billions of records in them you ll probably want to experiment with batch sizes of say or something like that to see what works best based on your hardware bandwidth and record size Batched InsertsAnother way to speed things up is to use the SQL batch insert syntax when doing your insert For example insert into users id firstname lastname values George Washington John Adams Thomas Jefferson This method speeds things up considerably In my tests it was about times faster The same rules apply to batch sizes as with transactions you ll want to test different batch sizes to optimize things I generally tend to start with a batch of around records for most applications and if that works well enough I leave it there What About Both Can you combine transactions and batch insert statements for even more speed Well yes and no You certainly can combine them but the speed increase is negligible or in my Windows test case it even slowed things down just a bit begin transaction insert into users id firstname lastname values George Washington John Adams Thomas Jefferson commit So while using both techniques here is perfectly valid it may not be the fastest way to load data The DownsidesWhat are the potential downsides of using transactions or batched inserts Error handling is the main one If any one of the records in your batch fails the entire batch will fail and no data will be inserted into your table from that batch So you ll need to make sure your data is valid or else have some way to break up and fix failed batches If the failure is caused by a unique constraint you can use the on conflict clause in your insert statement but if your insert fails for any other reason it ll throw out the whole batch Other Speed ConsiderationsThere are many other factors that can affect your data insert speed and ways you can make things even faster Removing indexes until after inserting data creating non logged tables and avoiding unnecessary unique keys are just a few of these These other optimizations will improve performance but probably not nearly as dramatically as the basic techniques described here ConclusionIf you need to deal with large amounts of data it pays to plan ahead when you re writing your SQL insert code A few small changes can potentially save you hours or sometimes even days of processing time Appendix Sample Test ResultsSee my GitHub Repo postgresql bulk load tests for some code to test these methods My test run results are listed below Windows VM UTM Windows create k users with individual insert statements secondscreate k users with individual insert statements in a transaction secondscreate k users with batch insert statement secondscreate k users with batch insert statement in a transaction seconds MacBook Pro M Max create k users with individual insert statementsreal msuser mssys mscreate k users with individual insert statements in a transactionreal msuser mssys mscreate k users with batch insert statementreal msuser mssys mscreate k users with batch insert statement in a transactionreal msuser mssys ms	2022-07-05 15:06:47
Apple	AppleInsider - Frontpage News	Moderate lead times suggest better than forecasted June quarter, analyst says	https://appleinsider.com/articles/22/07/05/moderate-lead-times-suggest-better-than-forecasted-june-quarter-analyst-says?utm_medium=rss	Moderate lead times suggest better than forecasted June quarter analyst saysEstimated delivery times for Apple products show that the Mac and Apple Watch may be the most supply constrained but the overall impact is still modest JP Morgan says iPhone modelsIn a note to investors seen by AppleInsider JP Morgan analyst Samik Chatterjee analyzes Apple lead times or the time it takes for a customer to receive their order after purchase Lead times aren t always an accurate assessment of demand but can shed light on supply demand balance Read more	2022-07-05 15:08:53
Apple	AppleInsider - Frontpage News	Apple is preparing three new M2 Macs [u]	https://appleinsider.com/articles/22/07/05/apple-is-preparing-three-new-mac-studio-models?utm_medium=rss	Apple is preparing three new M Macs u References to three new M based Macs along with model identifiers and even code names have reportedly been found within unspecified Apple code With the M having made its way into multiple critically acclaimed Macs it s not a surprise that the M is going to appear in more too Now though a developer has spotted specific references to as yet unreleased M models and many more Apple devices MacMacMacーPierre Blazquez pierre blzqz June Read more	2022-07-05 15:14:44
海外TECH	Engadget	Xbox Games with Gold will no longer include Xbox 360 titles	https://www.engadget.com/games-with-gold-will-no-longer-include-xbox-360-titles-october-2022-155412541.html?src=rss	Xbox Games with Gold will no longer include Xbox titlesAs of October Microsoft will stop offering free Xbox titles through Games with Gold The company announced the change in an email sent out to Xbox Live Gold subscribers in the US Canada and other parts of the world “We have reached the limit of our ability to bring Xbox games to the catalog the company states in the message “However Games with Gold will continue to include exciting Xbox One titles and exclusive savings each month The email adds that Xbox users can redownload any titles they claimed through Games with Gold regardless of whether they continue to subscribe to Xbox Live Gold Microsoft did not immediately respond to Engadget s comment request Introduced in Microsoft added Games with Gold to Xbox Live Gold in response to the success of Sony s PS Plus service which was the first to offer free monthly games to customers Microsoft later extended the perk to include the Xbox One In recent years the allure of the bonus has waned with the introduction of Xbox Game Pass After Microsoft recently dropped the Xbox Live Gold requirement to play free to play games online it felt like the company was preparing to reconfigure the service and this announcement adds to that See the full email from Microsoft below Microsoft	2022-07-05 15:54:12
海外TECH	CodeProject Latest Articles	SQL Server: CASE with different clause	https://www.codeproject.com/Tips/1276985/SQL-Server-CASE-with-different-clause	select	2022-07-05 15:15:00
ニュース	BBC News - Home	Sydney floods aftermath: 'Everybody is traumatised'	https://www.bbc.co.uk/news/world-australia-62054522?at_medium=RSS&at_campaign=KARANGA	roads	2022-07-05 15:43:03
ニュース	BBC News - Home	British Airways cancels 1,500 more flights	https://www.bbc.co.uk/news/business-62038929?at_medium=RSS&at_campaign=KARANGA	airline	2022-07-05 15:05:52
ニュース	BBC News - Home	Sats results: Standards slip in Year 6 tests	https://www.bbc.co.uk/news/education-61980677?at_medium=RSS&at_campaign=KARANGA	covid	2022-07-05 15:49:31
ニュース	BBC News - Home	Premier League player questioned over two more rape claims against a different woman	https://www.bbc.co.uk/sport/football/62055175?at_medium=RSS&at_campaign=KARANGA	Premier League player questioned over two more rape claims against a different womanA Premier League player arrested in north London on Monday on suspicion of rape has been questioned over two further rape allegations	2022-07-05 15:04:24
ニュース	BBC News - Home	Scottish Open: LIV Golf players branded 'hypocrites and liars' by Billy Horschel	https://www.bbc.co.uk/sport/golf/62049001?at_medium=RSS&at_campaign=KARANGA	Scottish Open LIV Golf players branded x hypocrites and liars x by Billy HorschelIan Poulter claims he does not expect a hostile reception at this week s Scottish Open but American Billy Horschel launches a scathing attack on LIV Golf s rebels	2022-07-05 15:02:44
ニュース	BBC News - Home	Claressa Shields v Savannah Marshall: Undisputed middleweight fight announced for 10 September in London	https://www.bbc.co.uk/sport/boxing/61979513?at_medium=RSS&at_campaign=KARANGA	Claressa Shields v Savannah Marshall Undisputed middleweight fight announced for September in LondonBritain s WBO champion Savannah Marshall will challenge unified champion Claressa Shields for the undisputed middleweight championship in London on September	2022-07-05 15:07:36
ニュース	BBC News - Home	Tour de France 2022: Wout van Aert claims victory on stage four	https://www.bbc.co.uk/sport/cycling/62055178?at_medium=RSS&at_campaign=KARANGA	Tour de France Wout van Aert claims victory on stage fourWout van Aert s sensational break away from the pack in the final km allowed him to claim his maiden victory at this year s Tour de France on stage four	2022-07-05 15:41:35
ニュース	BBC News - Home	Chris Pincher: Tory MPs ask how long ministers can tolerate government lies	https://www.bbc.co.uk/news/uk-politics-62052862?at_medium=RSS&at_campaign=KARANGA	chris	2022-07-05 15:02:44
北海道	北海道新聞	欧州議会、デジタル２法案を可決　巨大ＩＴ企業規制、今秋に施行へ	https://www.hokkaido-np.co.jp/article/702210/	欧州議会	2022-07-06 00:26:00
北海道	北海道新聞	女子複の青山組は準々決勝敗退　テニスのウィンブルドン選手権	https://www.hokkaido-np.co.jp/article/702208/	準々決勝	2022-07-06 00:23:00
北海道	北海道新聞	飼肥料の高騰　転作交付金厳格化　後志の農家「希望持てる政策を」	https://www.hokkaido-np.co.jp/article/702198/	高騰	2022-07-06 00:04:00