mastodon.gamedev.place is one of the many independent Mastodon servers you can use to participate in the fediverse.
Mastodon server focused on game development and related topics.

Server stats:

5.1K
active users

#sqlite3

0 posts0 participants0 posts today
Continued thread

One of the great things about #golang is easy cross-compilation. However, most #golang #sqlite3 drivers make it considerably less easy by wrapping around the C implementation, requiring #cgo. Now there's a new `database/sql` compatible driver that gets rid of #cgo by wrapping the #sqlite #wasm build instead. Neat!

[2/2]

github.com/ncruces/go-sqlite3

GitHubGitHub - ncruces/go-sqlite3: Go bindings to SQLite using wazeroGo bindings to SQLite using wazero. Contribute to ncruces/go-sqlite3 development by creating an account on GitHub.
Continued thread

I'm not sure what to think of the SQL statement limit for SQLite3 (sqlite.org/limits.html):
> [...] text of an SQL statement is limited to SQLITE_MAX_SQL_LENGTH which defaults to 1,000,000,000.
but also:
> [...] SQL statement is limited to be a million bytes in length, then obviously you will not be able to insert multi-million byte strings

Except the it first says 1 billion bytes (or almost a GB) which can easily handle a multi-million byte length string.

www.sqlite.orgImplementation Limits For SQLite
Okay, mysqlbrowser (from the #Debian repositories) is actually a pretty decent tool. It provides a nice point-and-click interface that makes working with #sqlite3 databases a little bit nicer. Knowledge of how to write an #SQL query is still a requirement, but it makes creating/editing tables more convenient. Maybe it's well known, but I just discovered it yesterday.

My #Synology NAS decided to went into ReadOnly mode for no reason. The problem is that i need to evacuate 50TB of data to 5TB drives. I can not connect all those 5TB drives and once and They're quite not reliable - some are crashing after writing some data to them.

Is there a ready program which cna help me?

So far my plan is to write #Python script to index all those files into #sqlite3 database and then prepare lists of files which fits into space on external drives.

Using R, Shiny and SQLite3 to host online stats assignments is a load of fun.

Until you accidentally swap out the SQL-data file with an empty one🤦

No worries, the swap-out command saves the existing data, just in case.

A fun evening, writing R code to read the SQL, combining data accumulated in the "empty" file with the existing data, writing it out to Stata (where sane people do their complex data manipulation), reading it back into R to write to SQL.