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

Understanding Vector Databases

9 Feb 2024 by Nicolas DESCARTES

What are vector databases?

artificial-intelligence

vector

database

Introduction to B-trees: Concepts and Applications

20 Jan 2024 by Ștefan-Mihai MOGA

How to solve real-life problems using B-trees

SqlServer & EF7: Using datetime vs datetime2 date type

8 Jun 2023 by Mark Pelf

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

.NET

database

Entity Framework 7 – Code First – Using CLI

1 Jun 2023 by Mark Pelf

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

.NET

entity-framework

database

How to Save Object Graph in Master-Detail Relationship with One Stored Procedure

26 May 2023 by Vadim Loboda

A way to persist C# object graph to database with single procedure using ADO.NET and table valued parameters

SQL

DBA

database

Entity Framework 7 – Database First – Using EFCorePowerTools

25 May 2023 by Mark Pelf

Tutorial on EF7 – Database First approach using GUI tools EFCorePowerTools

.NET

entity-framework

database

Entity Framework 7 – Database First – Using CLI

25 May 2023 by Mark Pelf

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

.NET

entity-framework

database

Workaround for AT TIME ZONE Performance Issues in SQL Server Views & Dynamic SQL

6 Mar 2023 by Andriy Protskiv

Workaround for performance issues with AT TIME ZONE

Autogenerate Unit Tests For Your Database Objects - Visual Studio 2019 & 2022 (amd64) Extension

4 Jan 2023 by Bert O Neill

Features and functionalities associated with Autogenerate DB Unit Test app

SQL-File Technology for Transact-SQL

19 Dec 2022 by Sergei Y.Kitáev

Introduction to statically parameterized SQL language

That's not a database, dude!

1 Dec 2022 by OriginalGriff

There are many things you can use to store information, but not all of them are databases. And trying to use them as such is a really, really bad idea.

Using Redis for Storing and Working with Geospatial Data

10 Aug 2022 by Aleksandr Ulanov

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

Generic Repository with SQLAlchemy and Python

5 Jul 2022 by DiponRoy

Example of Generic Repository Class with SQLAlchemy and Python

Python

ORM

database

Conditional filtering in SQLAlchemy and Python

3 Jul 2022 by DiponRoy

Conditional filter query example in SQLAlchemy and Python

Merge Data in Database

28 Jun 2022 by DiponRoy

How to use MERGE statements in different databases

Single Database for Multiple Microservices with FluentMigrator

3 Jun 2022 by Ivan Yakimov

How to use single database to store information from several microservices with the help of FluentMigrator

.NET

database

Model-driven REST or GraphQL API for CRUD and More

11 May 2022 by Evoluteur

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

DataProvider - A Static Library for Handling Databases from C++

8 Jan 2022 by Michael Haephrati

A Static Library which can be used for all kinds of database related needs

4db: A Dynamic File-based NoSQL Database for C++

22 Nov 2021 by Michael Sydney Balloni

Wanna add basic database functionality to your C++ app? Too lazy to use SQLite directly? Read on!

Implement a Distributed Database to Your Java Application

7 Oct 2021 by Sam B. Brown

Interference open cluster is a simple Java framework that enables you to run a distributed database service within your Java application

metastrings: A Simple File-based Dynamic NoSQL Database

9 Aug 2021 by Michael Sydney Balloni

Learn about the inner workings of a dynamic database, and how SQLite is a great fit

Fast Typo-Insensitive String Matching in a Program and a Database

12 Jul 2021 by David Wincelberg

Strings that differ by typos can be matched.

Documenting MS SQL Server Databases

27 Jun 2021 by Evgeniy Gribkov

The examples of SQL Server database documentation using both the extended properties and a third-party utility.

SQL

database

A Database Initialiser for SQLite and NPoco

5 Jun 2021 by Private Dobbs

How to initialise a database and then automatically keep it up to date with version releases

Options for Database Backup and Restore - How to Export BACPAC using SSMS?

6 Apr 2021 by Satya Karki

This article describes the options to restore and backup database in SQL Server and explains how to Export BACPAC from SQL Server Management Studio.

database

migration

application

Mongo DB Tutorial and Mapping of SQL and Mongo DB Query

18 Mar 2021 by VijayRana

A tutorial for MongoDB Tutorial

Step-by-Step PHP Tutorials for Beginners - Creating your PHP Program FROM SCRATCH: Basic Authentication, Membership and CRUD Functionalities

26 Jan 2021 by Kristian Guevara

PHP tutorials for beginners

How to Manipulate Hierarchical Information in Flat Relational Database Tables

21 May 2020 by Akshay Srinivasan2

This article describes a technique to quickly retrieve and present hierarchical information from a flat relational database table with only one table scan.

