Tag: databases

Learn what SQLite is, how some of its advanced features work, and how you can use it in Python projects with the help of the sqlite3 module.

This Airtable tutorial will take you through everything this tool has to offer, and explain how it can make your life easier.

MySQL 5.7+ InnoDB databases and PostgreSQL 9.2+ support JSON document types in a single field. We explore the MySQL 8.0 JSON implementation in more detail.

Dhanraj Acharya covers database options in React Native and walks through an example app using models, schema, actions, and reactive components in WatermelonDB.

Importing a large amount of data into Redshift is easy using the COPY command. To demonstrate this, we’ll import a publicly available dataset.

Craig Buckler shows you how to use RestDB to create a simple CMS.

Kirill demonstrates a practical example of optimizing a website's MySQL queries - check it out, it might come in handy in your optimization gigs!

Ben Dickson covers what you need to know about SQL injection and how to protect your site against it.

Jatin Shridar introduces PouchDB, an in-browser NoSQL, document database. Learn how to store your app data locally and later sync it with a server-side DB.

Horizon is a scalable backend perfect for JavaScript and cross-platform mobile apps, in this tutorial Wern Ancheta creates a multiplayer game to show why.

Thomas explores Ecto features, including query composition, joins and associations, SQL fragment injection, explicit casting, and dynamic field access.

Thomas looks at the basics of querying with Elixir's Ecto library, going through joins, associations, aggregation functions, and so on.

Thomas introduces Ecto, Elixir's predominant library for working with databases, building a simple database-driven app using Ecto's four main components.

Most apps will need to store data at some point. In this tutorial, Deivi Taka looks at managing data in iOS with SQLite, an easy and light storage option.

Valdio Veliu looks at Realm.io, a promising replacement for storing app data that promises to streamline, speed up and simplify your development process.

Narayan Prusty looks at the plugins and APIs available for storing local data in a Cordova App and creates an application to demonstrate.

Thomas Greco looks at the recent changes to Firebase and wonders if it's new offline support now makes it an ideal mobile data store.