Posts with the tag Database


search using SQL

SELECT * from bash_history where  command LIKE '%modprobe%'

% is the wildcard character in SQL!

SQlite specifics


Read on

Database abstraction with Python: SQLAlchemy

The SQLAlchemy SQL Toolkit and Object Relational Mapper is a comprehensive set of tools for working with databases and Python. It has several distinct areas of functionality which can be used individually or combined together. Its major API components, all public-facing, are illustrated below:

|    ...

Read on


Important Notes

Omitted SQL Language Features

SQLite Keywords
you cannot choose table names from the keywords list!!!

enforce foreign keys
SQLite Foreign Key Trigger Generator:

Jump Start

SQLite with Python

Admin tools / GUIs


Open Source, cross platform!

SQLite Database Browser

sudo apt-get install sqlitebrowser



Read on

Change the date of WordPress posts in an SQL Mass Update

When I programatically added most of the blog posts in this blog, I forgot to adjust the date and time of each post to its actual age. So I decided to set it via SQL directly in the database.

First I worked out a SELECT query to filter all the entries...

Read on

latexdb - a tool to automate document creation using DBs
hopefully there will be a version 0.4 soon! (dev. since v.0.3 took 2 years already)

get the package and run the "install" script contained... latexdb-0.3 also needed: python_mysqldb:

sudo apt-get install python-mysqldb
latexdb-0.3 $ sudo ./install

Read on