SQLite alternate for Python

Shows some really nifty tips for working with sqlite3 databases.

If you’re designing a REST API, auto incremented primary keys can be a threat. They expose a lot of informations about your API and the internal structure. UUIDs can help to cover these information and make your API more secure. In the following I’m going to explain what a primary key is and what problems can occur with auto incremented primary keys.

This is a compendium of Advanced SQL tricks meant to serve as a reference for data analysts. There's no particular order to reading these recipes – each one starts with an applicable business case. Start with the most pressing business decision you are facing, and solve it by using the SQL recipe as a template.

This guide combines pretty much all material I’ve found online about the topic, adds some of my own, and provides many practical examples.

Offline storage, improved. Wraps IndexedDB, WebSQL, or localStorage using a simple but powerful API.