Database Development

database

Great Reads

Model-driven REST or GraphQL API for CRUD and More

by Evoluteur

Generic REST or GraphQL endpoints for CRUD and more, written in JavaScript, using Node.js, Express, and PostgreSQL

Using Redis for Storing and Working with Geospatial Data

by Aleksandr Ulanov

Learn how to use Redis and its geospatial indexes and commands for complex geo calculations

Dynamically Add Access Database Columns at Runtime using VB.NET

by Rob Culhane

How to dynamically add access database columns at runtime using VB.NET

Getting Started with PouchDB - Part 1

by Paul D. Sheriff

As more and more users interact with web applications on their mobile devices, it is becoming increasingly important for software developers to allow them to work offline; PouchDB can help.

Latest Articles

Understanding Vector Databases

by Nicolas DESCARTES

What are vector databases?

Introduction to B-trees: Concepts and Applications

by Ștefan-Mihai MOGA

How to solve real-life problems using B-trees

SqlServer & EF7: Using datetime vs datetime2 date type

by Mark Pelf

Showing problems with limited accuracy of SqlServer data type “datetime” in .NET7 EF7 environment

Entity Framework 7 – Code First – Using CLI

by Mark Pelf

Tutorial on EF7 – Code First approach using Command Line (CLI)

All Articles

top

Database Development

Introduction to NoSQL and Polyglot Persistence

16 Oct 2017 by Nikola M. Živković

Introduction to NoSQL and Polyglot Persistence

SQL

NoSQL

database

Get Ready to Learn SQL: 8. Database Normalization Explained in Simple English

22 Oct 2014 by essentialSQL

Database normalization in SQL explained in simple English

SQL

normalization

database

Cross Join Introduction – Create Row Combinations

29 Dec 2016 by essentialSQL

Introduction to cross join - create row combinations

Realm Database Tutorial For Android – Part 1

27 Jun 2016 by Val Okafor

Realm Database Tutorial For Android – Part 1

database

Get Ready to Learn SQL: 11. Database Third Normal Form Explained in Simple English

3 Nov 2014 by essentialSQL

Database Third Normal Form explained in simple English

SQL

normalization

database

How to Write SQL – Understand Database Table Meanings and Relationships – Step 1

19 Jan 2016 by essentialSQL

How to Write SQL – Understand Database Table Meanings and Relationships – Step 1

SQL

database

Get Ready to Learn SQL: 10. Database Second Normal Form Explained in Simple English

21 Oct 2014 by essentialSQL

Database Second Normal Form explained in simple English

MEAN web development #7: MongoDB and Mongoose

7 Sep 2015 by Sander Rossel

The seventh in a series on MEAN web development.

How to Deploy Entity Framework Database Migrations

2 Mar 2023 by Lee P Richardson

Deploy EF database migrations while avoiding security flags

SQL

security

database

Get Ready to Learn SQL Server: 15. Combine Table Rows Using UNION

22 Oct 2014 by essentialSQL

How to combine table rows using UNION in SQL Server

SQL

DBA

database

Order of Execution in SQL Explained

7 Mar 2022 by essentialSQL

In this blog entry we do an overview of the order if execution in SQL.

SQL

database

Getting Started With SQL Server: 2. Sort Your Query Results

24 Oct 2014 by essentialSQL

How to sort your query results in SQL Server

Best Database Managers for Developers

14 Dec 2015 by Steve Naidamast

The technical management of relational databases is a highly mature technology in the software development profession.

database

Firebase Android Tutorial Part 1 – Getting Started

17 Jul 2016 by Andy Point

Firebase Android Tutorial : Adding Registration and Login Hello Developers, this is our android firebase tutorial. In this tutorial we will create an android firebase app that will use firebase android login functionality. This post will help you get you up and running with integrating Firebase to a

Symfony: Connecting to External Database

26 Jul 2017 by Alvin Bunk

Symfony: Connecting to External Database

database

CRUD Operations with IndexedDB - Part 1: Creating and Clearing a Database

24 Jan 2018 by Gerd Wagner

How to create and clear an IndexedDB database keeping all code in a single HTML file. Creating an IndexedDB database means first creating an empty database, and then adding records to its empty tables (or "object stores").

Javascript

database

What is a Database Cursor?

7 Mar 2022 by essentialSQL

Learn about a database cursor with an example and when to use it in a SP

SQL

database

How to Use SQL Variables in Queries

7 Mar 2022 by essentialSQL

In this video and the following article, we’ll take you step-by-step through the process of changing a query’s filter criteria into a SQL variable, then ultimately into a stored procedure.

SQL

database

Choose the Right Model: Comparing Relational, Document, and Graph Databases

24 Nov 2021 by Arctype SQL

There are three major types of database models in use today. Learn about their differences and what applications they are good for.

Join on tables using Fluent NHibernate

29 Jan 2011 by Gilly Barr

Join on tables using Fluent NHibernate

All-Topics

database

Fluent NHibernate - Working with Database Views

5 Mar 2011 by Gilly Barr

Fluent NHibernate - Working with Database Views

All-Topics

database

TSQL Split a String by Delimiter

