@planetsqlite

SQLite related community happenings, blog posts, articles, tutorials and more! Discover SQLite and learn when to use it and how to use it more effectively.

facebook.com/planetsqlite
Joined September 2015
  • Tweets190
  • Following224
  • Followers648
2Media
Based on #SQLite!
FerretDB@ferret_db6 Nov 2023
We have one goal:  Bring MongoDB back to open source.  The community deserves it. We are working on it to make it happen. Join our mission on GitHub: buff.ly/3Pzms3l
2
1
5
1,499
I think SQLite is the @htmx of database engines. And it is beautiful to see more and more people beginning to embrace the balance of simplicity and power that comes from KISS solutions across the stack.
4
2
20
1,712
Planet SQLite retweeted
FerretDB@ferret_db15 Sep 2023
Our #SQLite backend support is out of beta as we have released our v1.10 of @ferret_db Learn about the new features from our blog post: buff.ly/3ELWqTP #opensource #database
7
2
22
4,962
Planet SQLite retweeted
Ben Weiss
@keyboardsurfer2 Jun 2023
Is your SQLite database on Android performing at its best? 📈 Check out the freshly published best practices on SQLite performance to find out. #AndroidDev #performance developer.android.com/topic/…

Best practices for SQLite performance  |  App quality  |  Android Developers

Optimize your Android app's performance by following best practices for SQLite databases, including configuration, schema design, query optimization, and troubleshooting.

developer.android.com
4
54
1
197
34,862
Why SQLite is so great for the edge blog.turso.tech/why-sqlite-i…

Why SQLite is so great for the edge

Everyone already knows that SQLite is great. This article makes the praise much more specific though — it explains why we, the developers of libSQL, think that SQLite is a great choice for bringing...

turso.tech
8
39
14,630
Real-Time Full-Text Site Search with SQLite FTS5 extension blog.sqlitecloud.io/real-tim… #sqlite
8
1
26
3,302
How to Create GUI App with Tkinter and SQLite for Beginners #python #tkinter #sqlite morioh.com/p/93dfc5e94abe?f=…
1
59
1
226
27,586
Replying to @andrii_sherman
Checkout @pocketbase, it's a full BaaS as in one binary file. Offers a realtime database powerd by Sqlite. Both Sqlite and Pocketbase are awesome 💯
1
4
645
FerretDB adds initial support for SQLite, it turns SQLite into a MongoDB-compatible database.
FerretDB@ferret_db24 May 2023
FerretDB 1.2 is out! While this is a minor release, it introduces experimental support for #SQLite - our most requested feature to date. We turn SQLite into a #MongoDB-compatible database. Read more: blog.ferretdb.io/ferretdb-v-…
1
2
606
This is super cool Both @flydotio (LiteFS) and @Cloudflare (D1) now have distributed SQLite solutions SQLite is not a kiddie database anymore
Kenton Varda
@KentonVarda19 May 2023
So I've spent the last ~three months writing a new distributed storage engine based on SQLite and it has been FUN! blog.cloudflare.com/d1-turni…

D1: We turned it up to 11

We've been heads down iterating on D1, and we've just shipped a major new version that's substantially faster, more reliable, and introduces Time Travel: the ability to restore a D1 database to any...

blog.cloudflare.com
4
22
10,991
Planet SQLite retweeted
Luke
@luke_pighetti12 May 2023
More thoughts on SQLite and why it is the absolute champion
Luke
@luke_pighetti11 May 2023
SQLite is king
4
4
15
3,314
Planet SQLite retweeted
Ben Johnson
@benbjohnson16 Apr 2023
We just released LiteFS v0.4.0! The main focus was on making it easier to run and making it more transparent to the application. We want it to feel like you're just writing a plain old SQLite app, except, ya know... it's globally distributed. community.fly.io/t/litefs-v0…

LiteFS v0.4.0 Released

We’ve just released a new version of LiteFS! If you haven’t seen LiteFS before, it’s a distributed file system for automatically replicating SQLite databases around world. It’s great for read-heavy...

community.fly.io
12
66
12,329
Planet SQLite retweeted
keybits@keybits12 Apr 2023
Replying to @_mql
For making DB queries fast, SQLite is a compelling solution. See: sqlite.org/np1queryprob.html and fly.io/blog/all-in-on-sqlite… fly.io make bringing it close to the user (reduced latency) without traditional CDNs or cache a practical reality.
1
1
2
219
Planet SQLite retweeted
FerretDB@ferret_db9 Apr 2023
Replying to @arn4v @Spherical_Kat
We started adding basic #SQlite support for #FerretDB, it is on our roadmap for this quarter. @planetsqlite github.com/FerretDB/FerretDB…

Add SQLite backend support by w84thesun · Pull Request #2308 · FerretDB/FerretDB

Description 🤖 Generated by Copilot at 56343d7 Summary 🗄️🛠️🚀 This pull request adds SQLite support to FerretDB by introducing a new SQLite handler that implements the HandlerInterface for various...

github.com
1
2
368
SQLite is called Lite because it is lightweight. Lightweight can still be powerful!
v
@iavins31 Mar 2023
"SQLite should be named AwesomeSQL, because that is what it is." unixsheikh.com/articles/sqli…
SQLite the only database you will ever need in most cases The name SQLite is a nice name, but the "lite" part is misleading, it sounds like it is only useful for tiny things - which is very wrong. SQLite should be named AwesomeSQL, because that is what it is. SQLite is probably the only database you will ever need in most cases.

ALT SQLite the only database you will ever need in most cases The name SQLite is a nice name, but the "lite" part is misleading, it sounds like it is only useful for tiny things - which is very wrong. SQLite should be named AwesomeSQL, because that is what it is. SQLite is probably the only database you will ever need in most cases.

1
344
Planet SQLite retweeted
Peter Zaitsev
@PeterZaitsev7 Apr 2023
Strong Consistency with Raft and SQLite blog.sqlitecloud.io/strong-c…

Strong Consistency with Raft and SQLite

In the recent past, a typical client/server environment consisted of multiple clients connected to a central database server. A central database architecture is a system where all data is stored in a...

blog.sqlite.ai
5
22
1,942
Looks like @ferret_db is working on support for #sqlite, meaning that soon it is going to be possible to run #MongoDB database workloads on #sqlite, exciting!
1
1
11
1,866
imho one underestimated benefit of using sqlite is that *secrets* are never needed or leaked, and if your file system is also encrypted there's a whole class of security issues automatically resolved. I am playing around with fly.io sqlite3 and so far I love it!
3
12
3,189
SQLite delivers yet again with _awesome_, easy to understand documentation on query planning. sqlite.org/queryplanner.html
1
6
450
If you have not seen this one - The Untold Story of SQLite With Richard Hipp - CoRecursive Podcast corecursive.com/066-sqlite-w… #sqlite

The Untold Story of SQLite

On today's show, I'm talking to Richard Hipp about surviving becoming core infrastructure for the world. SQLite is everywhere. It's in your web browser, it's in your phone, it's probably in your car,...

corecursive.com
3
1
13
1,483
Load more