overview for samc

3

SQLite Release 3.44.0 On 2023-11-01 (sqlite.org)

submitted 10 months ago by samc to c/sqlite

0 comments fedilink

A few nice new features in this release. Allowing ORDER BY aggregate functions could be very useful.

5

Batch size one billion: SQLite insert speedups, from the useful to the absurd (voidstar.tech)

submitted 10 months ago by samc to c/sqlite

0 comments fedilink

Interesting post on how to speed up batch inserts with SQLite.

6

SQLite's automatic indexes (misfra.me)

submitted 10 months ago by samc to c/sqlite

0 comments fedilink

Short post about how SQLite sometimes creates indexes just for a single query. The SQLite documentation has a little more information.

It can be worth setting up and monitoring the error log for SQLITE_WARNING_AUTOINDEX warnings as good indication a persistent index should be created.

5

The Untold Story of SQLite - CoRecursive Podcast (corecursive.com)

submitted 1 year ago by samc to c/sqlite

0 comments fedilink

Interview with Richard Hipp about the history of SQLite.

3

SQLite 3.43.0 released (sqlite.org)

submitted 1 year ago by samc to c/sqlite

0 comments fedilink

The main changes look to be contentless-delete FTS5 tables and performance enhancements to the query planner and JSON functions.

4

sqlite-utils - CLI tool and Python library for manipulating SQLite databases (sqlite-utils.datasette.io)

submitted 1 year ago by samc to c/sqlite

0 comments fedilink

From the homepage:

This library and command-line utility helps create SQLite databases from an existing collection of data.

Most of the functionality is available as either a Python API or through the sqlite-utils command-line tool.

sqlite-utils is not intended to be a full ORM: the focus is utility helpers to make creating the initial database and populating it with data as productive as possible.

It is designed as a useful complement to Datasette.

Cleaning data with sqlite-utils and Datasette provides a tutorial introduction (and accompanying ten minute video) about using this tool.

3

sqldiff.exe: Database Difference Utility (www.sqlite.org)

submitted 1 year ago by samc to c/sqlite

0 comments fedilink

Handy utility to diff SQLite databases.

Brave will not add Web Integration support in c/technology

[–] samc 13 points 1 year ago

Firefox Profiles work like Chrome profiles, although the UX is a little cliunky without an addon like Profile Switcher.

4

Making SQLite faster in Go (turriate.com)

submitted 1 year ago by samc to c/sqlite

0 comments fedilink

The author managed to reach 56,600 req/s!

While written about Go, not all the techniques used are Go specific.

1

How SQLite Scales Read Concurrency (fly.io)

submitted 1 year ago by samc to c/sqlite

0 comments fedilink

Explains how using WAL allows writes without blocking reads.

2

FerretDB - MongoDB protocol for SQLite or PostgreSQL (github.com)

submitted 1 year ago by samc to c/sqlite

0 comments fedilink

Converts MongoDB protocol to SQL using SQLite or PostgreSQL as the database engine.

Could be useful if wanting to migrate off MongoDB.

1

How SQLite helps you do ACID (fly.io)

submitted 1 year ago by samc to c/sqlite

0 comments fedilink

High level overview of how SQLite rollback journal works.

2

sqlpkg - The (unofficial) SQLite package registry. (sqlpkg.org)

submitted 1 year ago by samc to c/sqlite

0 comments fedilink

Registry of SQLite extensions along with a package manager to install them.

Inspiron 14 5140 Touchpad issues in c/[email protected]

[–] samc 1 points 1 year ago* (last edited 1 year ago)

I had a very similar issue, the touchpad in my Dell laptop would randomly stop working but I could still click. I couldn’t work out why until one of my keys stopped working. I replaced the keyboard and the touchpad issues disappeared. I suspect the cause was the faulty keyboard not sending the key up event as I had noticed pressing keys sometimes unfroze it. It could also have been a loose connection though.

If you’re using GNOME, you could try disabling the “disable touchpad on while typing” setting: gsettings set org.gnome.desktop.peripherals.touchpad disable-while-typing false

Verify the keyboard is not disabled when pressing keys and see if the issue still happens. If that fixes it then it might be keyboard that’s the problem.

To enable “disable touchpad while typing”: gsettings set org.gnome.desktop.peripherals.touchpad disable-while-typing true

Is Lemmy Indexable? in c/lemmyworld

[–] samc 40 points 1 year ago* (last edited 1 year ago) (7 children)

It is indexable but will take time. Google has started indexing Lemmy.world but doesn’t have that many pages yet.

Google Domains shutting down, assets sold and being migrated to Squarespace in c/[email protected]

[–] samc 1 points 1 year ago

That’s sucks, hopefully squarespace will be alright. I had considered moving to Google too but was wary of Google support, glad I didn’t now.

If you need an alternative, Cloudflare has a decent DNS editor and offers free email forwarding. Plus you don’t have to move your domains to them so easy to try out. I’m not a fan of how much of the internet depends on them but they are decent.

Why sqlite3 temp files were renamed 'etilqs_*' (2006) in c/sqlite

[–] samc 1 points 1 year ago

I remember a similar issue with some newsletter software I worked on. The free version added a powered by line to newsletters among other limitations.

Unfortunately, spammers started using it which inevitably led to people thinking we were spamming them and a lot of angry emails.

The software enforced unsubscribe links but the spammers modified it to remove that. Weirdly, they left the powered by link… maybe it helped pass spam filters? Or they just didn’t care.

There wasn’t much we could do to stop them so in the end the free version had to be discontinued.

Tool chest I'm working on in c/[email protected]

[–] samc 1 points 1 year ago (1 children)

Looks really good! I love your workshop, looks like a nice space to be in. The pillar drill in the background looks huge, do you metal work too?

Debian 12 released in c/[email protected]

[–] samc 3 points 1 year ago

Just updated mine. It's great how painless Debian make upgrades.