@openrisk@mastodon.social avatar openrisk , to random

The early Web had a quality that has been lost ever since: it was simple

Download , write some by hand and boom, the concept of a networked digital society is born.

It first started going pear shaped with . The complexity of a full blown database was not justified for most use cases. As proven decades later by the popularity of and approaches.

The final blow was when got into the act. Immense complexity for the simplest things became a moat

@h4ckernews@mastodon.social avatar h4ckernews Bot , to random

Turso is an in-process SQL database, compatible with SQLite

https://github.com/tursodatabase/turso

@h4ckernews@mastodon.social avatar h4ckernews Bot , to random
@h4ckernews@mastodon.social avatar h4ckernews Bot , to random
@h4ckernews@mastodon.social avatar h4ckernews Bot , to random
@h4ckernews@mastodon.social avatar h4ckernews Bot , to random
@h4ckernews@mastodon.social avatar h4ckernews Bot , to random
@h4ckernews@mastodon.social avatar h4ckernews Bot , to Testing
@h4ckernews@mastodon.social avatar h4ckernews Bot , to random
@h4ckernews@mastodon.social avatar h4ckernews Bot , to random
@h4ckernews@mastodon.social avatar h4ckernews Bot , to random
@ratfactor@mastodon.art avatar ratfactor , to random

A new seasonal look for my family instance of famsite. 🦃

The theme changes are pure CSS (and a touch of JS for the countdown). I made the turkey SVG in @inkscape this morning. It's just a handful of shapes with color gradients.

To run, famsite just needs PHP and SQLite on a webserver somewhere. I'm serving mine with OpenBSD's httpd on a VPS hosted by @OpenBSDAms . The schema has 3 tables. The whole thing fits on a floppy. 💾

https://ratfactor.com/repos/famsite/

ALT
@h4ckernews@mastodon.social avatar h4ckernews Bot , to random
@h4ckernews@mastodon.social avatar h4ckernews Bot , to random
@h4ckernews@mastodon.social avatar h4ckernews Bot , to random
@h4ckernews@mastodon.social avatar h4ckernews Bot , to random

Parrot – type-safe SQL in Gleam, supports SQlite, PostgreSQL and MySQL

https://github.com/daniellionel01/parrot

-safe

@scy@chaos.social avatar scy , to random

ok chat

what are some disadvantages of compared to ?

@h4ckernews@mastodon.social avatar h4ckernews Bot , to random
@h4ckernews@mastodon.social avatar h4ckernews Bot , to random
@markus@hachyderm.io avatar markus , to random

I love . It just works. It is extremely fast, because it’s just a local file access. It is very operationally and mentally simple, and it is extremely stable and well-tested. However, over my years of using it, there are just some things that I miss from the world of . So what happens if we just treat a local Postgres like SQLite? What does that mean? In this article, I’d like to expand on that idea.

https://www.maragu.dev/blog/what-if-we-treated-postgres-like-sqlite

@srzkptrsk@vkl.world avatar srzkptrsk , to random Belarusian

Chacieŭ dać Defold jašče adzin šaniec, bo planavaŭ pieranieści huĺni ŭ slovy z apki ŭ asobnuju huĺniu, alie ž.. u Defold niama svajoj impliemientacyi SQLite 🤷‍♂️

ALT
@h4ckernews@mastodon.social avatar h4ckernews Bot , to random
@h4ckernews@mastodon.social avatar h4ckernews Bot , to random
@h4ckernews@mastodon.social avatar h4ckernews Bot , to random
@h4ckernews@mastodon.social avatar h4ckernews Bot , to random