ProductPromotion
Logo

Python.py

made by https://0x3d.site

GitHub - planetopendata/awesome-sqlite: A collection of awesome sqlite tools, scripts, books, etc
A collection of awesome sqlite tools, scripts, books, etc - planetopendata/awesome-sqlite
Visit Site

GitHub - planetopendata/awesome-sqlite: A collection of awesome sqlite tools, scripts, books, etc

GitHub - planetopendata/awesome-sqlite: A collection of awesome sqlite tools, scripts, books, etc

Awesome Series @ Planet Open Data

World (Countries, Cities, Codes, ...)Football (Clubs, Players, Stadiums, ...)SQLite (Tools, Books, Schemas, ...)

SQLite

A collection of awesome (open source) sqlite tools, scripts, books, etc.

Contributions welcome. Anything missing? Send in a pull request. Thanks.

Note: For closed source / proprietary free or non-free sqlite tools & services, see the COMMERCIAL page »

SQLite Headquarters (HQ)

Small. Fast. Reliable. Choose any three.

Articles

SQLite Documentation / History

SQLite Books

SQLite Modules / Extensions

SQLite Derivates

  • sql.js (github: sql-js/sql.js) -- SQLite compiled to JavaScript (using asm.js) through Emscripten

Talks

Breaking News

SQLite Gets Offical "First-Class" WebAssembly & JavaScript Support

see sqlite.org/wasm»

Announced in October 2022 the about page reads:

About the sqlite3 WASM/JS Subproject WebAssembly, a.k.a. WASM, is a standard defining a low-level programming language suitable (A) as a target for cross-compilation from many other languages and (B) for running via a virtual machine in a browser. Designed with scriptability via JavaScript in mind, it provides a way to compile C code (among others) to WASM and script it via JavaScript with relatively little friction despite the vast differences between JavaScript and C.

Folks have been building sqlite3 for the web since as far back as 2012 but this subproject is the first effort "officially" associated with the SQLite project, created with the goal of making WASM builds of the library first-class members of the family of supported SQLite deliverables.

SQLite-based Distributed Database

  • rqlite (github: rqlite/rqlite) by Philip O'Toole et al -- The lightweight, distributed relational database built on SQLite

Middleware

Microsoft ODBC

Java JDBC

Language Bindings

R Language

Ruby

Microsoft .NET

  • System.Data.SQLite (web: system.data.sqlite.org) -- a SQLite ActiveX Data Objects (ADO).NET driver with Language-Integrated Query (LINQ) and Entity Framework support; official support by SQLite HQ

Visual Basic for Applications (VBA)

  • SQLite for Excel (codeplex: sqliteforexcel) -- SQLite wrapper for VBA

Swift

and many more

SQLite Admin Tools

Web

Desktop

Major

SpatiaLite

A spatial SQLite extension for vector geodata functionality

Text-to-SQLite

  • datapak (github: textkit/datapak, gem: datapak) -- Ruby tool and library for working with tabular data packages (.csv files w/ .json) using SQLite (via ActiveRecord)
  • q command line tool (github: harelba/q -- Python script; lets you run SQL directly on CSV files
  • csvs-to-sqlite (github: simonw/csvs-to-sqlite, pypi: csvs-to-sqlite) -- Python command-line tool for loading one or more CSV files and converting them into a SQLite database

PostgreSQL-to-SQLite

  • pg2sqlite (codeberg: louis77/pg2sqlite) -- Go command-line tool for automatically migrating tables from PostgreSQL to SQLite incl. generating DDL

Misc

Schema Documentation Generators

  • schemadoc (github: rubylibs/schemadoc, gem: schemadoc) -- documents your database schemas (tables, columns, etc.); uses SQLite (via ActiveRecord)
  • sqleton (github: inukshuk/sqleton) by Sylvester Keil -- ['skelɪtən]; visualizes your SQLite database schema (requires graphviz)

SQLite Schemas

Ready-to-Use (Instant) Database Schemas

  • football.db (github: openfootball/schema.sql) - teams, competitions, seasons, matches, goals, rounds, groups, etc.
  • beer.db (github: openbeer/schema.sql) - beer, brand, brewery, etc.
  • Chinook Database (codeplex: chinookdatabase), (chinook.sqlite Download) - online music store (artists, albums, genres, playlists, media tracks, customers, invoices, employees) with sample data; inspired by the "classic" Microsoft Northwind database
  • Northwind.db (github: jpwhite3/northwind-SQLite3, Swift pkg: NorthwindSQLite.swift) - food store (customers, products, orders, employees, suppliers, ...) with sample data; port of the "classic" Microsoft Northwind database

SQLite Web Service (JSON API) Publishers / Containers

Turn your Database into Ready-to-Use (Instant) Online Web Services (JSON APIs) w/ Query Language (QL)

  • Datasette (github: simonw/datasette) by Simon Willison - an instant JSON API for your SQLite databases
  • SQLPage (github: lovasoa/sqlpage) - build dynamic websites entirely in SQL on top of SQLite databases

Meta

License

The awesome list is dedicated to the public domain. Use it as you please with no restrictions whatsoever.

Questions? Comments?

Send them along to the sqlite-users mailing list. Thanks!

Articles
to learn more about the python concepts.

Resources
which are currently available to browse on.

mail [email protected] to add your project or resources here 🔥.

FAQ's
to know more about the topic.

mail [email protected] to add your project or resources here 🔥.

Queries
or most google FAQ's about Python.

mail [email protected] to add more queries here 🔍.

More Sites
to check out once you're finished browsing here.

0x3d
https://www.0x3d.site/
0x3d is designed for aggregating information.
NodeJS
https://nodejs.0x3d.site/
NodeJS Online Directory
Cross Platform
https://cross-platform.0x3d.site/
Cross Platform Online Directory
Open Source
https://open-source.0x3d.site/
Open Source Online Directory
Analytics
https://analytics.0x3d.site/
Analytics Online Directory
JavaScript
https://javascript.0x3d.site/
JavaScript Online Directory
GoLang
https://golang.0x3d.site/
GoLang Online Directory
Python
https://python.0x3d.site/
Python Online Directory
Swift
https://swift.0x3d.site/
Swift Online Directory
Rust
https://rust.0x3d.site/
Rust Online Directory
Scala
https://scala.0x3d.site/
Scala Online Directory
Ruby
https://ruby.0x3d.site/
Ruby Online Directory
Clojure
https://clojure.0x3d.site/
Clojure Online Directory
Elixir
https://elixir.0x3d.site/
Elixir Online Directory
Elm
https://elm.0x3d.site/
Elm Online Directory
Lua
https://lua.0x3d.site/
Lua Online Directory
C Programming
https://c-programming.0x3d.site/
C Programming Online Directory
C++ Programming
https://cpp-programming.0x3d.site/
C++ Programming Online Directory
R Programming
https://r-programming.0x3d.site/
R Programming Online Directory
Perl
https://perl.0x3d.site/
Perl Online Directory
Java
https://java.0x3d.site/
Java Online Directory
Kotlin
https://kotlin.0x3d.site/
Kotlin Online Directory
PHP
https://php.0x3d.site/
PHP Online Directory
React JS
https://react.0x3d.site/
React JS Online Directory
Angular
https://angular.0x3d.site/
Angular JS Online Directory