Databases

Learn what data preprocessing is, why it's important, and techniques for cleaning, transforming, integrating and reducing your data.

We answer the 10 most asked GraphQL questions, covering pagination, versioning, batch loading, cache handling, file uploads, and more.

SQL knowledge is essential for anyone who works with data. In this article, we discuss what SQL is, its importance, and how to get started.

These SQL books are the greatest approach to learn whether you're a beginner or advanced user wishing to upgrade your SQL skills!

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.

Need fast data interactions in your Node app? Learn how Redis speeds caching, message brokering, sessions, analytics, streaming and more.

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.

Learn the basics of MongoDB, the Mongo shell, popular drivers, common database operations and CRUD actions within the Mongo shell.

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

NoSQL databases use denormalized data, so relational JOINs are impossible. Craig explains how MongoDB's new $lookup operator overcomes this restriction.

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

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

Jehan introduces Please, a bash script for automating the installations of many CMSs and Frameworks by configuring them automatically into your Vagrant box.

Brij Mishra looks at web app state management, and Microsoft's In-Memory OLTP, to provide ASP.NET with a faster Session State Provider.

Are your MongoDB queries fast and effective regardless of database size? Craig discusses a number of options to consider when your NoSQL queries go quirky.

In the continuing SQL vs NoSQL debate, Craig discusses example project scenarios to determine which type of database offers the most benefit.

Shivam Mamgain introduces the basic commands of SQLite3, explaining how to use it from the command line.

Arno Slatius explains Yii 2.0's ActiveRecord, listing the features, novelties, upgrades and usage examples.

Francesco Malatesta introduces you to FluentPDO - a small and simple PDO library built to solve your data manipulation needs. See what it can do.

Rakhitha Nimesh dissects, explains and implements real time data pagination with cursor based pagination

0xDBE is a new tool by JetBrains made to solve all our database management problems. Soon, we'll be able to leave Workbench behind and work without crashes!

Peter Nijssen activates and demonstrates PhpMyAdmin's additional features - from SQL bookmarking to visual relationships

Google BigQuery now hosts GDELT - the world's largest dataset on human history - and it's free to use.

Taylor Ren explains how you can use Phreeze to autogenerate CRUD applications for your already existing databases - often in already existing apps.

Lukas White wraps up the SOLR series, configuring SOLR and Solarium from scratch and explaining how they work in-depth

This is the third article in a four-part series on using Solarium, in conjunction with Apache’s SOLR search implementation.

This is the second article in a four part series on using Solarium, in conjunction with Apache’s SOLR search implementation.

Lukas White begins a SOLR series, configuring SOLR and Solarium from scratch and explaining how they work in-depth

Lukas White introduces you to Ladder - a database versioning tool which lets you version control your database changes through migration files

Wern Ancheta explains what DBV is and how one can use it to version control a database