#devlog #MyRuckClub

- Moved #turso from #libSql to fetch to mitigate CORS issues.
- Realized through the migration step above, that each time the events page refreshes each event item made a turso call, thus to mitigate this setup a #pinia store.
- The pinia store has made the app faster, since the all turso calls done on first load and then functions off of that data.

And now I found out about #turso, an #sqlite service provider. 😅 They're using #libsql fork to make this doable.

The premise on the service is simple. They build a distributed sqlite set up. You as a user can then use that.

Knowing full well how to make a distributed sqlite and with backup control, this can take a lot of time. I can see value in that. 😅

And considering #litefs cloud is deprecated... It may be a good try. 🫠

https://turso.tech/

https://volodymyrpavlyshyn.medium.com/personal-knowledge-graphs-in-ai-rag-on-user-phone-eb304fc386c1 make #graphrag and #vectorsearch on user #device with #libsql

https://volodymyrpavlyshyn.medium.com/the-space-complexity-of-vector-search-indexes-in-libsql-3fadb0cdee96 #ann #vector search and space complexity for #personal #knowledgegraphs with #libsql

https://youtu.be/bxBhVDdizl8?si=P0eHKWq6LYvlcbNh
Exploring the world of embeddable databases for AI-powered apps and personal knowledge graphs! Discover the best options for portable and efficient data storage. 📊

#LevelDB #SQLite #LibSQL #Firebird #DuckDB #PGLite #CozoDB #RealDB #DataStorage #EmbeddedDatabases #AI #KnowledgeGraphs

Check out the full details on how these databases can transform your app's data management!

"A big new feature is introduced in the SQLite 3.45.0 release – the SQLite JSONB(https://sqlite.org/draft/jsonb.html)" from https://fedoramagazine.org/json-and-jsonb-support-in-sqlite-3-45-0

Current #libsql version I pulled now is #sqlite 3.44.0. Just 1 minor version to go!
```
# ./libsql
libSQL version 0.2.3 (based on SQLite version 3.44.0) 2023-11-01 11:23:50
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
libsql> select sqlite_version();
3.44.0
```
#jsonb #json

Post commemorating SQLite fork #libSQL achieving 500 GitHub stars and a brief history in to the project https://blog.turso.tech/libsql-the-fork-of-sqlite-crosses-5k-github-stars-e27efc70

@ellie Dose #atuin support #libsql (https://github.com/tursodatabase/libsql) instead of PostgreSQL? Seems like PostgreSQL is the only option. My personal life is enough for #SQLite scale.

I didn't know about this SQLite fork. ⎇

I wonder if it can be used with the same SQLite backend for the Django ORM. 🤔

You can read more about our goals and motivation in the announcement article 👇
https://itnext.io/sqlite-qemu-all-over-again-aedad19c9a1c

#sqlite #libsql #fork #opensource #python #django #orm

And there’s #libSQL, an open-sourcier (!) fork of #SQLite by Turso DB https://blog.turso.tech/were-bringing-libsql-into-the-turso-family-8cc1a653448e

Been impressed with Turso usage of #libSQL to the edge with replication and multi-tenancy, especially the performance. Great post about the underlying architecture including #sqlite https://compileralchemy.substack.com/p/libsql-diving-into-a-database-engineering

Thinking there may come a time #libsql defines itself as an alternate #postgres backend. 😅 Recently they released #sqld, an #sqlite server using postgres.

Nothing wrong with postgres wire protocol. Makes sense with how powerful it is. 😎

The weird part is libsql supporting more features of postgres not on sqlite. Which may make libsql more postgres using sqlite backend instead? 🤔

https://github.com/libsql/sqld/blob/main/README.md

WebAssembly functions for your SQLite-compatible database
With the first official release of libSQL, it is possible to execute user defined functions (UDF) written in WebAssembly.

https://blog.chiselstrike.com/webassembly-functions-for-your-sqlite-compatible-database-7e1ad95a2aa7

#wasm #sqlite #libsql

I just discovered that #libSQL (the #SQLite fork) supports WASM user defined functions, meaning you can write a function in any language you can get compiled to WASM and have that live in the db.

Has there EVER been another db with a function system that flexible?

Like, sure PL/pgSQL is prolly fine, but it's also PL/pgSQL, and not the language anyone really spends their days coding in, unless they've got a VERY atypical job.

» GitHub - libsql/libsql: #libSQL is a fork of #SQLite that is both #OpenSource , and Open Contributions. https://t.co/93Xw7hk10U

#libSQL is a fork of #SQLite that is both Open Source, and Open Contributions.
https://github.com/libsql/libsql?s=09