News for hackers. Stuff that matters.

A comment on SQLite-on-the-Server Is Misunderstood: Better at Hyper-Scale Than Micro-Scale. Parent comment

Re:SQLite-on-the-Server Is Misunderstood: Better at Hyper-Sc... by NathanFlurry on Monday March 03, 2025 @07:46PM (#43248751)
The two tables are intended to be part of the same "chat" partition (ie SQLite database). You can join them with a native SQLite query. Seems I should make this more clear.

Cheers

[ Parent | on HN ]
Re:SQLite-on-the-Server Is Misunderstood: Better at Hyper-Sc... by grounder on Tuesday March 04, 2025 @01:38PM (#43258416)
I understand the two tables in your chat example, I think. I'm wondering how you get the rest of the user profile data (name, for example). Is that table in a totally different SQLite database? If so, can you join on that, or do you need to query it separately? Thanks!
[ Parent | on HN ]
Re:SQLite-on-the-Server Is Misunderstood: Better at Hyper-Sc... by NathanFlurry on Tuesday March 04, 2025 @02:02PM (#43258676)
Yep. Most designs I've seen put user profiles under a different table which requires a separate query.
[ Parent | on HN ]