13 Apr 2013 by Shahriar Iqbal Chowdhury/Galib

TSQL split a string by delimiter

How to Speed Up MySQL Database Performance

15 Jun 2014 by Right Handed Monkey

MySQL Database Performance Diagnostics - Where to start?

enterprise

database

What are the Different Types of Database Backups?

14 Sep 2014 by derekman9707

Different types of database backups

Get Ready to Learn SQL Server: 17. How to Use the Intersect Operator

31 Oct 2014 by essentialSQL

How to use the Intersect Operator in SQL Server

Reducing KnpPaginatorBundle Database Queries

25 May 2017 by Alvin Bunk

Introduction If you are not familiar with the KnpLabs KnpPaginatorBundle and how to use it with Symfony applications, you might want to read up on it. The GitHub page does say it is a Symfony 2 bundle, however, it does work perfectly with Symfony 3. Why would you use it?

database

Realm Mobile Database with Xamarin Forms Step By Step guide

8 Jun 2017 by S Ravi Kumar (TechieRathore)

Whenever we talk about offline data persistence in Mobile application using a database the only database comes in our mind is SQLite as it is [...]

database

Top 5 Stored Procedure Performance Tips You Can Use

7 Mar 2022 by essentialSQL

Top five performance tips for Stored Procedures

SQL

database

Deep Data Dive with Kusto for Azure Data Explorer and Log Analytics

12 Apr 2020 by Jeremy Likness

Some ah-hah moments about Kusto

Preventing Duplicates in the Data

16 May 2011 by Andrew Zwicker

How to prevent duplicates in the data

SQL

data

database

Analyzing Dependencies in MSSQL

24 May 2011 by Mel Padden

A script that analyzes the text of each individual object and builds a tree of what depends on what.

SQL

SQL-Server

database

Script to extract all check constraints from a database

24 May 2011 by Mel Padden

From a utility I'm working on. Compatible with SQL-92 INFORMATION_SCHEMA views.

SQL

screen

database

Efficiency of Subqueries and OR conditions in SQL

25 May 2011 by Andrew Zwicker

A discussion of how joins significantly outperform subqueries and how this is more evident when OR conditions are involved.

SQL

database

How to Multicast messages with SQL Server Service Broker

22 Jul 2011 by rusanu

How to Multicast messages with SQL Server Service Broker

Cross-Tabulation (Pivot Tables) with MySQL

10 Apr 2012 by Cale Dunlap

Example of using code-based query generation, transposition, cross-tabulation, and normalized data to produce a query result that can feed a simple chart from data which was not originally designed with reporting or charting in mind.

Database Snapshot Failed Due to Disk Space Issue

29 Jan 2014 by Rohitmssqlfun

Database snapshot failed due to disk space issue

enterprise

database

Working with Visual Basic Database Connection

17 Mar 2014 by Sharjeel_Ahmad

Working with Visual Basic database connection

enterprise

database

Oracle Database Table to JAVA Bean Class Converter

24 May 2014 by Debopam Pal

Oracle Database Table to JAVA Bean Class Converter

enterprise

database

Oracle Database Table to JAVA Bean Class Converter

25 May 2014 by Debopam Pal

Oracle database table to Java Beans Class Converter

enterprise

database

Android Database Example and Tutorial (Thread Safe Version)

15 Jun 2014 by Right Handed Monkey

Android Database Example and Tutorial (thread safe version)

Introducing the WorxForUs Open Source Database & Network Helper for Android

13 Jun 2014 by Right Handed Monkey

Introducing the WorxForUs Open Source Database & Network Helper for Android

A Hidden Feature sp_MSforeachtable–Run on Entire Tables of a Database - TIP# 51

6 Oct 2014 by Rajat-Indiandotnet

A Hidden Feature sp_MSforeachtable–Run on Entire Tables of a Database - TIP# 51

database

A More Useful Port of the Chinook Database to Postgresql

6 Apr 2015 by John Atten

A More Useful Port of the Chinook Database to Postgresql

database

SCALA : Connecting to a database

14 Dec 2015 by Sacha Barber

This time we will proceed to look at using Scala to connect to SQL server.

Scala

database

Redis: Replication, Part 1 – An Overview. Replication vs Sharding. Sentinel vs Cluster. Redis Topology

29 Mar 2019 by setevoy4

In this post – some quick overview, a brief explanation about differences in Redis data storage, topology examples. In short terms but with links to detailed documentation and other useful posts on other resources.

Redis: Replication, Part 3 – redis-py and Work with Redis Sentinel from Python

3 Apr 2019 by setevoy4

The redis-py library and work with Redis Sentinel from Python

SQL FULL Join Tutorial

6 Mar 2022 by essentialSQL

In this article we look at SQL FULL JOIN examples and make a few notes of things to look for.

SQL

database

SQL Data Conversions

7 Mar 2022 by essentialSQL

Learn about implicit data conversion and explicit type conversions with CAST AND CONVERT

SQL

database

SQL Bill of Materials Example

7 Mar 2022 by essentialSQL

Puzzle to explore a SQL BOM example

SQL

database

Left Join versus Right Join Comparison

