avinassh

> There are plenty of large projects written in Python.

There are, but they are certainly a pain in the ass to work with.

I once had to work on a semi-large Python codebase and got so frustrated that I wanted to port the code to some other language. The best part? I wrote the majority of that codebase myself, just months earlier.

I ranted about it here: https://avi.im/blag/2023/refactoring-python/

(I work at Turso)

libSQL does not support realtime/reactivity features. There have been attempts (by both our team and the community), but we encountered difficulties and ultimately abandoned the idea. I can check with the team for the exact reasons.

However, Limbo (our SQLite rewrite in Rust) will include this feature, though there is no ETA yet. It's currently being discussed here: https://github.com/tursodatabase/limbo/discussions/1149. Please share your thoughts and use cases.

disclosure: I work at Turso.

libSQL is our fork of SQLite. It adds new features on top of SQLite, such as vector search, replication, server mode, and more. libSQL is open source (MIT license).

The Turso SaaS platform, which provides hosted databases, is not open source.

Limbo (which will be renamed to Turso in the future) is our Rust rewrite of SQLite. It is also open source (MIT license) - https://github.com/tursodatabase/limbo

on this similar topic, the book `Writing for Developers - Blogs that get read` is also a great book

where can I read more?

If it based on some research papers, could you link them please

I watched the video, but I didn't understand why they create a 'funnel' at each step. Why not create an equal size array? is it because it would take more memory?

This looks great, how are you doing the benchmarks? It claims to be way faster than Redis. Can you also measure it against Microsoft Garnet? Whats the secret sauce for beating in latency?

Redis:

    Write Latency ~1.1ms
    Read Latency ~700µs
    Max Throughput ~85,000 ops/sec

Nubmq:

    Write Latency 900µs
    Read Latency 500µs
    Max Throughput 115,809 ops/sec

also, 700µs for Redis reads sounds high to me. Running against memtier_bench also would be great - https://github.com/RedisLabs/memtier_benchmark

> But tables in PG are heaps, so appending to them is even faster than in b-trees.

elaborate? how it is different, than say, MySQL?

Is there any introduction post on why one should use tmux OR what one is missing by not using them?

I am on both, but I actively use Bluesky (along with Twitter)

Larry always makes appearances in his reviews, lol

> But the real big news in 2023 was how Elon Musk personally helped reset Larry's Twitter password after he invested $1b in Musk's takeover of the social media company. And with this $1b password reset, we were graced in October 2023 with Larry's second-ever tweet and his first new one in over a decade.

https://www.cs.cmu.edu/~pavlo/blog/2024/01/2023-databases-re...

> These journalists made it sound like Larry was doing something nefarious or indecent, like the time he made his pregnant third wife sign a prenup two hours before their wedding. I can assure you that Larry was only trying to use his vast wealth as the 7th richest person in the world to help his country. His participation in this call is admirable and should be lauded. Free and fair elections are not a trivial affair, like a boat race where sometimes shenanigans are okay as long as you win. Larry has done other great things with his money that are overlooked, like spending $370m on anti-aging research so that he can live forever

https://www.cs.cmu.edu/~pavlo/blog/2022/12/2022-databases-re...

Both the words "Battleship" and "War ship" are used by DRH to describe USS Oscar Austin, so I used the same.

I did not know about distinction, so TIL!

That sentence builds up on the previously mentioned sentence about types.

> It is “weakly typed”. SQLite calls it “type affinity”. Meaning you can insert whatever in a column even though you have defined a type. Strong typed columns are opt-in

and then I call it

> I hate that it doesn’t have types. It’s totally YOLO

Both the words "Battleship" and "War ship" are used by DRH to describe USS Oscar Austin, so I used the same.

I did not know about distinction, so TIL!

> OP is wrong, SQLite does match the requirements outlined in the OSI's definition: https://opensource.org/osd

OSI also says Public Domain is not open source: Public Domain Is Not Open Source https://opensource.org/blog/public-domain-is-not-open-source

this is how SQLite page says:

> Since SQLite is used extensively in every smartphone, and there are more than 4.0 billion (4.0e9) smartphones in active use, each holding hundreds of SQLite database files, it is seems likely that there are over one trillion (1e12) SQLite databases in active use.

thank you for your kind words!

I have covered in the blog already, no?

> Strong typed columns are opt-in.

I will rephrase this

> The original source[0] (which you don't link to):

this is simply untrue! This is the first link in the sources.

I do highlight this part specifically in the image as well.

hey, I do provide all the sources at the end!

In the initial draft, I kept links next to text and the images, but I didn't like it aesthetically. So I moved all them to the bottom.

> Recycled, old points in listicle format on a popular topic with questionable accuracy.

Could you please state which are inaccurate? I am happy to correct them.

As for the rest of the comment, well, I don't know what to say. I am a beginner in databases and I am journaling the things I'm learning. Some of my posts might not have depth because I don't know much myself.

I will try to rephrase it and include links to Wikipedia and OSI

> As for whether SQLite is open source, well, the only reason a public domain dedication doesn’t meet the OSD is that it’s not a license. It’s more open.

That's true and I do acknowledge this in the post:

> Instead, SQLite is in the public domain, which means it has even fewer restrictions than any open source license.

[1] https://en.wikipedia.org/wiki/Open_source

[2] https://opensource.org/blog/public-domain-is-not-open-source

oops, I fixed the typo. Thank you!

> The OP failed to mention that SQLite does have opt-in strict tables

I did not, but probably I did not phrase correctly:

> Strong typed columns are opt-in.

> TLDR- - Position: Kneel on something raised (like a 6.5" platform), put your head lower than your stomach by resting it on your hands on the floor

A picture would help me. Is there any name of this exercise so that I can Google?

hey could you let me know which part you found confusing specifically, so that I can rephrase it? Thanks!

but they also have this:

> In order to keep SQLite completely free and unencumbered by copyright, the project does not accept patches. If you would like to suggest a change and you include a patch as a proof-of-concept, that would be great. However, please do not be offended if we rewrite your patch from scratch.

https://www.sqlite.org/copyright.html

My understanding was that th3 mainly does correctness tests. Other test suites are open source and can be used to ensure compatibility

Pekka already experimented with MVCC and I expect it to make it to Limbo at some point to enable multiple concurrent writers