#Sqlite

Open-source projects categorized as Sqlite | Edit details

Top 23 Sqlite Open-Source Projects

  • GitHub repo Sequelize

    An easy-to-use multi SQL dialect ORM tool for Node.js

    Project mention: Any Laravel Eloquent like ORM for node.js? | reddit.com/r/node | 2021-05-08
  • GitHub repo TypeORM

    ORM for TypeScript and JavaScript (ES7, ES6, ES5). Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.

    Project mention: Any Laravel Eloquent like ORM for node.js? | reddit.com/r/node | 2021-05-08

    You could also checkout https://typeorm.io/

  • GitHub repo sqlitebrowser

    Official home of the DB Browser for SQLite (DB4S) project. Previously known as "SQLite Database Browser" and "Database Browser for SQLite". Website at:

    Project mention: Python error OperationalError: no such table: Player_Attributes | reddit.com/r/learnpython | 2021-05-06

    Python won't just lie to you. Open the database file with an external tool to make absolutely sure. I like this one.

  • GitHub repo Directus

    Open-Source Data Platform 🐰 — Directus wraps any SQL database with a real-time GraphQL+REST API and an intuitive app for non-technical users.

    Project mention: Why use Next.js + Strapi? | dev.to | 2021-05-06

    Directus is one of the CMS that presents, a proposal very similar to Strapi, but its stack is made in PHP, and has bug reports critical by users.

  • GitHub repo WCDB

    WCDB is a cross-platform database framework developed by WeChat.

    Project mention: Cross-Database Queries in SQLite | news.ycombinator.com | 2021-02-21

    SQLite is so ubiquitous you'd be hard pressed to find an app or service that doesn't use it.

    Look through the licenses for the software included as part of your phone's OS. You'll find SQLite in there.

    Search GitHub for sqlite, there are several projects with thousands of stars that use SQLite. Here's one: https://github.com/Tencent/wcdb

  • GitHub repo Craft

    A simple Minecraft clone written in C using modern OpenGL (shaders).

    Project mention: Resources to learn voxel based game development? | reddit.com/r/gamedev | 2021-03-08
  • GitHub repo sql.js

    A javascript library to run SQLite on the web.

    Project mention: SQLite Compiled to JavaScript | news.ycombinator.com | 2021-05-03
  • GitHub repo Peewee

    a small, expressive orm -- supports postgresql, mysql and sqlite

  • GitHub repo rqlite

    The lightweight, distributed relational database built on SQLite

    Project mention: Is it possible to distribute a Sqlite database across several servers? | reddit.com/r/sqlite | 2021-05-05
  • GitHub repo Android Debug Database

    A library for debugging android databases and shared preferences - Make Debugging Great Again

  • GitHub repo SQLite.swift

    A type-safe, Swift-language layer over SQLite3.

    Project mention: How do I create multiple tables in Swift using an SQLite Database? | reddit.com/r/swift | 2021-03-12

    My recommendation is to drop the UserDefaults funny business altogether. The library you're using (I'm assuming it's this one) provides ways for you to only conditionally create the table if it doesn't already exist.

  • GitHub repo diesel

    A safe, extensible ORM and Query Builder for Rust

    Project mention: diesel.exe - Application Error | reddit.com/r/rust | 2021-04-20

    I managed to install the diesel cli like they showed on the getting started page, but when I try to run the diesel commands from command promt I get an error box that pops up saying: "The application was unable to start correctly (0xc000007b). Click OK to close the application." Apparently there was a similar issue previously (https://github.com/diesel-rs/diesel/issues/2034) but they just said its probably some missing DLLs but how do I know what DLLs are missing? Any ideas on how to fix this issue?

  • GitHub repo migrate

    Database migrations. CLI and Golang library.

    Project mention: 🎉 The Create Go App project has grown to v2, but is still easier, better, faster & stronger | dev.to | 2021-05-06

    postgres — configured PostgreSQL container with apply migrations (by golang-migrate/migrate tool) for backend.

  • GitHub repo Bookshelf

    A simple Node.js ORM for PostgreSQL, MySQL and SQLite3 built on top of Knex.js

    Project mention: Autogenerate GraphQL API documentation with SpectaQL | dev.to | 2021-04-25

    A few of the most important characteristics of the solution we wanted was that any documentation-related work had to be easy for developers, and it would ideally be located in proximity to the actual implementing code. Anvil's web application is written in Node, and we chose Apollo as our GraphQL framework and use a modified version of Bookshelf as our ORM.

  • GitHub repo beekeeper-studio

    Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.

    Project mention: Show HN: DbGate – open-source, cross-platform SQL+noSQL database client | news.ycombinator.com | 2021-04-22

    Thanks for this. I've been using Beekeeper Studio (https://www.beekeeperstudio.io/) and I've been mostly happy with it, but glad to see alternatives. The only problem I have with Beekeeper is that scrolling the table view is really slow (laggy and jumpy), I assume it's because of Electron. Is DbGate any different there, you're using Electron too?

  • GitHub repo datasette

    An open source multi-tool for exploring and publishing data

    Project mention: Point me in the right direction (HTML front with sQLite back) | reddit.com/r/Database | 2021-05-07

    how about https://datasette.io/

  • GitHub repo go-sqlite3

    sqlite3 driver for go using database/sql

    Project mention: Building a full-text search engine in 150 lines of Python code | news.ycombinator.com | 2021-03-25

    I admit I only used sqlite through the go driver (https://github.com/mattn/go-sqlite3) where using fts5 amounts to one flag during the compile phase.

  • GitHub repo Adminer

    Database management in a single PHP file

    Project mention: CloudBeaver – Database Management from Browser | news.ycombinator.com | 2021-04-11

    I have still been using Adminer[0] via a docker image to quickly run an admin interface in a browser.

    This looks a lot nicer. I remember the DBeaver name but I've not used it in a long time. I'll be using this instead of Adminer on my next project to give it a whirl.

    [0] https://www.adminer.org

  • GitHub repo Bolt

    Bolt is a simple CMS written in PHP. It is based on Silex and Symfony components, uses Twig and either SQLite, MySQL or PostgreSQL. (by bolt)

  • GitHub repo sqlx

    🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, SQLite, and MSSQL. (by launchbadge)

    Project mention: Tiberius help | reddit.com/r/rust | 2021-04-14

    Sqlx does something that sounds like what you want, but its' MSSQL support isn't the greatest. https://github.com/launchbadge/sqlx#compile-time-verification

  • GitHub repo GRDB.swift

    A toolkit for SQLite databases, with a focus on application development

    Project mention: Ask HN: Is there a way to subscribe to an SQL query for changes? | news.ycombinator.com | 2021-04-22
  • GitHub repo visidata

    A terminal spreadsheet multitool for discovering and arranging data

    Project mention: `uq is a simple, user-friendly alternative to `sort | uniq`. | reddit.com/r/commandline | 2021-04-15

    Run vd (VisiData on the file, press Shift+F, instant unique lines sorted by number of uses. Like sort | uniq -c | sort -n in one go.

  • GitHub repo pgloader

    Migrate to PostgreSQL in a single command!

    Project mention: Migrating from an MSSQL Server RDS database to Postgres | reddit.com/r/aws | 2021-05-03

    I've used https://github.com/dimitri/pgloader to migrate our small prod DB from MySQL. THe worst part was to get it to compile, then it worked ok. I had to run it several times because it was running out of memory at first, but then with a bigger instance it ran ok.

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020). The latest post mention was on 2021-05-08.

Index

What are some of the best open-source Sqlite projects? This list will help you:

Project Stars
1 Sequelize 24,231
2 TypeORM 24,080
3 sqlitebrowser 14,781
4 Directus 10,747
5 WCDB 8,965
6 Craft 8,579
7 sql.js 8,532
8 Peewee 8,344
9 rqlite 8,202
10 Android Debug Database 7,776
11 SQLite.swift 7,545
12 diesel 6,765
13 migrate 6,349
14 Bookshelf 6,149
15 beekeeper-studio 5,811
16 datasette 5,068
17 go-sqlite3 4,795
18 Adminer 4,720
19 Bolt 4,105
20 sqlx 3,916
21 GRDB.swift 3,902
22 visidata 3,809
23 pgloader 3,378