Bookmarks
Tag cloud
Picture wall
Daily
RSS Feed
  • RSS Feed
  • Daily Feed
  • Weekly Feed
  • Monthly Feed
Filters

Links per page

  • 20 links
  • 50 links
  • 100 links

Filters

Untagged links
20 results tagged sqlite  ✕   ✕
fasiha/yamanote https://github.com/fasiha/yamanote
Sat 19 Nov 2022 02:51:11 PM PST archive.org

Yamanote is a bookmarklet-based bookmarking web app. It’s a web application so you need to run it on a computer, or get a friend to run it for you. When you decide you want to bookmark a page on the web, you click on a Yamanote bookmarklet in your browser’s bookmarks bar (works great on desktop, and in Safari on iOS) to tell the Yamanote server about it. Any text you’ve selected will be added as a “comment” to the bookmark by Yamanote. This is fun because as you read, you can select interesting snippets and keep clicking the bookmarklet to build a personalized list of excerpts. You can add additional commentary to the bookmark in Yamanote, either by editing one of the excerpts made from the bookmarklet or an entirely new comment with its own timestamp. Also, the first time you bookmark a URL, your browser will snapshot the entire webpage and send it to the Yamanote server as an archive (in technical terms, it’ll serialize the DOM). This is great for (1) paywalled content you had to log in to read, (2) Twitter, which makes it hard for things like Pinboard to archive, etc. The server will download any images—and optionally videos—in your bookmarked sites. You can browse Yamanote’s snapshot of the URL (it might look weird because we block custom JavaScript in the mirror and lots of sites these days look weird with just HTML and CSS—shocking I know). Nobody except you can see your bookmarks, comments, or archives.

nodejs sqlite archival webapps exocortex annotation
Florents-Tselai/WarcDB https://github.com/Florents-Tselai/WarcDB
Tue 21 Jun 2022 03:55:58 PM PDT archive.org

WarcDB is a an SQLite-based file format that makes web crawl data easier to share and query. It is based on the standardized Web ARChive format, used by web archivers.

python cli archive sqlite web
hihouhou/huginn_sqlite_agent https://github.com/hihouhou/huginn_sqlite_agent
Mon 25 Apr 2022 05:13:06 PM PDT archive.org

A Huginn agent for querying SQLite databases. Whatever it finds are emitted as events.

huginn agent ruby exocortex sqlite databases
stevenleeg/huginn_sqlite3_agent https://github.com/stevenleeg/huginn_sqlite3_agent
Thu 25 Nov 2021 02:54:29 PM PST archive.org

This gem provides two agents for Huginn that can read from and write to SQLite 3 databases.

For detailed instructions on their usage, please see the Markdown descriptions within the agents' source (which will also be displayed in your Huginn dashboard).

Note that this gem relies on the sqlite3 gem which itself requires SQLite3 development headers. If you're running Huginn on a regular server, satisfying this requirement may be simple.

exocortex huginn ruby agent databases sqlite
Wave documentation: WaveDB https://github.com/h2oai/wave/blob/master/website/docs/wavedb.md
Tue 14 Sep 2021 01:56:17 PM PDT archive.org

WaveDB is SQLite with a HTTP interface.

It is a ~6MB (~2MB UPX-compressed) self-contained, zero-dependency executable that bundles SQLite 3.35.5 (2021-04-19) with JSON1, RTREE, FTS5, GEOPOLY, STAT4, and SOUNDEX.

If you are already a fan of SQLite, WaveDB acts as a thin HTTP-server wrapper that lets you access your SQLite databases over a network.

WaveDB can be used as a lightweight, cross-platform, installation-free companion SQL database for Wave apps. The h2o-wave package includes non-blocking async functions to access WaveDB.

Database files managed by WaveDB are 100% interoperable with SQLite, which means you can manage them with the sqlite3 CLI, backup/restore/transfer them as usual, or use Litestream for replication.

databases sqlite server http rest api dashboard exocortex
static.wiki http://static.wiki/
Sat 31 Jul 2021 04:00:11 PM PDT archive.org

A proof-of-concept inspired and enabled by Hosting SQLite Databases on Github Pages and the ensuing Hacker News post. The compiled single-page app supports autocomplete for titles, automatic redirecting & other MediaWiki datasets like WikiQuote or Chinese Wikipedia. It makes no external API calls except to get Wikipedia's images.