7 Mar 2022 by essentialSQL

In this blog entry we discuss the difference between left join versus right join operators.

SQL

database

A First Look at NoSQL and MongoDB in Particular

16 Mar 2015 by Sander Rossel

Getting your feet wet in NoSQL with MongoDB!

Storing Database Tables in JavaScript's Local Storage

20 Jan 2015 by Gerd Wagner

Storing database tables in JavaScript's Local Storage

Javascript

Dev

database

Get Ready to Learn SQL: 9. Database First Normal Form Explained in Simple English

21 Oct 2014 by essentialSQL

Database First Normal Form explained in simple English

10 Things to Make Your Desktop Database Apps Better

3 Feb 2011 by JasonShort

Here are 10 things to make your desktop database apps better

Migrating a Project from Database First to Code First

11 Feb 2016 by kevinfitzpatrick

Migrating a Project from Database First to Code First

database

Mapping Shortest Routes Using a Graph Database

30 Jan 2013 by Keyhole Software

We often model interconnected data by cramming it in and out of table structures. Why don’t we simply model interconnected data as … interconnected data?

Java

algorithm

database

Get Ready to Learn SQL Server: 4. Query Results Using Boolean Logic

24 Oct 2014 by essentialSQL

Learn more about filtering results returned from your queries using the WHERE clause

Get Ready To Learn SQL Server: 3. How to Filter Your Query Results

24 Oct 2014 by essentialSQL

In today’s lesson, you’re going to learn how to filter the results returned from your queries using the WHERE clause.

Getting Started with SQL Server: 1. Simple SELECT Queries

25 Oct 2014 by essentialSQL

Simple SELECT queries in SQL Server

Using C# to Connect to and Query from a SQL Database

16 Mar 2015 by Sander Rossel

Using C# to get data in- and out of your (relational) database

Overview of ADO.NET

7 Aug 2017 by JasonShort

ADO.NET is a set of libraries included in the .NET Framework to facilitate the communication of applications with various data storage mechanisms. These libraries form the basis for all third parties to provide database access.

What is the Role of the Database?

7 Jul 2016 by Gaston Verelst

What is the role of the database?

database

Get Ready to Learn SQL Server: 5. Filter Results Using Patterns

29 Oct 2014 by essentialSQL

In this lesson, you are going to explore how to do pattern matching with the SQL Where clause LIKE operator.

Firebase Realtime Database By Example with Android

13 Feb 2017 by Val Okafor

A complete, step by step tutorial on working with Firebase Realtime Database in Android

Java

Android

database

Getting Started with NoSQL and MongoDB

26 Feb 2014 by JonB3232

Getting Started with NoSQL and MongoDB

SQL

NoSQL

database

RESTORE DATABASE is Terminating Abnormally

30 Mar 2016 by Bryian Tan

Restore Database is terminating abnormally

database

Onion Architecture using MVC and Database First Approach

5 May 2015 by Jasminder Singh

Onion architecture using MVC and database first approach

database

B-tree Indexes

2 Nov 2014 by Ronnie Mukherjee

B-tree Indexes

performance

indexes

database

Saving An Image in a SQLite Database in Your Android Application

26 May 2015 by Cindy Potvin

Saving an image in a SQLite database in your Android application

SQLite Database

29 Dec 2013 by Sam Varadarajan

An introduction to SQLite.

enterprise

database

Using Membase for ASP.NET Output Caching

17 Apr 2011 by andy404

Using Membase for ASP.NET Output Caching

ASP.NET

database

Execute SQL Query on Mutiple SQL Servers or Databases Simultaneously

2 Jun 2015 by Mohit1110

In this blog we would learn how to execute a SQL Query on multiple databases of single DB Server or on a single Database on multiple DB Servers.

Joins vs Subqueries SQL Puzzle

7 Mar 2022 by essentialSQL

Puzzle to teach joins vs subqueries in SQL

SQL

database

Rewrite Subquery as a Join

7 Mar 2022 by essentialSQL

How to rewrite a subquery as a join

SQL

database

The Firebird Database Engine & The Frustrations of The Long Distance Database Application Developer

11 May 2018 by Steve Naidamast

https://www.firebirdsql.org/ Author’s Notes… Though I have extensive database application development experience, I do not consider myself an expert with the Firebird Database Engine to any degree.

database

Prepared Statements for Database Driven Application

15 Jan 2014 by Vivek Goyal

Prepared statements for database driven application

enterprise

database

Contains in SQL

6 Mar 2022 by essentialSQL

Sooner or later, you want to know when a column contains in SQL another value. In this article we’ll go over several ways you can test to see whether one value is contained within an another.

SQL

database

Database Normalization

23 May 2016 by Gaston Verelst

Introduction After I published last week’s article somebody asked me why I stated that (in this case) the problem didn’t originate in having a function with logic, but merely having to work with a database that is not normalized. So let’s talk … Continue reading →

database

SQL Joins and Subqueries

23 May 2011 by Andrew Zwicker

A discussion about SQL joins and subqueries with information about how to format join statements properly

SQL

database

Correlated Subqueries in SQL

7 Mar 2022 by essentialSQL