SQL 2019 - New Features

13 Jan 2020 by koolprasad2003

New features of SQL 2019

SQL

SQL-Server-2019

database

Automating the SQL Database Mirroring Setup

30 Dec 2019 by Dathuraj Pasarge

Database mirroring setup without any DBA effort - on every new database creation

MySQL Auto Failover using Keepalived on CentOS

5 Dec 2019 by Renz Ladroma

A tutorial on how to setup Keepalived for MySQL Auto Failover

Linux

MySQL

database

SQL Server Database :: Source Control, Continuous Integration and Continuous Deployment using Github, TeamCity and Octopus

20 Oct 2019 by Ravi K. Acharya

The complete step-by-step guide to build a CI/CD pipeline for your Microsoft SQL Server database using Github, TeamCity and Octopus.

Generated Columns in PostgreSQL

19 Sep 2019 by Shameel

This article describes different ways of setting up generated (computed) columns in different versions of PostgreSQL.

PostgreSQL

database

Restrict Access to SQL Server Data using a Facade Database

7 Sep 2019 by Shameel

This article describes a way to create a Facade Database to provide restricted access to specific tables in your databases to specific users without granting direct access to any of the underlying databases/tables.

SQL-Server

best-practices

database

GraphQL: Evolution of Modern Age Database Management System

21 Aug 2019 by David Cuelogic

GraphQL: Evolution of Modern Age Database Management System

DBMS

graphql

database

SQL 2017 - New Features

18 Aug 2019 by koolprasad2003

SQL 2017 new features

SQL

SQL-Server-2017

database

QxOrm - C++ ORM (Object Relational Mapping) Library

24 Apr 2019 by QxOrm

QxOrm C++ library: Persistence (based on QtSql Qt library) - Serialization (based on boost::serialization library) - Reflection (introspection)

Cachalot DB as a Distributed Cache with Unique Features

16 Apr 2019 by Dan Ionescu (USINESOFT)

LINQ extensions that allow to describe and to safely query cached data

Indexed Views and How It Can Help in Improving Query Performance

23 Mar 2019 by Minh Tuan Do

A considerable method to speed up query running time

Getting Started with PouchDB - Part 3

21 Jan 2019 by Paul D. Sheriff

In this article, the 3rd in a multi-part series, you are going to learn how to query data within a PouchDB database.

Getting Started with PouchDB - Part 2

20 Jan 2019 by Paul D. Sheriff

In this 2nd part of my series on PouchDB, you learn how to perform multi-document inserts and reads.

Getting Started with PouchDB - Part 1

15 Jan 2019 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.

Integrate Firebase Phone Authentication With Laravel

13 Aug 2018 by Member 13935194

In this article, I will demonstrate how to integrate Firebase phone number authentication in Laravel.

Creating a Custom De/Serializer

13 Apr 2018 by Alaa Ben Fatma

In this article, we will walk through the basic concepts of de/serialization and how to create a very basic de/serializer.

Bulk Insert a .NET List to Database

31 Jan 2018 by Praveen P R

This article presents a simple and efficient way to bulk insert any .NET list to the database.

SQL Object Dependencies with Simple RegEx and Some Algo Magic

10 Jan 2018 by ASkaeff

A simple yet powerful tool to analyze SQL object dependencies in quite a fast and reliable manner.

SQL

database

regular-expression

LiteDB - A .NET NoSQL Document Store in a Single Data File

18 Oct 2017 by Mauricio David

Simple, fast and free embedded .NET NoSQL Document Store in single data file

Big Data MapReduce Hadoop Scala on Ubuntu Linux by Maven intellj Idea

12 Sep 2017 by Mahsa Hassankashi

This article is the most complete essay about big data from scratch to practical.

ASP.NET Core cross platform development with Database

12 Sep 2017 by Bruce Yang CL

Develop an ASP.NET Core NES Game website on Linux with cross platform Database, and deploy to Ubuntu & Windows which have no .NET Core runtime installed.

Dev's User Guide To SqlLocalDb (Sql Express)

14 Aug 2017 by raddevus

Learn the basics (and challenges) of using LocalDb to make your SQL dev easier and localized using tools like SqlLocalDb, sqlcmd and built-in Visual Studio server explorer. Now, also includes SqlCmd scripting.

SQL

.NET

database

SQL Server Notifications on Record Change with SignalR and SQLTableDependency

3 Jul 2017 by Christian Del Bianco

SqlTableDependency is a component used to receive database notifications containing the record values inserted, deleted or update on a database table.

THVDataSet - A Complete Delphi DataSet Based on Stream

7 Feb 2017 by hamdenvogel

Learn how to implement a real stream file based dataset descendant with blob support and much more

Delphi

desktop

database

Create OData endpoint for MongoDB on MEAN stack

