🚀 Just launched vnStat-rs, a Rust port of the classic network monitor! 🦀

Why?
✅ Centralized Logging: Aggregate server stats via #Libsql / #Turso.
✅ Zero Root: Runs entirely in user-space. No sudo needed.
✅ Hybrid Persistence: Local reliability + Cloud aggregation.
✅ CLI Compatible: Your favorite flags (-m, -d, -h) work out of the box.

Check it out: https://github.com/seungjin/vnstat-rs

#RustLang #OpenSource #Networking #vnStat #Linux

So it has been a bit, but this past weekend I started testing the waters with different frameworks for a major update to @FurryFediverse and landed on #Astro. Right now it’s a #NextJS aging base, and the site is mostly static data with table data refreshing infrequently that hasn’t been holding up well.

I also plan to do a UI overhaul to be more upfront with all the instances with better filters. I look forward to getting to work on it, and switching the database backend to open source #LibSQL as well.

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