Create accountLogin

Recent searches

No recent searches

Search options

Only available when logged in.
helvede.net is one of the many independent Mastodon servers you can use to participate in the fediverse.
Velkommen til Helvede, fediversets hotteste instance! Vi er en queerfeministisk server, der shitposter i den 9. cirkel. Welcome to Hell, We’re a DK-based queerfeminist server. Read our server rules!

Administered by:

Server stats:

159
active users

helvede.net: AboutProfiles directoryPrivacy policy

Mastodon: AboutGet the appKeyboard shortcutsView source codev4.3.7

#sqlite

0 posts0 participants0 posts today
Public
Wesley Moore

As a stress test I loaded 8M bookmarks into a little SQLite backed bookmark saving/sharing web app I'm building. The slowest part turned out to be the `SELECT count(1) FROM bookmarks` query that's used as part of the pagination UI. Not what I was expecting but known/expected behaviour from what I've read. It takes 400ms on Snapdragon X Elite CPU, which is fine in practice—I'd be surprised if anyone actually stored more than 100k items in it.

#SQLite#Performance
Public
Data Quine

Subway Stories: Building an Visualization w/ Transit Data - Jediah Katz & Marc Zitelli -nyhackr Feb

"Every year, New Yorkers take more than a billion trips on the subway. Using data from the MTA, we mapped out how riders flow between stations at every hour. Each story explores a slice of city life."

Brilliant deep dive into prototyping, building and deploying the New York Subway Stories website.

youtube.com/live/83s_MWc5Yvs?s

subwaystories.nyc/

YouTubeSubway Stories: Building an Visualization w/ Transit Data - Jediah Katz & Marc Zitelli -nyhackr FebBy Lander Analytics
#Transport#Subway#Underground
Public
Leanpub

NEW! A Leanpub Frontmatter Podcast Interview with Isaak Tsalicoglou, Author of Northwind Elixir Traders: Learn Elixir and database modeling with Ecto and SQLite, all in one project | Watch here: youtu.be/zeUVFt82UG4 #books #ElixirLang #FunctionalProgramming #IndieHacker #Ecto #SQLite #SoftwareDevelopment #OpenSource #FullStackDev #LearnToCode #LeanpubPodcast

YouTubeIsaak Tsalicoglou, Author of Northwind Elixir Traders #books #podcast #programmingBy Leanpub
Public
Markus 🤓✨

I'm a database extremist. I default to #SQLite for pretty much anything.

As an independent software consultant, I need time tracking and CRM like anyone else. Guess what? It's just a single SQLite database file. :D Has worked wonderfully for years using just a database viewer app. (Tableplus, if you're wondering.)

But now, with this wonderful tool from Rune Kaagaard, I can hook up my database to Anthropic's Claude, and get insights into my time spent as well as my connections, just by chatting with Claude Sonnet 3.7.

Wild! :D

github.com/runekaagaard/mcp-al

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL. - runekaagaard/mcp-alchemy
GitHubGitHub - runekaagaard/mcp-alchemy: A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL. - runekaagaard/mcp-alchemy
Public
Bumble

Anyone using #litestream for an #sqlite DB

I have a 3GB database, and Litestream is replicating it to another server. However, it seems to be running out of control with disk space. On the original server (where the live DB is) is a generations folder under the hidden litestream folder. It is full of WAL files. Currently over 37,000 files consuming 118GB of disk space.

My config includes retention: 24h and retention-check-interval: 1h with a snapshot-interval: 4h. I understood it would delete anything older than 24 hours. Am I doing something wrong? These wal files go back to the day I started using litestream

#GoToSocial #gts @gotosocial@thefedi.forum

Continued thread
Public
LisPi
Brought to you by Mozilla #Firefox using dozens of #SQLite databases and clearly not batching the transactions.

Did no one stop to think for a second of the performance implications of dozens of close-together fsyncs|dsyncs on HDDs?

Also, why in the world so many databases? It's completely unnecessary and even though they *could* be used as attached databases, that means one can only use them in non-WAL mode (yay, blocking readers) to maintain proper global transactionality (https://sqlite.org/lang_attach.html https://sqlite.org/wal.html).

Did they even read the docs before doing this nonsense?
sqlite.orgATTACH DATABASE
Public
Giacomo Tesio
@gausby@mastodon.xyz

First, it's trivial to self-host on the cheapest shared hostings because it can run as a cgi.

Second, backup is trivial, as the whole installation rely on a single #SQLite file.

Third it's fast and it's based on a simpler mental model then git (no rebase, for example).

Forth, it's a complete solution, including wiki, issue management and even a forum. For high-skilled corporate teams, it's way better than git over (say) github, with less burocracy but still all acl that you might need.

Finally you don't need custom UI, since it provides all you need through a simple web interface.
Replied in thread
Public
Dr John A Stevenson

@robintw GeoPackages!

+ They can hold vector and raster data.
+ They are fully functioning SQLite databases.
+ They can include style information.
+ They can be emailed / SCP'd around the world.
+ You can synchronise and combine data from multiple users with @merginmaps.
+ It's an OGC standard so they work with ESRI tooling as well.

As that last point suggests, geopackages aren't exclusive to QGIS, but QGIS gives the tools to make the most of them.

#sqlite#geopackage#qgis
Public
Paul Buetow

#SQLite was designed as an #TCL extension. There are ~trillion SQLite databases in active use. SQLite heavily relies on #TCL: C code generation via mksqlite3c.tcl, C code isn't edited directly by the SQLite developers, and for testing , and for doc generation). The devs use a custom editor written in Tcl/Tk called "e" to edit the source! There's a custom versioning system Fossil, a custom chat-room written in Tcl/Tk!

tcl-lang.org/community/tcl2017

www.tcl-lang.orgSQLite's Use Of Tcl
Public
Markus 🤓✨

I'm working on a #GoLang #LLM web app starter kit that will be the basis of a series of blog posts.

Without external dependencies! State is #SQLite, embeddings with mxbai-embed-large-v1, chat completions using some size of Llama 3. Definitely work-in-progress, but follow along if you like! 🤓

github.com/maragudk/gai-starte

GitHubGitHub - maragudk/gai-starter-kit: Get started with LLMs, FTS and vector search, RAG, and more, in Go!Get started with LLMs, FTS and vector search, RAG, and more, in Go! - maragudk/gai-starter-kit
ExploreLive feeds
About