#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/

Turso — SQLite for Production

Turso is SQLite for production: great developer experience and efficiency with essential quality of life improvements for modern applications.

Turso
Personal Knowledge Graphs in AI RAG on user phone - Volodymyr Pavlyshyn - Medium

Graphs and vector search are powerful tandems for AI-powered applications, which are booming nowadays. Personal knowledge graphs are the core of semantic memory for many agentic AI applications. At…

Medium
The space complexity of vector indexes in LibSQL - Volodymyr Pavlyshyn - Medium

LibSQL builds on existing data types and directly adds effective LM-DiskANN algorithm-based vector indexes to your database. The full paper can be found here…

Medium

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!

- YouTube

Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.

"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

The SQLite JSONB Format

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
libSQL, the fork of SQLite, crosses 5k GitHub stars - Turso Blog

Turso Blog
@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.
GitHub - tursodatabase/libsql: libSQL is a fork of SQLite that is both Open Source, and Open Contributions.

libSQL is a fork of SQLite that is both Open Source, and Open Contributions. - tursodatabase/libsql

GitHub

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