Best of SQLite2022

  1. 1
    Article
    Avatar of logrocketLogRocket·3y

    Build a real-time chat app with Rust and React

    Rust is known for its speed and reliability, while React is one of the most popular frontend frameworks for building user interfaces. In this article, we’ll demonstrate how to build a real-time chat app with Rust and React that offers functionality for chat, checking user status, and indicating when a user is typing.

  2. 2
    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.

  3. 3
    Article
    Avatar of devtoDEV·4y

    Database GUIs in JavaScript

    Traditional tools are often written in Java, C++ or Delphi and they use good old JDBC, ODBC or ADO.NET drivers for accessing database. Almost all tools are open-source. If you know about other tool not listed in this article, you could write about it in comments below. For SQLlite I actually use Firefox.

  4. 4
    Article
    Avatar of glcGolang News·4y

    A Golang-based Open Source Backend / Firebase Alternative

    A Golang-based Open Source Backend / Firebase Alternative PocketBase is an open source backend consisting of embedded database (SQLite) with realtime subscriptions, built-in users management, convenient dashboard UI and simple REST-ish API.

  5. 5
    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.

  6. 6
    Article
    Avatar of logrocketLogRocket·4y

    Comparing the 7 best ORM packages in Go

    The GORM (Go-ORM) package is the most popular ORM package in the Go ecosystem. The SQLC package provides database queries, transactions, configurations, and functionalities. The Beego ORM is a powerful ORM inspired by popular Python ORMs, like the Django ORM and SQLAlchemy.

  7. 7
    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.

  8. 8
    Article
    Avatar of kentcdoddsKent C. Dodds·3y

    2022 in Review

    The accident 2022 started off with a bang... literally. I've written about this at length in the My Car Accident post. I left Remix to start working full-time on something I've been planning for years. I'm currently building the application that will be the subject of most of the workshops, tutorials, and articles.

  9. 9
    Article
    Avatar of flydotioFly.io·4y

    Introducing LiteFS

    LiteFS works by interposing a very thin virtual file system between your app and your on-disk database file. The FUSE file system solves many of these usability issues by being a single point that all database calls go through. LiteFS also needs to run an API server to replicate data between nodes. It uses Hashicorp's Consul to determine the primary node in your cluster.

  10. 10
    Article
    Avatar of pointerPointer·4y

    rqlite/rqlite: The lightweight, distributed relational database built on SQLite

    Rqlite is an easy-to-use, lightweight, distributed relational database, which uses SQLite as its storage engine. It uses Raft to achieve consensus across all the instances of the SQLite databases, ensuring that every change made to the system is made to $ rqlite 127.0.1:4001.

  11. 11
    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.

  12. 12
    Article
    Avatar of pointerPointer·4y

    ddworken/hishtory: Your shell history: synced, queryable, and in context

    Hishtory: Better Shell History hishtory is a better shell history. It stores your shell history in context (what directory you ran the command in, whether it succeeded or failed, how long it took, etc.

  13. 13
    Article
    Avatar of infoworldInfoWorld·4y

    Intro to Blitz.js: A full-stack framework for Next.js

    Next.js is an up-and-coming JavaScript framework built on React and Next.js. Blitz’s generator provides more elaborate full-stack scaffolding. The most unusual thing about Blitz is its use of remote procedure calls, or RPC. Instead of using a REST or GraphQL API, you import your server-side code directly into your client-side JavaScript. Blitz then transforms the server-level code.

  14. 14
    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.

  15. 15
    Article
    Avatar of logrocketLogRocket·4y

    Using TypeORM’s QueryBuilder in NestJS

    NestJS is a relatively new JavaScript web framework that enables you to build enterprise-grade, server-side applications. It also uses TypeORM, a strong object-relations-management library built with TypeScript. With over 29.3k stars on GitHub, typeORM is one of the most popular Node.