SpatiaLite: SpatiaLite
SpatiaLite is an open source library intended to extend the SQLite core to support fully fledged Spatial SQL capabilities. SQLite is intrinsically simple and lightweight: a single lightweight library implementing the full SQL engine standard SQL implementation: almost complete SQL-92 no complex client/server architecture a whole database simply corresponds to a single monolithic file (no size limi
GitHub - simonw/datasette: An open source multi-tool for exploring and publishing data
An open source multi-tool for exploring and publishing data Datasette is a tool for exploring and publishing data. It helps people take data of any shape or size and publish that as an interactive, explorable website and accompanying API. Datasette is aimed at data journalists, museum curators, archivists, local governments, scientists, researchers and anyone else who has data that they wish to sh
Dogsheep
Skip to the content. Dogsheep Dogsheep is a collection of tools for personal analytics using SQLite and Datasette. Big internet companies know a lot about us. By exporting that data back out of them we can see what they know and maybe learn something interesting about ourselves. Read more about Dogsheep on my blog: simonwillison.net/tags/dogsheep Watch Personal Data Warehouses: Reclaiming Your Dat
Hosting SQLite databases on Github Pages - (or IPFS or any static file hoster) - phiresky's blog
Hosting SQLite databases on Github Pages(or IPFS or any static file hoster) Apr 17, 2021 • Last Update Jun 04, 2023I was writing a tiny website to display statistics of how much sponsored content a Youtube creator has over time when I noticed that I often write a small tool as a website that queries some data from a database and then displays it in a graph, a table, or similar. But if you want to
Canonical Dqlite | Canonical Dqlite
High-availability SQLite Dqlite is a fast, embedded, persistent SQL database with Raft consensus that is perfect for fault-tolerant IoT and Edge devices. Dqlite (distributed SQLite) extends SQLite across a cluster of machines, with automatic failover and high-availability to keep your application running. It uses C-Raft, an optimised Raft implementation in C, to gain high-performance transactional
Write-Ahead Logging
1. Overview The default method by which SQLite implements atomic commit and rollback is a rollback journal. Beginning with version 3.7.0 (2010-07-21), a new "Write-Ahead Log" option (hereafter referred to as "WAL") is available. There are advantages and disadvantages to using WAL instead of a rollback journal. Advantages include: WAL is significantly faster in most scenarios. WAL provides more con
Launching LiteCLI
Today we are happy to announce the launch of LiteCLI! LiteCLI is a user-friendly CommandLine client for SQLite database. It is based on the popular pgcli and mycli projects. LiteCLI is written in python using the wonderful prompt-toolkit library. It is cross-platform compatible and it is tested on Linux, MacOS and Windows. It is developed by a team of core devs from around the world. We are friend
Work on SQLite4 has concluded | Hacker News
The relevant change:> This directory contains source code to an experimental "version 4" of SQLite that was being developed between 2012 and 2014. > All development work on SQLite4 has ended. The experiment has concluded. > Lessons learned from SQLite4 have been folded into SQLite3 which continues to be actively maintained and developed. This repository exists as an historical record. There are no
SQL Notebook
Open source app for casual data exploration in SQL Import your data from CSV, Excel, Microsoft SQL Server, PostgreSQL, and MySQL. Then use a Jupyter-style notebook interface for exploratory queries, and write stored procedures for reusable logic. SQL Notebook is powered by an extended SQLite engine, supporting both standard SQL queries and SQL Notebook-specific commands and functions. Download SQL
リリース、障害情報などのサービスのお知らせ
最新の人気エントリーの配信
j次のブックマーク
k前のブックマーク
lあとで読む
eコメント一覧を開く
oページを開く
GitHub - egerber/spaCy-entity-linker: spaCy module for linking text to Wikidata items
GitHub - dpapathanasiou/simple-graph: This is a simple graph database in SQLite, inspired by "SQLite as a document database"
Asami: Turn your JSON into a Graph in 2 Lines - Strange Loop
Using SQLITE for local Django development for Google App Engine?
sql.js
SQLite on Google Cloud Persistent Disk
Sharing SQLite databases across containers is surprisingly brilliant
SQLite3のJSON機能が便利だった - Qiita
GitHub - sqlitebrowser/sqlitebrowser: Official home of the DB Browser for SQLite (DB4S) project. Previously known as "SQLite Database Browser" and "Database Browser for SQLite". Website at:
p513-park.pdf
Sang-Won Lee