Seems ideal for making offline copies of Wikipedia (or other Mediawiki installs, it's implied) available.

Search is disabled right now.

Github: https://github.com/segfall/static-wiki

SQLite copies of Wikipedia: https://www.kaggle.com/segfall/markdownlike-wikipedia-dumps-in-sqlite

Has instructions for turning an XML dump of Wikipedia into a SQLite database; unfortunately it uses node.js.

wiki wikipedia offline webapps database static mediawiki sqlite
Dogsheep | dogsheep.github.io https://dogsheep.github.io/
Thu 24 Sep 2020 09:46:39 PM PDT archive.org

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.

data analytics personal exocortex sqlite python resear
GitHub - thp/minidb: A simple SQLite3 store for Python objects https://github.com/thp/minidb
Tue 07 Jul 2020 07:50:39 PM PDT archive.org

minidb 2 makes it easy to store Python objects in a SQLite 3 database and work with the data in an easy way with concise syntax. Designed for embedded use (imported as a module) and not a stand-alone server. Supports SQL queries.

python module sqlite objects sql
argovaerts/hookless.co https://github.com/argovaerts/hookless.co
Sun 31 May 2020 04:02:35 PM PDT archive.org

A self-hosted service that pings webhooks or other URLs on a user-defined schedule. Works a little bit like cron. Can even do things every X minutes or hours, like cron.

Written in PHP, uses SQLite.

If you don't want to set it up yourself: https://hookless.co/

rest api php timer scheduling jobs selfhosted sqlite exocortex webhooks urls
thombashi/sqlitebiter https://github.com/thombashi/sqlitebiter
Wed 10 Jul 2019 02:15:45 PM PDT archive.org

A CLI tool to convert CSV / Excel / HTML / JSON / Jupyter Notebook / LDJSON / LTSV / Markdown / SQLite / SSV / TSV / Google-Sheets to a SQLite database file. Can also pull data from supplied URLs.

python cli sqlite json csv converter data
Internet Archive: Yahoo's geoplanet database https://archive.org/details/geoplanet_data_7.10.0.zip
Thu 27 Jun 2019 11:04:14 AM PDT archive.org

Since Yahoo killed off their Where-On-Earth (WOEID) API service, it hasn't been possible to use it to get WOEID maprefs for certain APIs. Thankfully, some kind soul uploaded it to the Internet Archive.

The contents are five TSV (tab separated value) files, a Readme.txt file, and a license.txt file.

If you want to read them into a SQLite database (and you'll need to set a primary key on each table), do this:

user@host: sqlite3 geoplanet.sqlite
sqlite> .mode tabs
sqlite> PRAGMA foreign_keys=off;

sqlite> CREATE TABLE adjacencies (id INTEGER PRIMARY KEY, Place_WOE_ID TEXT, Place_ISO TEXT, Neighbour_WOE_ID TEXT, Neighbour_ISO TEXT);
sqlite> .import geoplanet_adjacencies_7.10.0.tsv temp_adjacencies
sqlite> INSERT INTO adjacencies(Place_WOE_ID, Place_ISO, Neighbour_WOE_ID, Neighbour_ISO) SELECT Place_WOE_ID, Place_ISO, Neighbour_WOE_ID, Neighbour_ISO from temp_adjacencies;
sqlite> drop table temp_adjacencies;

sqlite> CREATE TABLE admins (id INTEGER PRIMARY KEY, WOE_ID TEXT, iso TEXT, State TEXT, County TEXT, Local_Admin TEXT, Country TEXT, Continent TEXT);
sqlite> .import geoplanet_admins_7.10.0.tsv temp_admins
sqlite> INSERT INTO admins(WOE_ID, iso, State, County, Local_Admin, Country, Continent) SELECT WOE_ID, iso, State, County, Local_Admin, Country, Continent from temp_admins;
sqlite> drop table temp_admins;

sqlite> CREATE TABLE aliases (id INTEGER PRIMARY KEY, WOE_ID TEXT, Name TEXT, Name_Type TEXT, Language Text);
sqlite> .import geoplanet_aliases_7.10.0.tsv temp_aliases
sqlite> INSERT INTO aliases(WOE_ID, Name, Name_Type, Language) SELECT WOE_ID, Name, Name_Type, Language from temp_aliases;
sqlite> DROP TABLE temp_aliases;

sqlite> CREATE TABLE changes (id INTEGER PRIMARY KEY, Woe_id TEXT, Rep_id TEXT, Data_Version TEXT);
sqlite> .import geoplanet_changes_7.10.0.tsv temp_changes
sqlite> INSERT INTO changes (Woe_id, Rep_id, Data_Version) SELECT Woe_id, Rep_id, Data_Version from temp_changes;
sqlite> DROP TABLE temp_changes;

sqlite> CREATE TABLE places (id INTEGER PRIMARY KEY, WOE_ID TEXT, ISO TEXT, Name TEXT, Language TEXT, PlaceType TEXT, Parent_ID TEXT);
sqlite> .import geoplanet_places_7.10.0.tsv temp_places
sqlite> INSERT INTO places (WOE_ID, ISO, Name, Language, PlaceType, Parent_ID) SELECT WOE_ID, ISO, Name, Language, PlaceType, Parent_ID from temp_places;
sqlite> drop table temp_places;

sqlite> PRAGMA foreign_keys=on;
sqlite> .quit

I would also recommend cleaning up after yourself:
user@host: sqlite3 geoplanet.sqlite
sqlite> VACUUM;
sqlite> .quit

The Geoplanet database is licensed by Yahoo! Geoplanet as Creative Commons By Attribution v3.0:
http://creativecommons.org/licenses/by/3.0/us/

geoplanet woeid howto database mapping gridref creativecommons data sql sqlite
Populating SQLite database table with JSON data using Python https://devopsheaven.com/sqlite/databases/json/python/api/2017/10/11/sqlite-json-data-python.html
Fri 07 Sep 2018 02:20:40 PM PDT archive.org

How to load JSON into a SQLite database all in one go using Python.

SQLite has a JSON datatype, so it's possible to load JSON objects into columns. There still needs to be a unique key for each entry, though.

howto sqlite python json databases data
simonw/csvs-to-sqlite: Convert CSV files into a SQLite database https://github.com/simonw/csvs-to-sqlite
Thu 06 Sep 2018 03:16:36 PM PDT archive.org

Convert CSV files into a SQLite database. Designed for use with Datasette. Requires Python 3.

python python csv converter sqlite data database
simonw/datasette: A tool for exploring and publishing data https://github.com/simonw/datasette
Thu 06 Sep 2018 01:21:53 PM PDT archive.org

Datasette provides an instant, read-only JSON API for any SQLite database, even those applications on your system maintain. It also provides tools for packaging the database up as a Docker container and deploying that container to hosting providers such as Zeit Now. Got CSV data? Use csvs-to-sqlite to convert them to SQLite. Runs its own webserver on localhost:8001 so you don't need to write code to use it, just point it at a .sqlite3 file.

Requires Python 3.

python module json api sqlite data csv exocortex analysis python
SQLite Database Browser https://sqlitebrowser.org/
Tue 20 Mar 2018 02:20:54 AM PDT archive.org

A free, open source application that makes manipulating SQLite databases easier. Designed with both people who aren't skilled with databases and administrators in mind.

sqlite foss sysadmin gui management application tools free sql crossplatform databases
Adminer http://www.adminer.org/
Tue 20 Mar 2018 01:06:46 AM PDT archive.org

A single-file database administration utility written in PHP. Supports MySQL, PostgreSQL, SQLite, MS SQL, and Oracle database servers. Formerly phpMyAdmin. Seems to let you do everything you could do from a database shell. Session-aware. Has plugins for a number of popular web apps to help you fix their databases should you need to. Easily themeable, just drop a new CSS file into the directory Adminer is installed in.

sqlite postgresql database administration mysql oracle webapps php mssql management lightweight web
/rqlite/rqlite https://github.com/rqlite/rqlite
Tue 20 Mar 2018 12:11:37 AM PDT archive.org

A distributed relational database that uses SQLite as its back end. Eventual consensus of all nodes that relies upon quorum. Automatically elects leaders in the network of servers. More lightweight than MySQL or Postgres. Has a REST API built in. Fully transactional. Hot backups possible. Uses SQLite in "all in memory" mode by default for efficiency, but can maintain on-disk database files with a command line option (the on-disk transaction log can be used to repopulate the in-memory database on startup). Written in Go.

sqlite database distributed rest cluster api golang relational
Natural Earth http://www.naturalearthdata.com/
Mon 19 Mar 2018 11:59:21 PM PDT archive.org

A map dataset in the public domain. Multiple scales of resolution available (1:10m, 1:50m, 1:110 million). Vector and raster images. Incorporates GIS attributes for mapmaking. Designed to make it easy to develop maps on your own. Comes as ArcMap MXD and QGIS documents. You can also download entire databases (even SQLite) all in one go.

map sqlite cartography gis navigation free dataset exocortex download geo
/microsounds/akari-bbs https://github.com/microsounds/akari-bbs
Mon 19 Mar 2018 10:56:07 PM PDT archive.org

A server-based chan like BBS written in C. No registration, just post. Supports tripcodes. futaba style. Aggressive content turnover. Requires lighttpd (probably) as its front-end, sqlite backend.

chan sqlite futaba bbs
Wakaba and Kareha http://wakaba.c3.cx/s/web/wakaba_kareha
Mon 19 Mar 2018 10:26:06 PM PDT archive.org

Kareha doesn't use a database, Wakaba does.

web sqlite forum chan perl mysql imageboard software
4817 links, including 361 private
Shaarli - The personal, minimalist, super-fast, database free, bookmarking service by the Shaarli community - Theme by kalvn