28 Nov 2016 by Neal Pandey

This article is a tutorial on creating a basic OData (Open Data Protocol) endpoint for a MongoDB database using MEAN stack.

Input, Output and Input/Output SqlParameter Behavior Explained

1 Nov 2016 by Bob Crowley

In this article, I will explain the sometimes surprising behavior of the ADO.NET SqlParameter and particularly the effects of ParameterDirection, null value and DBNull.Value on how the parameter is sent to the database.

SQL Simple Utilities

22 Sep 2016 by Alexandros Pappas

This project provides utilities for SQL server, such as executing a list of SQL scripts, exporting data to an SQL script, and displaying relationships between records.

Use SQL Server to Manage Completely DB Backups on Mirrored Databases

21 Sep 2016 by GhostHost

Use SQL Server to manage completely databases backups, network copy and deletion using only stored procedures

Top 10 Exciting New Features in SQL Server Management Studio 2016

23 Aug 2016 by Suvendu Shekhar Giri

Introduction of new useful features in SSMS 2016

Masking Sensitive Data with SQL Server 2016

15 Aug 2016 by Suvendu Shekhar Giri

How sensitive data in SQL Server 2016 can be masked from the outer world using Dynamic Data Masking

SQL-Server-2016

SQL-Server

database

Jatalog: A Datalog Deductive Database in Java

27 Jul 2016 by Werner Stoop

A Java implement of Datalog, a subset of the Prolog programming language that is used as a query language in deductive databases

Unattended installation of SQL Server 2012

11 Jul 2016 by Jesus Carroll

Despite the references of several sources of unattended installation of Microsoft SQL Server Database Engine, in this article describes a script tested in real production environments and it can be used with minimal or - perhaps - no modifications.

MongoDB Tutorial Day 4: Aggregation

21 May 2016 by VijayRana

Aggregation in MongoDB

SQL

MongoDB

database

MongoDB Tutorial - Day 3 (Performance - Indexing)

18 Apr 2016 by VijayRana

Performance - Indexing in MongoDB

.NET

Dev

database

MongoDB Tutorial - Day 2

11 Apr 2016 by VijayRana

MongoDB Tutorial - MongoDB specific queries

Hidden Gems of DEFAULT TRACE in SQL Server

21 Mar 2016 by Sergii Syrovatchenko

Starting from SQL Server 2005, the default trace is enabled by default on every SQL server. Default trace is a lightweight system trace, which stores a lot of useful information about the changes in the system...

Iterators and Snapshots for LevelDB UWP

13 Mar 2016 by Zohaib Sibte Hassan

A more detailed look into Iterators and Snapshots in LevelDB UWP

Parameterize Schema Name in SSDT Database Project .dacpac file by using DacFx Public Model and System.Reflection

26 Feb 2016 by Pavel Sinkevich

How to programmatically change schema name in database project before deployment

NoSQL: MongoDB for Beginners

21 Feb 2016 by adityaswami89

NoSQL: MongoDB for beginners

SQL

NoSQL

database

A Practical Approach of Time Travel Concept in Business Intelligence Scenarios using Temporal Tables on Data Warehouses

10 Feb 2016 by Jesus Carroll

SQL Server 2016 introduces support for system-versioned temporal tables as a database feature that brings built-in support for providing information about data stored in the table at any point in time rather than only the data that is correct at the current moment in time.

SQL Database Simulator in the Browser

19 Jan 2016 by Avron Polakow

This article presents a client-side, JavaScript Relational Database Simulator in the browser, using SQL commands to Create, Read, Insert, Update and Delete in-browser table data, as well as formatting the output as HTML objects in a Webpage.

Realtime MVC Application using n-tier architecture

9 Jan 2016 by Sandeep Neela

Friday the 13th - JSON is Coming to SQL Server

8 Dec 2015 by Jovan Popovic(MSFT)

Overview of built-in support for JSON text processing in new SQL Server

LiteDB - A .NET NoSQL Document Store in a Single Data File

14 Oct 2015 by Terence Wallace

Alternative VB.NET version of "LiteDB - A .NET NoSQL Document Store in a single data file"

Build Your Own Database

14 Sep 2015 by nam1234567

Build your own database class library with C#

VS2013

database

An All purpose database manager

14 Apr 2015 by Menci Lucio

I wrote a class to have an access to all databases in the simplest and smartest way

.NET

VS2013

database

Refering dlls in SSIS Script Task

10 Apr 2015 by Rajeesh Madambat

Refer and write your own business logic in C# and add it to SSIS script task.

Kerosene ORM: a dynamic, configuration-less and self-adaptive ORM for POCO objects supporting a SQL-like syntax from C#

1 Mar 2015 by mbarbac

