Best of SQLite — October 2022

  1. 1
    Article
    Avatar of pointerPointer·4y

    mikeroyal/Self-Hosting-Guide: Self-Hosting Guide. Learn all about locally hosting(on premises & private web servers) and managing software applications by yourself or your organization.

    Most self-hosted software can be installed using Docker, a packaging system which allows software to bundle their configuration and dependencies. Shipwright is a WebUI to generate templates for Yacht, Portainer, Docker-Compose, and Unraid. Dozzle is a small lightweight application with a web based interface to monitor Docker logs. Diun is a tool that receive notifications when a Docker image is updated.

  2. 2
    Article
    Avatar of supabaseSupabase·4y

    Postgres Full Text Search vs the rest

    Postgres has built-in Full Text Search which we can use instead of cobbling together our own with like. Postgres can do some basic searching using select and comparison tools like like. The LIKE operator as used in the query above will match only the term "Avengers%". For our experiments we'll use SQLite FTS5 and TypeSense TypeSense.

  3. 3
    Article
    Avatar of communityCommunity Picks·4y

    Building a NestJS REST API using Prisma ORM

    Prisma is a next-generation Object Relational Mapper (ORM) It takes a somewhat different approach to traditional ORMs. Instead of classes, Prisma uses a special Schema Definition Language. Prisma runs over the schemas and writes the appropriate migrations depending on the chosen database. For our demo NestJS Prisma application, we will be using SQLite as our database.

  4. 4
    Article
    Avatar of thisdotThis Dot·4y

    A Look At Bun.sh: the Modern JavaScript Runtime

    Bun is an all-in-one tool (runtime, bundler, package manager, transpiler) Bun is developed from scratch using the zig programming language. It uses JavaScriptCore Engine (Same with Safari browser), which is what is your opinion on bun or some exciting projects you might build or migrate with bun.

  5. 5
    Article
    Avatar of logrocketLogRocket·4y

    How to configure indexes in Prisma

    Prisma defaults to this syntax: tablename. The fieldsargument is the only required argument on this list. The nameargument allows you to set a name for an index being defined map. This argument is essential for these types, especially for cases where the full value would exceed MySQL’s limits for index sizes sort.

See all SQLite archives