Skip to content

Latest commit

 

History

History
65 lines (43 loc) · 3.79 KB

File metadata and controls

65 lines (43 loc) · 3.79 KB

SQLite Editors

SQLite Visual Design

gratis - Free program to generate ER diagram for exisiting SQLite Database - Software Recommendations Stack Exchange

Spatialite

Part 1: Getting Started with SpatiaLite: An almost Idiot's Guide (bostongis.com)

SQLite Wrappers

Branch Out Your SQLite Database With LiteTree | Hackaday

Python with SQLite

Recipes from Python SQLite docs · Redowan's Reflections (rednafi.github.io) sqlite3 — DB-API 2.0 interface for SQLite databases — Python 3.9.14 documentation A thorough guide to SQLite database operations in Python (sebastianraschka.com) python_reference/tutorials/sqlite3_howto at master · rasbt/python_reference (github.com) SQLite Python - SQLite programming in Python (zetcode.com)

cursor_obj.execute(statement)  # individual statements
cursor_obj.executemany(template_statement, (data, ...))  # batch statememnts
connection_obj.create_function(func_name, narg, func)  # UDF scalar functions
connection_obj.create_aggregate(func_name, narg, aggregate_class)  # UDF aggregate functions

Javascript with SQLite

html - Is it possible to access an SQLite database from JavaScript? - Stack Overflow

C/C++ with SQLite

SRombauts/SQLiteCpp: SQLiteC++ (SQLiteCpp) is a smart and easy to use C++ SQLite3 wrapper. (github.com) SqliteModernCpp/sqlite_modern_cpp: The C++14 wrapper around sqlite library (github.com)

R-language with SQLite

Databases and R | Statistical Modeling, Causal Inference, and Social Science (columbia.edu) RSQLite CRAN - Package RSQLite (r-project.org) RSQLite: SQLite Interface for R (r-project.org) SQLdf CRAN - Package sqldf (r-project.org) sqldf: Manipulate R Data Frames Using SQL (r-project.org) ggrothendieck/sqldf: Perform SQL Selects on R Data Frames (github.com)

Matlab with SQLite

mksqlite: Introduction (sourceforge.net) a-ma72/mksqlite: A MATLAB Mex-DLL to access SQLite databases (github.com)