Recent Posts

Key-Value Stores

Key-Value Stores

Key-value stores are specialized NoSQL databases. Essentially, they are dictionaries1. Database Properties ACID is a set of properties of database transactions intended to guarantee validity even in the event of errors, power failures, etc: Atomicity: Either all statements are applied or none. This is important for SELECTs. C … Read More »
SQL Connection Strings

SQL Connection Strings

When you want to connect to a database in SQLAlchemy, you need a connection string. It usually has the form dialect[+driver]://user:password@host/dbname[?key=value..] Quite often, the user is root and the host is localhost. Once you have the valid connection string, you can test if … Read More »
SQL Injections

SQL Injections

SQL is a language that allows prorammers to access data in databases. Most of the time (always?) you pass your queries in form of strings to the database. In online services it is quite common that the programmer formulates a template and the user fills in variables. Example: IMDb Take … Read More »
Comparing Dates in PHP and MySQL

Comparing Dates in PHP and MySQL

Sometimes you need to know compare PHP dates. You need to know what is later or if both dates are the same. PHP time formats and functions PHP knows these time / date formats: UNIX Timestamp: Integer - The number of seconds after 1970. Related functions are int `mktime([ int \$hour = date … Read More »