Hacker News Reader

onderkalacion Sharding Postgres with Basic tier in Hyperscale (Citus), how why and when

As far as I can tell, considering that you are planning to migrate a multi-tenant application, you are pretty much ready to go. One step you should be careful is to make sure that all your queries include the tenantId filter.

There is a step-by-step documentation for migrating multi-tenant apps to Citus, which might help you to decide how much ready you are for a migration: https://docs.citusdata.com/en/latest/develop/migration.html#...

(p.s. I'm the author of the post)

onderkalacion Citus and pg_partman: Creating a scalable time series database on Postgres

> I doesn't even really seem to me you necessarily want to partition on time since your load distribution is going to be terrible.

I think that's not accurate. The tables mentioned in the post are first sharded/distributed on `repo_id`. Later, each shard is also partitioned on time dimension (i.e., `created_at `). Thus, the load should be distributed proportionally with the activity for each `repo_id`.

onderkalacion A list of 600 new free MOOCs

Thanks for the feedback. I didn't want to change the title of the text.

onderkalacion Bi-Directional Replication for PostgreSQL v1.0

Is there a documentation on "How BDR works?" or so?

onderkalacion How SQLite Is Tested

The title says "how SQLite is tester", well I don't think the article talks about "how". It only talks about the different types of tests that they apply. I'm curious about "how" it is done. Do you guys run a single "test" button and all the tests are executed? Or, all the tests are done independently? On which platforms do you test?

onderkalacion How is NSA breaking so much crypto?

There seemed to be no reason why everyone couldn’t just use the same prime, and, in fact, many applications tend to use standardized or hard-coded primes.

Then, if the prime number is standardized or hard-coded, why they just not use it? Why we need to break it?

onderkalacion Postgres – EXPLAIN explained

I couldn't find either.

onderkalacion Why most popular GitHub repos are all web related?

These stars counts are very low compared to the ones in the link.

onderkalacion Why most popular GitHub repos are all web related?

I don't agree with it. There are many other projects that many web developers use. For instance: editors, databases, linux utility tools and so.

onderkalacion Forgotify Only Plays Spotify Songs That No One Has Ever Played Before

Yeap, from the text "A crazier thought: Forgotify itself is, in a way, ephemeral. If the rate at which people are using Forgotify exceeds the rate at which Spotify adds new tracks, Forgotify is theoretically eating itself with each new listen."

onderkalacion Hacking java bytecode

Thanks for this one!

onderkalacion Best Computer Architecture Course Ever

That is just my comment for the course. It is not related to CMU or the professor.

onderkalacion Edsger Dijkstra on Dutch TV (2000)

He is speaking too slow :)

onderkalacion PM of Singapore Shares His C++ Sudoku Solver Source Code

Yeap, great idea :)

onderkalacion Pgsql: Create an infrastructure for parallel computation in PostgreSQL

Thanks for the reply. Then, my question becomes as follows: Is there a way for basic PostgreSQL users (as me) benefit from this (yet)? I don't want to dive into any codes :)

onderkalacion Pgsql: Create an infrastructure for parallel computation in PostgreSQL

Are there any examples how to use this feature?

onderkalacion We Analyzed 60,678 Libraries on GitHub – Here Are the Top 100

Doing similar things for C/C++/Python would be helpful!

onderkalacion Facebook Chats Are Being Scanned by a CIA Funded Company?

agreed!

onderkalacion Goodbye MongoDB, Hello PostgreSQL

Who doesn't want NoSQL with ACID properties? Can anyone tell me what is superior on MongoDB compared to PostgreSQL?

If anybody is going to talk about scalability, there are many good alternatives to scale PostgreSQL too.

onderkalacion Writing a code coverage tool

I think writing it with asm library is much easier. Your code gets too long for a line coverage tool.

onderkalacion Dropbox accesses all the files in your PC?

Dropbox does not allow SSL interception of its traffic. It immediately errors out saying host is not trusted or smth else.

onderkalacion Dropbox accesses all the files in your PC?

I agree with you. The main problem is that why dropbox accesses the files that it is not permitted.

onderkalacion RapidShare is Shutting down

RapidShare was my childhood hero!

I think appearance of google drive/dropbox is the main reason of this. People easily share data with them.

onderkalacion Show HN: A Simple terminal-based video chat – renders in ASCII and has audio

Its one of the most interesting github projects that I've seen so far!

onderkalacion Practical Data Science in Python

For the ones who are seeking for data science in Python, that is great. Thanks for sharing!

onderkalacion UTF-9 and UTF-18

Some more detail on China's ipv9 http://www.circleid.com/posts/explaining_chinas_ipv9/

onderkalacion Show HN: Matterhorn – Your new project manager

I certainly agree with you. I am not willing to share my whole project information with someone who I have no ideas.