C Sqlite

Open-source C projects categorized as Sqlite

Top 23 C Sqlite Projects

  • WCDB

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

  • Craft

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

    Project mention: A simple Minecraft clone written in C using modern OpenGL | news.ycombinator.com | 2023-05-26
  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  • libsql

    libSQL is a fork of SQLite that is both Open Source, and Open Contributions.

    Project mention: 11 Planetscale alternatives with free tiers | dev.to | 2024-04-11

    Astro DB is powered by LibSQL, an open source fork of SQLite that was created by Turso. You can use Astro DB's drop-in database to build features like blogs, comment functionality, forums, feedback systems, and user authentication.

  • go-sqlite3

    sqlite3 driver for go using database/sql

    Project mention: Replacing Complicated Hashmaps with SQLite | news.ycombinator.com | 2024-04-06

    SQLite is great. I've also recently settled on it as a key-value store, after considering a few purpose-built key-value solutions. Turns out that it's really easy to make SQLite work as a key-value store, but very difficult to make key-value stores relational.

    Just be careful with `:memory:` databases. From the mattn/go-sqlite3 FAQ[1]:

    > Each connection to ":memory:" opens a brand new in-memory sql database, so if the stdlib's sql engine happens to open another connection and you've only specified ":memory:", that connection will see a brand new database. A workaround is to use "file::memory:?cache=shared" (or "file:foobar?mode=memory&cache=shared"). Every connection to this string will point to the same in-memory database.

    I noticed strange behaviors with just `:memory:` where tables would just disappear at random, and this workaround helped. Make sure to use a unique filename as the `file:` value, especially if using this in tests.

    [1]: https://github.com/mattn/go-sqlite3#faq

  • sqlitestudio

    A free, open source, multi-platform SQLite database manager.

    Project mention: C# program not able to open or connect to an encrypted SQLite Database | /r/sqlite | 2023-04-30

    DB4S provides only one algorithm based on official SQLite cipher. You can encrypt your database with another in SQLiteStudio or sqlite-gui (I'm an author). Both applications use SQLite3 Multiple Ciphers-library.

  • dqlite

    Embeddable, replicated and fault-tolerant SQL engine.

    Project mention: Marmot: Multi-writer distributed SQLite based on NATS | news.ycombinator.com | 2023-12-11

    If you're interested in this, here are some related projects that all take slightly different approaches:

    - LiteSync directly competes with Marmot and supports DDL sync, but is closed source commercial (similar to SQLite EE): https://litesync.io

    - dqlite is Canonical's distributed SQLite that depends on c-raft and kernel-level async I/O: https://dqlite.io

    - cr-sqlite is a Rust-based loadable extension that adds CRDT changeset generation and reconciliation to SQLite: https://github.com/vlcn-io/cr-sqlite

    Slightly related but not really (no multi writer, no C-level SQLite API or other restrictions):

    - comdb2 (Bloombergs multi-homed RDMS using SQLite as the frontend)

    - rqlite: RDMS with HTTP API and SQLite as the storage engine, used for replication and strong consistency (does not scale writes)

    - litestream/LiteFS: disaster recovery replication

    - liteserver: active read-only replication (predecessor of LiteSync)

  • sqlite-plus

    The ultimate set of SQLite extensions

    Project mention: Sqlime: Online SQLite Playground | news.ycombinator.com | 2024-04-09

    People should check out Nalgeon's work on SQLite extensions: https://github.com/nalgeon/sqlean.

  • WorkOS

    The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  • sqlite-gui

    Lightweight SQLite editor for Windows

    Project mention: C# program not able to open or connect to an encrypted SQLite Database | /r/sqlite | 2023-04-30

    DB4S provides only one algorithm based on official SQLite cipher. You can encrypt your database with another in SQLiteStudio or sqlite-gui (I'm an author). Both applications use SQLite3 Multiple Ciphers-library.

  • sist2

    Lightning-fast file system indexer and search tool

    Project mention: Better option then filebrowser to share files | /r/OpenMediaVault | 2023-06-11

    Quickly Googling for a docker indexer and search app I turned up Sist2, that on the surface looks like might fit your needs. I don't have an appropriate data store to run it against, so I can't speak to its indexing speed or efficacy. However, the developer does have an accessible demo to try, and the front end at least appears to function well.

  • stanchion

    A SQLite extension that brings column-oriented tables to SQLite

    Project mention: Show HN: Stanchion – Column-oriented tables in SQLite | news.ycombinator.com | 2024-01-31

    The "Data Storage Internals" section[1] of the README sounds to me like it has its own column-oriented format for these tables, at least that's how I'm reading the part about segments. Is that the case? If so, have you tried using Apache Arrow or Parquet to see how they compare?

    [1] https://github.com/dgllghr/stanchion#data-storage-internals

  • sqlite

    Go SQLite3 driver (by crawshaw)

  • verneuil

    Verneuil is a VFS extension for SQLite that asynchronously replicates databases to S3-compatible blob stores.

  • sqlite-lines

    A SQLite extension for reading large files line-by-line (NDJSON, logs, txt, etc.)

  • sqleet

    SQLite3 encryption that sucks less

  • esp32_arduino_sqlite3_lib

    Sqlite3 Arduino library for ESP32

    Project mention: so i just got hit with 160kb DRAM limit on esp | /r/esp32 | 2023-04-24

    Then your debugging is mostly around writing thing that generates that flat file and then also around whatever functions read and index the flat file. There is a pretty decent sqlite3 library for Arduino on ESP32 at least: https://github.com/siara-cc/esp32_arduino_sqlite3_lib (and actually another one for idf: https://github.com/siara-cc/esp32-idf-sqlite3 )

  • SQLite3MultipleCiphers

    SQLite3 encryption extension with support for multiple ciphers

    Project mention: C# program not able to open or connect to an encrypted SQLite Database | /r/sqlite | 2023-04-30

    DB4S provides only one algorithm based on official SQLite cipher. You can encrypt your database with another in SQLiteStudio or sqlite-gui (I'm an author). Both applications use SQLite3 Multiple Ciphers-library.

  • go-sqlite-lite

    SQLite driver for the Go programming language

  • zig-sqlite

    zig-sqlite is a small wrapper around sqlite's C API, making it easier to use with Zig.

    Project mention: SQLite with zig 0.11.0 | /r/Zig | 2023-05-28

    I'm trying to work with sqlite in zig. I found this project https://github.com/vrischmann/zig-sqlite but it seems that it is broken with zig 0.11.0 (something to do with stage2 I guess).

  • react-native-quick-sqlite

    A fast react-native SQLite library built using JSI (by margelo)

    Project mention: How to deal with single thread on mobile? | /r/reactnative | 2023-05-25

    If you are interested in thread-offloading and specifically writing a large volume of data to a db, take a look at https://github.com/margelo/react-native-quick-sqlite

  • extralite

    Ruby on SQLite

    Project mention: Extralite: SQLite Ruby gem with concurrency, extensions, backup features | news.ycombinator.com | 2024-02-11
  • sqlite_scanner

    DuckDB extension to read and write to SQLite databases

  • sqlite_micro_logger_arduino

    Fast and Lean Sqlite database logger for Arduino UNO and above

  • dbmail

    DBMail: fast and scalable email services

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

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

C Sqlite related posts

Index

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

Project Stars
1 WCDB 10,216
2 Craft 10,173
3 libsql 7,562
4 go-sqlite3 7,412
5 sqlitestudio 4,171
6 dqlite 3,703
7 sqlite-plus 3,332
8 sqlite-gui 1,043
9 sist2 737
10 stanchion 614
11 sqlite 526
12 verneuil 388
13 sqlite-lines 383
14 sqleet 371
15 esp32_arduino_sqlite3_lib 338
16 SQLite3MultipleCiphers 333
17 go-sqlite-lite 331
18 zig-sqlite 309
19 react-native-quick-sqlite 300
20 extralite 238
21 sqlite_scanner 184
22 sqlite_micro_logger_arduino 161
23 dbmail 138
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com