The seventh version of the dynamic, configuration-less and self-adaptive Kerosene ORM library, that provides full real support for POCO objects, natural SQL-like syntax from C#, and advanced capabilities while being extremely easy to use.

Kerosene ORM Maps In Depth

1 Mar 2015 by mbarbac

A deep dive into the Kerosene ORM Entity Maps operational mode that provides full real support for POCO objects.

Kerosene ORM Dynamic Records In Depth

1 Mar 2015 by mbarbac

A deep dive tutorial on Kerosene ORM Dynamic Records and other core concepts of the library

Self-Synchronized Data Access Layer - Part II

11 Feb 2015 by Aydin Homay

In the software implementing business synchronizing structures/templates of the database entities with Data Access Layer SQL (commands/Transactions) is the most expensive thinks because you need to re-implement when you have change/s in your entities structure's such as Data-type, Name, and etc.

Performance testing of ORM layers in Python and C++

27 Jan 2015 by Vaclav Naydenov

Comparing the performance of two similar CRUD server apps, one written in Python and SQLAlchemy, the other in C++ and YB.ORM.

EF Code First and WPF with the Chinook Database. Part 3 – Styles and DataTemplates 101

12 Jan 2015 by Leom Burke

EF Code First and WPF with the Chinook Database - Styles and DataTemplates

database

Quick Introduction to YB.ORM - Object Relational Mapper for C++

30 Oct 2014 by Vaclav Naydenov

How C++ library YB.ORM can help manipulate the data stored in RDBMS using domain classes. Basic concepts of ORM are explained by examples.

Semantic Database: Concept, Architecture and Implementation

25 Oct 2014 by Marc Clifton

No word has a value that can be identified independently of what else is in its vicinity.

Android dynamic Sqlite database management v.2

16 Oct 2014 by Pavel Durov

Article about dynamic Sqlite database management on Android platform using Java class reflection.

SQL Queries to Manage Hierarchical or Parent-child Relational Rows in SQL Server

15 Sep 2014 by DiponRoy

Some queries to find generation of each row, all possible children, all possible parents, managing recursion

Android Data Storage

14 Sep 2014 by Varavut

Lean about how to manage the data

Article 8 - Handling Input and Storage on Android

9 Sep 2014 by Ahmed Alaa El-Din

This articles provides a brief description of different methods that Android platform can provide for a developer to save different data types with different storage methods like Shared Preferences, Internal Storage, External Storage, SQLite DB, and Web Services

One to Zero/One Relation in Entity Framework Code First

13 Aug 2014 by DiponRoy

Here, we will see how to configure one to zero/one relation between two entities in Entity Framework Code First

Manage Entity Framework Code First in Real Time Projects

28 Jul 2014 by DiponRoy

How to manage Entity Framework Code First in Real Time Projects

Create First SSRS Report with SQL Server Analysis Services OLAP Cube

20 Jul 2014 by Mubin M. Shaikh

This Article will give you a good start for Creating SSRS Report First time with SQL Server Analysis Services OLAP Cube

Developing Semantika Client Application

25 Jun 2014 by Josef Hardi

This is the third and final article about Semantika. This article will guide you to develop a simple "hello-world" query application

Service for StackExchange: Implementing a Data Provider

5 May 2014 by Shuqian Ying

Client side data provider for data importing to a relational data service build for StackExchange data dump.

FlatFile Database System

2 Apr 2014 by Anand Gunasekaran

Working with text file as database can querying as RDBMS with SQL Queries.

How to do some magic with indexedDB

26 Mar 2014 by David Fahlander

Discover the hidden features of indexedDB!

MongoDB Installation Scripts for Windows

17 Mar 2014 by x3F

Batch scripts that help install MongoDB on a Windows PC

Uploading files to database from ASP.NET pages

16 Mar 2014 by ASP.NET Community

This example will show how is possible to upload files to SQL server database using C# and asp.net. For demostration purposes database will have only

ASP.NET

file

database

Upload an Image and an Audio file using C#

2 Mar 2014 by ASP.NET Community

In my case, I use a FileUpload Control(Id:->FileUpload1), an ImageButton(ImageButton1) or you can use the Image, a Button Control(Id:->Updatebttn)

.NET Application Modeling Language

14 Jan 2014 by ASP.NET Community

IntroductionnAML (.NET Application Modeling Language, pronounced as “namel”) is a visual modeling semantics to model .net applications with wide

String Aggregation in the World of SQL Server

4 Dec 2013 by Sergii Syrovatchenko

This article includes examples of T-SQL capabilities that allow to perform string concatenation flexibly and effectively through the use of different constructs.

Developing Automated Data Purge Solution

30 Nov 2013 by DaveAuld

Too much data is breaking the system, we need a fix!

SQL

database