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
16 results tagged sql  ✕   ✕
RestfulDB https://projects.ibt.lt/repositories/projects/restfuldb
Sat 11 Mar 2023 05:14:25 PM PST archive.org

RestfulDB is a Web frontend for SQL databases. It provides both a Web GUI and a RESTful API for interaction with any MySQL/MariaDB or SQLite database. RestfulDB is developed with off-the-shelf usage in mind, but nevertheless it provides the means to override the default interpretations of underlying database's schema and data.

sql databases rest api webapps perl cgibin
mrzhangboss/json2db https://github.com/mrzhangboss/json2db
Fri 09 Sep 2022 04:15:28 PM PDT archive.org

Define a JSON document in Python, transparently convert it into a relational database. Supports MySQL/MariaDB, Postgres, SQLserver, and SQLite. Ideal for writing conversion tools.

python database json conversion sql
GitHub - dolthub/dolt: Dolt – It's Git for Data https://github.com/dolthub/dolt
Mon 22 Nov 2021 11:28:12 PM PST archive.org

Dolt is a SQL database that you can fork, clone, branch, merge, push and pull just like a git repository. Connect to Dolt just like any MySQL database to run queries or update the data using SQL commands. Use the command line interface to import CSV files, commit your changes, push them to a remote, or merge your teammate's changes.

All the commands you know for Git work exactly the same for Dolt. Git versions files, Dolt versions tables. It's like Git and MySQL had a baby.

Dolt ships with a MySQL compatible database server built in.

sql database exocortex golang versioncontrol git mysql
harelba/q https://github.com/harelba/q
Sun 22 Aug 2021 08:29:51 PM PDT archive.org

A CLI tool that lets you run SQL queries against CSV and TSV (tab-separated values) files. This includes data from shell pipes, like the output of ps or other tools.

python cli sql csv tsv queries
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
FormatExpress https://format-express.dev/
Sat 09 May 2020 05:14:28 PM PDT archive.org

FormatExpress is an easy-to-use online formatter where you simply paste some bunch of raw XML, JSON, CSS or SQL, to get it automatically beautified. The most common use-case is to help reading minified input found in logs or web services.

online webapps formatting json csv xml css sql devtools
xwiki-labs/synapse_scripts https://github.com/xwiki-labs/synapse_scripts
Mon 13 Jan 2020 07:04:41 PM PST archive.org

psql and shell scripts for maintaining a Matrix Synapse chat server. Currently looking for maintainers.

scripts sysadmin matrix sql shell maintenance
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
dataset: databases for lazy people https://dataset.readthedocs.io/en/latest/
Thu 06 Sep 2018 11:31:37 AM PDT archive.org

dataset provides a simple abstraction layer removes most direct SQL statements without the necessity for a full ORM model - essentially, databases can be treated like a JSON file, a hash table or a NoSQL datastore.

Schema is automatically generated and updated. If you want to, you can use SQLite's in-memory database functionality. Records are either created or updated automatically, depending on whether or not they exist already. Built on top of SQLalchemy so whatever it supports, dataset supports.

Github: https://github.com/pudo/dataset

python module data databases abstract sql
radondb/radon: RadonDB is an open source, cloud-native MySQL database for building global, scalable cloud services https://github.com/radondb/radon
Mon 14 May 2018 12:28:25 PM PDT archive.org

A distributed database that speaks MySQL's dialect of SQL and wire protocol on the front end, and is a fully distributed database system on the back end. Automatically shards databases efficiently. Implements ACID compliant distributed transactions for consistency.

database mysql golang protocol distributed sharding compatible foss sql
dinedal/textql: Execute SQL against structured text like CSV or TSV https://github.com/dinedal/textql
Thu 12 Apr 2018 11:11:51 AM PDT archive.org

Command line utility which lets you run SQL queries against CSV and TSV files.

utility golang sql query text csv tsv data cli
sqlmap: automatic SQL injection and database takeover tool http://sqlmap.org/
Tue 20 Mar 2018 02:36:28 AM PDT archive.org

A utility capable of fingerprinting back-end SQL databases, pulling authentication credentials and schemas, enumerating databases, and generating SQL injection attacks against web applications. Can handle MySQL, Oracle, Postgres, SQL Server, DB2, and other systems.

scanner tools web databases python sqlinjection sql pentesting infosec software
ORACLE SQL Injection Cheat Sheet http://ferruh.mavituna.com/oracle-sql-injection-cheat-sheet-oku/
Tue 20 Mar 2018 02:34:52 AM PDT archive.org

A handy cheatsheet for crafting SQL injection attacks against web apps backed by Oracle.

pentest sqlinjection cheatsheet cracking sql oracle injection security
SQL Injection Cheat Sheet http://ferruh.mavituna.com/sql-injection-cheatsheet-oku/
Tue 20 Mar 2018 02:34:48 AM PDT archive.org

A handy cheatsheet for crafting SQL injection attacks against web applications.

exploits reference webapps cheatsheet howto sql injection pentesting databases security
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
osquery :: Home https://osquery.io/
Mon 19 Mar 2018 10:56:38 PM PDT archive.org

Implements a SQL layer on top of the OS so you can run queries against system state. Stores and detects state differences. Uses the underlying system API to do its thing. Daemon, with a CLI interface. Alerting, et al has to be implemented yourself but at least the base layer is done for you.

cli crossplatform system api sql os utility monitoring
4817 links, including 361 private
Shaarli - The personal, minimalist, super-fast, database free, bookmarking service by the Shaarli community - Theme by kalvn