Recent Posts

8 Techniques To Speed up Your Database “If everything seems under control, you’re not going fast enough” Photo by Christina Morillo (original). Thank you! Almost all web services for end-users have the need to store data. Almost all of them store them in a database. And quite a lot use a relational database like PostgreSQL, MySQL/MariaDB, or MSSQL. Database systems are pretty awesome because you can … Read More »

MongoDB MongoDB is a document-oriented database system. It is used to store JSON objects. The problem it solves is working with heterogenous data which does not fit into a schema or where creating a schema would be overly complicated. If it fits into a schema, use a SQL database like MySQL … Read More »

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 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 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 »

PHP: PEAR MDB2 PEAR is short for PHP Extension and Application Repository. It provides a very easy method to get some common classes. PEAR MDB2 is a database class. It is a successor of PEAR DB. I took a look at version 1.4.1 which is currently the … Read More »