Star History Weekly

Hi and welcome to Star History Weekly #4!

Hello to the 7 new stargazers who joined us.

If you are new, it's Mila here, and I am on the developer-marketing team at Bytebase. Each week, we curate some open-source news and take you with us to explore an open-source project, aka the Starlets. Meanwhile, we share fascinating GitHub repos daily over at @StarHistoryHQ, so make sure to follow us if you haven't already.

If you enjoy this newsletter, we ask you to subscribe and share!

In this Issue #4:

• 🗞️ Open-Source News of the Week

• 💫 Starlet #12: libSQL, SQLite for modern applications

Enjoy!

Open-Source News of the Week

• Formbricks, in-product micro-survey announces pre-seed funding 💸 https://formbricks.com/blog/preseed-announcement

• Nile, Serverless Postgres for modern SaaS: https://www.thenile.dev/blog/introducing-nile

• OpenSign, PDF E-Signature solution: https://www.opensignlabs.com/post/opensign-the-pioneering-open-source-docusign-alternative

• DoltgreSQL, version-controlled Postgres: https://www.dolthub.com/blog/2023-11-01-announcing-doltgresql/

Starlet #12: libSQL, SQLite for modern applications

libSQL is an Open Source and Open Contribution fork of SQLite. Unbeknownst to many, SQLite is developed without an OSS license (public domain), with a small set of developers that very rarely take external contributions. In their own words, the project is "Open Source, not Open Contribution".

libSQL

libSQL builds on the solid foundation of SQLite and adds things like:

• better support for schema changes

• native replication

• HTTP-based protocol for serverless environments

• A server implementation

• And automatic backups to object stores.

libSQL was created and is maintained by the team behind Turso, but it has a long tail of contributors and is growing in popularity rapidly:

Using libSQL

Using libSQL is easy. For example, in TypeScript:

Start by installing the SDK:

$ npm install @libsql/client

then import libSQL:

import { createClient } from "@libsql/client";

const client = createClient({

    url: "file:foo.db"

});

Alternatively, if are connecting to libsql-server:

const client = createClient({

    url: "http://server:port"

    authToken: "token"

});

And start issuing queries:

try {

    const rs = await client.execute("select * from example_users");

} catch (e) {

    console.error(e);

}

What's coming

We are looking into supporting libSQL in more languages, improving the server memory footprint and multitenant abilities, and more. Your contribution is welcome!