Reddit Programming
201 subscribers
1.22K photos
126K links
I will send you newest post from subreddit /r/programming
Download Telegram
A message to devs at the frontier of the AI shift
https://www.reddit.com/r/programming/comments/1rjjh1r/a_message_to_devs_at_the_frontier_of_the_ai_shift/

<!-- SC_OFF -->Most discussions about AI and programming focus on predictions and what the future holds for developers. This piece takes a different angle. It is about the human side of this moment: grief, hope and curiosity. And what it feels like when parts of the craft are changing rapidly. Curious if anyone here can relate to this. <!-- SC_ON --> submitted by /u/brotherthirteen (https://www.reddit.com/user/brotherthirteen)
[link] (https://jackcamerano.com/blog/a-message-to-devs-at-the-frontier/) [comments] (https://www.reddit.com/r/programming/comments/1rjjh1r/a_message_to_devs_at_the_frontier_of_the_ai_shift/)
JSON Documents Performance, Storage and Search: MongoDB vs PostgreSQL
https://www.reddit.com/r/programming/comments/1rjoo6e/json_documents_performance_storage_and_search/

<!-- SC_OFF -->Hey guys! Given Postgres universality, I decided to check how well it performs compared to Mongo, handling JSON documents; judging it from multiple angles: performance, storage and search. Among other things, the Elephant performs surprisingly well; here are some of the tests results: Inserts - single documents into the accounts collection Mongo - 17 658 QPS; Mean: 64.099 ms, Percentile 99: 974.379 ms Postgres - 17 373 QPS; Mean: 86.265 ms, Percentile 99: 976.375 ms Mongo wins with 1.016x (1.6%) higher throughput, latency lower 1.35x by mean and 1.002x (barely anything) by 99th percentile Inserts - single documents into the products collection Mongo - 2171 QPS; Mean: 8.979 ms, Percentile 99: 32.724 ms Postgres - 2213 QPS; Mean: 2.822 ms, Percentile 99: 26.417 ms Postgres wins with 1.019x (1.9%) higher throughput, latency lower 3.18x by mean and 1.24x by 99th percentile Updates - accounts by id Mongo - 18 809 QPS; Mean: 48.649 ms, Percentile 99: 463.375 ms Postgres - 15 168 QPS; Mean: 151.819 ms, Percentile 99: 927.956 ms Mongo wins with 1.24x (24%) higher throughput, latency lower 3.12x by mean and 2x by 99th percentile Finds - accounts by id Mongo - 41 494 QPS; Mean: 61.555 ms, Percentile 99: 1130.482 ms Postgres - 43 788 QPS; Mean: 29.407 ms, Percentile 99: 470.449 ms Postgres wins with 1.055x (5.5%) higher throughput, latency lower 2.09x by mean and 2.4x by 99th percentile Finds - sorted by createdAt pages of accounts, 10 to 100 in size Mongo - 20 161 QPS; Mean: 123.516 ms, Percentile 99: 553.026 ms Postgres - 4867 QPS; Mean: 134.477 ms, Percentile 99: 928.217 ms Mongo wins with 4.14x (414%) higher throughput*, latency lower 1.09x by mean and 1.68x by 99th percentile* Finds - accounts by owners Mongo - 22 126 QPS; Mean: 160.924 ms, Percentile 99: 740.514 ms Postgres - 30 018 QPS; Mean: 31.348 ms, Percentile 99: 491.419 ms Postgres wins with 1.36x (36%) higher throughput, latency lower 5.13x by mean and 1.5x by 99th percentile Finds - products by tags Mongo - 7170 QPS; Mean: 75.814 ms, Percentile 99: 1327.46 ms Postgres - 3624 QPS; Mean: 72.144 ms, Percentile 99: 729.601 ms Mongo wins with 1.98x (198%) higher throughput*, but latency is lower 1.05x by mean and 1.82x by 99th percentile for Postgres* Inserts, Updates, Deletes and Finds - accounts by id, mixed in 1:1 writes:reads proportion Mongo - 32 086 QPS; Mean: 125.283 ms, Percentile 99: 938.663 ms Postgres - 31 918 QPS; Mean: 130.354 ms, Percentile 99: 1040.725 ms Mongo wins with 1.005x (0.5%, barely anything) higher throughput, latency lower 1.04x by mean and 1.11 by 99th percentile Deletes - accounts by ids Mongo - 21 251 QPS; Mean: 136.414 ms, Percentile 99: 767.814 ms Postgres - 23 155 QPS; Mean: 65.286 ms, Percentile 99: 542.013 ms Postgres wins with 1.09x (9%) higher throughput, latency lower 2.089x by mean and 1.42x by 99th percentile There is of course a lot more details on the tests setup, environment, more than shown here test cases as well as storage & search comparison - they all are in the blog post, have a great read! <!-- SC_ON --> submitted by /u/BinaryIgor (https://www.reddit.com/user/BinaryIgor)
[link] (https://binaryigor.com/json-documents-mongodb-vs-postgresql.html) [comments] (https://www.reddit.com/r/programming/comments/1rjoo6e/json_documents_performance_storage_and_search/)
How we migrated 11,000 files (1M+ LOC) from JavaScript to TypeScript over 7 years
https://www.reddit.com/r/programming/comments/1rjv8p8/how_we_migrated_11000_files_1m_loc_from/

<!-- SC_OFF -->What started as voluntary adoption turned into a platform-level effort with CI enforcement, shared domain types, codemods, and eventually AI-assisted migrations. Sharing what worked, what didn’t, and the guardrails we used: https://www.patreon.com/posts/seven-years-to-typescript-152144830 <!-- SC_ON --> submitted by /u/patreon-eng (https://www.reddit.com/user/patreon-eng)
[link] (https://www.patreon.com/posts/seven-years-to-typescript-152144830) [comments] (https://www.reddit.com/r/programming/comments/1rjv8p8/how_we_migrated_11000_files_1m_loc_from/)