GitPlanet

Cheap and reliable Node.js hosting starts at $3/month, and $1/month static HTML hosting

Created with love in Canada, visit hostnodejs.com today

Feel like to post an Ad? Learn Details
All Projects → siara-cc → Esp32 Idf Sqlite3

siara-cc / Esp32 Idf Sqlite3

Licence: apache-2.0
Sqlite library for esp-idf (esp32) framework

Programming Languages

c
50402 projects - #5 most used programming language

Labels

sqliteesp32sqlite3

Projects that are alternatives of or similar to Esp32 Idf Sqlite3

Esp32 arduino sqlite3 lib
Sqlite3 Arduino library for ESP32
Stars: ✭ 167 (+192.98%)
Mutual labels:  sqlite, sqlite3, esp32
Wxsqlite3
wxSQLite3 - SQLite3 database wrapper for wxWidgets (including SQLite3 encryption extension)
Stars: ✭ 373 (+554.39%)
Mutual labels:  sqlite, sqlite3
Go Sqlite Lite
SQLite driver for the Go programming language
Stars: ✭ 315 (+452.63%)
Mutual labels:  sqlite, sqlite3
Denodb
MySQL, SQLite, MariaDB, PostgreSQL and MongoDB ORM for Deno
Stars: ✭ 498 (+773.68%)
Mutual labels:  sqlite, sqlite3
dotfiles
Configs for apps I care about
Stars: ✭ 19 (-66.67%)
Mutual labels:  sqlite, sqlite3
Entityframework.exceptions
Handle database errors easily when working with Entity Framework Core. Supports SQLServer, PostgreSQL, SQLite, Oracle and MySql
Stars: ✭ 266 (+366.67%)
Mutual labels:  sqlite, sqlite3
Aiosqlite
asyncio bridge to the standard sqlite3 module
Stars: ✭ 411 (+621.05%)
Mutual labels:  sqlite, sqlite3
mdb2sqlite
Conversion tool used to convert microsoft access database to sqlite.
Stars: ✭ 79 (+38.6%)
Mutual labels:  sqlite, sqlite3
Vscode Sqltools
Database management for VSCode
Stars: ✭ 741 (+1200%)
Mutual labels:  sqlite, sqlite3
Android dbinspector
Android library for viewing and sharing in app databases.
Stars: ✭ 881 (+1445.61%)
Mutual labels:  sqlite, sqlite3
Sqlite Global Tool
SQLite .NET Core CLI tool that allows the user to manually enter and execute SQL statements with or without showing query result.
Stars: ✭ 37 (-35.09%)
Mutual labels:  sqlite, sqlite3
sqlite-okapi-bm25
📑 SQLite extension to add the Okapi BM25 ranking algorithm
Stars: ✭ 30 (-47.37%)
Mutual labels:  sqlite, sqlite3
VVSequelize
数据库模型映射,自动建表, 自动更新表,数据增删改查, FTS全文搜索, 支持自定义fts3,4,5分词器,可拼音分词. sql,fmdb,wcdb,sqlite3,orm,fts,fts3,fts4,fts5
Stars: ✭ 16 (-71.93%)
Mutual labels:  sqlite, sqlite3
Squeal
A Swift wrapper for SQLite databases
Stars: ✭ 303 (+431.58%)
Mutual labels:  sqlite, sqlite3
csv-to-sqlite
A desktop app to convert CSV files to SQLite databases!
Stars: ✭ 68 (+19.3%)
Mutual labels:  sqlite, sqlite3
Walkable
A Clojure(script) SQL library for building APIs: Datomic® (GraphQL-ish) pull syntax, data driven configuration, dynamic filtering with relations in mind
Stars: ✭ 384 (+573.68%)
Mutual labels:  sqlite, sqlite3
Perfect Sqlite
A stand-alone Swift wrapper around the SQLite 3 client library.
Stars: ✭ 42 (-26.32%)
Mutual labels:  sqlite, sqlite3
sqlite zstd vfs
SQLite3 extension for read/write storage compression with Zstandard
Stars: ✭ 42 (-26.32%)
Mutual labels:  sqlite, sqlite3
lighthouse
Easy clojure relational database queries, migrations and connection pooling
Stars: ✭ 19 (-66.67%)
Mutual labels:  sqlite, sqlite3
Tuql
Automatically create a GraphQL server from a SQLite database or a SQL file
Stars: ✭ 526 (+822.81%)
Mutual labels:  sqlite, sqlite3
View All Similar Projects ➔

SQLite3 library

Overview

Create / access SQLite3 database files using this library through SPIFFS / SD Cards.

For more information, please see https://github.com/siara-cc/esp32_arduino_sqlite3_lib

Installation

Install ESP-IDF sdk using instructions from https://docs.espressif.com/projects/esp-idf/en/latest/get-started/.

Unzip this project under esp-idf/components folder. Or if you are cloning the repository at https://github.com/espressif/esp-idf, add this repository as submodule using:

git submodule add https://github.com/siara-cc/esp32-idf-sqlite3 components/esp32-idf-sqlite3.

Using examples

  1. Download esp-idf-v4.1.1.zip that includes submodules and unzip
  2. cd esp-idf-v4.1.1, install using sudo ./install.sh
  3. git submodule add https://github.com/siara-cc/esp32-idf-sqlite3 components/esp32-idf-sqlite3
  4. git submodule add https://github.com/siara-cc/esp32-idf-sqlite3-examples examples/esp32-idf-sqlite3-examples
  5. cd examples/esp32-idf-sqlite3-examples/spiffs
  6. make flash
  7. To check output, use miniterm.py <device> 115200 and reset board

Information specific to ESP-IDF

To check out how this library works, please try the examples using:

git submodule add https://github.com/siara-cc/esp32-idf-sqlite3-examples examples/esp32-idf-sqlite3-examples

For instance, to check how Sqlite3 databases can be created on SPIFFS, navigate to the folder examples/esp32-idf-sqlite3-examples/spiffs and invoke make flash.

Many configurations specific to SQLite library have been set in the sdkconfig.defaults file, such as:

  • Increasing stack size
  • Setting SPIFFS partition information
  • Partition size

The Flash size has been assumed as 4MB for SPIFFS example. Please change any of these configurations if necessary.

Issues

If you face any issues, please contact the author (Arundale Ramanathan) at [email protected] or create a github issue.

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].