Click here to Skip to main content
15,559,567 members
Everything / Database Development

Database Development

database

Great Reads

by Evoluteur
Generic REST or GraphQL endpoints for CRUD and more, written in JavaScript, using Node.js, Express, and PostgreSQL
by Rob Culhane
How to dynamically add access database columns at runtime using VB.NET
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.
by Nikola M. Živković
Introduction to NoSQL and Polyglot Persistence

Latest Articles

by Bert O Neill
Features and functionalities associated with Autogenerate DB Unit Test app
by Sergei Y.Kitáev
Introduction to statically parameterized SQL language
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.
by TomasNemecr
How to cope with all scenarios regarding NULL value handling in your daily work

All Articles

Sort by Score

Database Development 

11 May 2022 by Evoluteur
Generic REST or GraphQL endpoints for CRUD and more, written in JavaScript, using Node.js, Express, and PostgreSQL
21 Apr 2013 by Rob Culhane
How to dynamically add access database columns at runtime using VB.NET
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.
23 Mar 2019 by Minh Tuan Do
A considerable method to speed up query running time
29 Jul 2014 by DiponRoy
How to manage Entity Framework Code First in Real Time Projects
28 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.
11 Aug 2022 by Aleksandr Ulanov
Learn how to use Redis and its geospatial indexes and commands for complex geo calculations
20 Jun 2013 by Levente Kupás
If you have big reports which run slowly, you may use this T-SQL based engine to speed-up them.
22 Nov 2021 by Michael Sydney Balloni
Wanna add basic database functionality to your C++ app? Too lazy to use SQLite directly? Read on!
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.
30 Dec 2019 by Dathuraj Pasarge
Database mirroring setup without any DBA effort - on every new database creation
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.
8 Jan 2022 by Michael Haephrati
A Static Library which can be used for all kinds of database related needs
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)
10 Apr 2015 by Rajeesh Madambat
Refer and write your own business logic in C# and add it to SSIS script task.
14 Oct 2015 by Terence Wallace
Alternative VB.NET version of "LiteDB - A .NET NoSQL Document Store in a single data file"
26 Feb 2016 by Pavel Sinkevich
How to programmatically change schema name in database project before deployment
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.
13 Jan 2020 by koolprasadd
New features of SQL 2019
9 Aug 2021 by Michael Sydney Balloni
Learn about the inner workings of a dynamic database, and how SQLite is a great fit
7 Feb 2017 by hamdenvogel
Learn how to implement a real stream file based dataset descendant with blob support and much more
7 May 2012 by Jason Rudland
Trial of popular REST implimentations for NodeJS including the measuring of MongoDB insertion rates.
15 May 2013 by h_wiedey
Implementation of relative database constraints and permissioning using triggers and shadow tables.
11 Oct 2013 by ASP.NET Community
Employee Info Starter Kit is an open source ASP.NET project template that is intended to address different types of real world challenges faced
12 Jan 2015 by Leom Burke
EF Code First and WPF with the Chinook Database - Styles and DataTemplates
5 Dec 2019 by Renz Ladroma
A tutorial on how to setup Keepalived for MySQL Auto Failover
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.
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.
5 Jun 2021 by Private Dobbs
How to initialise a database and then automatically keep it up to date with version releases
10 Jan 2018 by ASkaeff
A simple yet powerful tool to analyze SQL object dependencies in quite a fast and reliable manner.
2 Jun 2022 by Jason_Koo
In this article we look at why when store and query data using a graph database such as Neo4j, you can quickly surface critical information, and possibly expose potentially catastrophic issues hidden within complex datasets.
28 Jun 2022 by Jerry Cruise
Innovations against the shortcomings of SQL have been made to SPL. SPL redefines and extends many operations of structured data, specifically, it adds the discreteness, enhances ordered computation, implements a thorough set orientation, supports object references, and advocates stepwise operation.
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.
16 Apr 2019 by Dan Ionescu (USINESOFT)
LINQ extensions that allow to describe and to safely query cached data
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
3 Jun 2022 by Ivan Yakimov
How to use single database to store information from several microservices with the help of FluentMigrator
28 Sep 2011 by Ivan Vodišek
An alternative approach to database modeling.
5 Sep 2013 by Mr. xieguigang 谢桂纲
Easy way to map the table in the mysql database.
11 Oct 2013 by ASP.NET Community
Most ASP.NET sites talk to SQL Server or a backend SQL Database and there's a number of ways to manage that configuration.I always start with the
11 Oct 2013 by ASP.NET Community
LINQ to SQL is an interesting Object-Relational Mapper because it remembers the relationships objects have between each other.  As usual, LINQ to SQL
11 Oct 2013 by ASP.NET Community
Let see an example of using the database in LINQ and C#.netcf We will using classCustomer Here'ssome sample
11 Oct 2013 by ASP.NET Community
I had to create Umbraco database on my shared hosting (I am using Winhost at the moment) couple of days ago.After checking few examples on
11 Oct 2013 by ASP.NET Community
For ASP.NET developers, there is good news from Microsoft with the latest SQL Server release, Denali CTP3.Many developers like ASP.NET developers
11 Oct 2013 by ASP.NET Community
Getting started with MongoDBMongoDB is a famous representative of NoSQL databases. It is a document-oriented database, which means that data will
11 Oct 2013 by ASP.NET Community
If you use the asp.net membership providers, having visual studio keep this sql database file around for deployment can sometimes be convenient.
11 Oct 2013 by ASP.NET Community
When working with an ASP.NET site that requires some sort of user authentication (almost every time, I'd say), we often need to establish our own
11 Oct 2013 by ASP.NET Community
In this article I will sharing how to bind with GridView control with Database and without database using Data Table.Bind GridView with DatabaseI
11 Oct 2013 by ASP.NET Community
A RadioButtonList can be used to select 1 option within several options. The item "Pizza with egg" is selected by default.   
11 Oct 2013 by ASP.NET Community
 ASP Repeater ControlThe Repeater control is used to display a repeated list of items that are bound to the control. The Repeater control may
11 Oct 2013 by ASP.NET Community
In this article I am explaining about how to show Loading... image using Update Progress at center of grid view. for  this article i have used North
11 Oct 2013 by ASP.NET Community
Basic Hard Coded Cascading MenusTechnically your menus won't need javascript to be utilized. Just some basic CSS that will help with everything and
11 Oct 2013 by ASP.NET Community
Providers factory provides us indepandent database access where we can connect to any database sources(SQLServer,DB2,Oracle,MS-Access).Provider
11 Oct 2013 by ASP.NET Community
Following is an example of creating a transaction when require to save on many tables at once. I used Microsoft Enterprise Libraries. I assume one to
11 Oct 2013 by ASP.NET Community
Stored Procedure should look like thisCREATE PROCEDURE [dbo].[Purchases_Insert]    (@SupplierID     bigint,     @ReferenceNo     NVARCHAR(20),    
11 Oct 2013 by ASP.NET Community
DAL Should like following when inserting a image. I used the Enterprise Library to data access. Data type of EmployerImage is image @ SQL Server
11 Oct 2013 by ASP.NET Community
Open SQL Server and open a database (Already created) . On the Storage section find the Full Text Catalog. Right click and create a New
13 Mar 2016 by Zohaib Sibte Hassan
A more detailed look into Iterators and Snapshots in LevelDB UWP
13 Aug 2018 by Member 13935194
In this article, I will demonstrate how to integrate Firebase phone number authentication in Laravel.
2 Jun 2022 by William Lyon
GraphQL APIs, backed by Neo4j – a native graph database – enable complex relationships to be easily modeled, queried, and resolved. That could be a boon for newsrooms where usually nothing comes easily.
25 Oct 2014 by Marc Clifton
No word has a value that can be identified independently of what else is in its vicinity.
19 Aug 2019 by koolprasadd
SQL 2017 new features
15 Feb 2013 by Michael Haephrati
The DataTune system was one of the earliest data cleansing systems.
8 Dec 2015 by Jovan Popovic(MSFT)
Overview of built-in support for JSON text processing in new SQL Server
11 Apr 2016 by VijayRana
MongoDB Tutorial - MongoDB specific queries
20 May 2010 by Evoluteur
A step wizard for ASP.NET to export database objects to CSV, TXT, HTML, XML, or SQL
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...
18 Mar 2021 by VijayRana
A tutorial for MongoDB Tutorial
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.
10 Oct 2013 by Mehdi Gholam
Even faster Key/Value store nosql embedded database engine utilizing the new MGIndex data structure with MurMur2 Hashing and WAH Bitmap indexes for duplicates. (with MonoDroid support)
1 Mar 2015 by mbarbac
A deep dive into the Kerosene ORM Entity Maps operational mode that provides full real support for POCO objects.
18 Apr 2016 by VijayRana
Performance - Indexing in MongoDB
8 Mar 2012 by Manjuke Fernando
Locks and duration of transactions in SQL Server
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.
8 Aug 2012 by CodeProject, DBNess
Welcome to our continuing series of Code Project interviews in which we talk to developers about their backgrounds, projects, interests and pet peeves. In this installment we talk to Vanessa Hurst, founder of Developers for Good, co-founder of Girl Develop It!, and a consultant and advisor to startu
5 Jun 2013 by Rajat Bittharia
Grid based on JSON data using MVC with Entity Framework and MySQL.
2 Apr 2014 by Anand Gunasekaran
Working with text file as database can querying as RDBMS with SQL Queries.
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
16 Oct 2014 by Pavel Durov
Article about dynamic Sqlite database management on Android platform using Java class reflection.
1 Mar 2015 by mbarbac
A deep dive tutorial on Kerosene ORM Dynamic Records and other core concepts of the library
14 Sep 2015 by nam1234567
Build your own database class library with C#
4 Jan 2023 by Bert O Neill
Features and functionalities associated with Autogenerate DB Unit Test app
24 Apr 2019 by QxOrm
QxOrm C++ library: Persistence (based on QtSql Qt library) - Serialization (based on boost::serialization library) - Reflection (introspection)
18 Oct 2017 by Mauricio David
A simple, fast and free embedded .NET NoSQL Document Store in a single data file. Inspired on MongoDB, supports collections, POCO classes, Bson Documents, indexes, stream data and LINQ expressions.
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
23 Aug 2016 by Suvendu Shekhar Giri
Introduction of new useful features in SSMS 2016
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.
15 Sep 2014 by DiponRoy
Some queries to find generation of each row, all possible children, all possible parents, managing recursion
25 Jul 2012 by Wusheng Hu
This article tries to fit all levels of readers by covering both basic database concept and practical tips for handling Entity Framework.
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.
5 Apr 2021 by Vadim Loboda
A way to persist C# object graph to database with single procedure using ADO.NET and table valued parameters
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.
13 Mar 2013 by Chia-MingLiang
A NoSQL-like document store in JSON format.
30 Nov 2013 by DaveAuld
Too much data is breaking the system, we need a fix!
22 Jun 2013 by Adam Tibi
A typical implementation of a CQRS pattern ASP.NET MVC 4, Ninject and MongoDB. I will be demonstrating a sample applications that acts as a base building block for a CQRS-based architecture.
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.
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.
21 May 2016 by VijayRana
Aggregation in MongoDB
27 Jun 2021 by Evgeniy Gribkov
The examples of SQL Server database documentation using both the extended properties and a third-party utility.
31 Dec 2010 by Manan J
Arrange Results to get the most relevant result first...
11 Oct 2013 by ASP.NET Community
If you use the asp.net membership providers, having visual studio keep this sql database file around for deployment can sometimes be convenient.
11 Oct 2013 by ASP.NET Community
When working with an ASP.NET site that requires some sort of user authentication (almost every time, I'd say), we often need to establish our own
11 Oct 2013 by ASP.NET Community
In this article I will sharing how to bind with GridView control with Database and without database using Data Table.Bind GridView with DatabaseI
11 Oct 2013 by ASP.NET Community
A RadioButtonList can be used to select 1 option within several options. The item "Pizza with egg" is selected by default.   
11 Oct 2013 by ASP.NET Community
 ASP Repeater ControlThe Repeater control is used to display a repeated list of items that are bound to the control. The Repeater control may
11 Oct 2013 by ASP.NET Community
In this article I am explaining about how to show Loading... image using Update Progress at center of grid view. for  this article i have used North
11 Oct 2013 by ASP.NET Community
Basic Hard Coded Cascading MenusTechnically your menus won't need javascript to be utilized. Just some basic CSS that will help with everything and
11 Oct 2013 by ASP.NET Community
Providers factory provides us indepandent database access where we can connect to any database sources(SQLServer,DB2,Oracle,MS-Access).Provider
11 Oct 2013 by ASP.NET Community
Following is an example of creating a transaction when require to save on many tables at once. I used Microsoft Enterprise Libraries. I assume one to
11 Oct 2013 by ASP.NET Community
Stored Procedure should look like thisCREATE PROCEDURE [dbo].[Purchases_Insert]    (@SupplierID     bigint,     @ReferenceNo     NVARCHAR(20),    
11 Oct 2013 by ASP.NET Community
DAL Should like following when inserting a image. I used the Enterprise Library to data access. Data type of EmployerImage is image @ SQL Server
11 Oct 2013 by ASP.NET Community
Open SQL Server and open a database (Already created) . On the Storage section find the Full Text Catalog. Right click and create a New
13 Mar 2016 by Zohaib Sibte Hassan
A more detailed look into Iterators and Snapshots in LevelDB UWP
13 Aug 2018 by Member 13935194
In this article, I will demonstrate how to integrate Firebase phone number authentication in Laravel.
2 Jun 2022 by William Lyon
GraphQL APIs, backed by Neo4j – a native graph database – enable complex relationships to be easily modeled, queried, and resolved. That could be a boon for newsrooms where usually nothing comes easily.
25 Oct 2014 by Marc Clifton
No word has a value that can be identified independently of what else is in its vicinity.
19 Aug 2019 by koolprasadd
SQL 2017 new features
15 Feb 2013 by Michael Haephrati
The DataTune system was one of the earliest data cleansing systems.
8 Dec 2015 by Jovan Popovic(MSFT)
Overview of built-in support for JSON text processing in new SQL Server
11 Apr 2016 by VijayRana
MongoDB Tutorial - MongoDB specific queries
20 May 2010 by Evoluteur
A step wizard for ASP.NET to export database objects to CSV, TXT, HTML, XML, or SQL
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...
18 Mar 2021 by VijayRana
A tutorial for MongoDB Tutorial
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.
10 Oct 2013 by Mehdi Gholam
Even faster Key/Value store nosql embedded database engine utilizing the new MGIndex data structure with MurMur2 Hashing and WAH Bitmap indexes for duplicates. (with MonoDroid support)
1 Mar 2015 by mbarbac
A deep dive into the Kerosene ORM Entity Maps operational mode that provides full real support for POCO objects.
18 Apr 2016 by VijayRana
Performance - Indexing in MongoDB
8 Mar 2012 by Manjuke Fernando
Locks and duration of transactions in SQL Server
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.
8 Aug 2012 by CodeProject, DBNess
Welcome to our continuing series of Code Project interviews in which we talk to developers about their backgrounds, projects, interests and pet peeves. In this installment we talk to Vanessa Hurst, founder of Developers for Good, co-founder of Girl Develop It!, and a consultant and advisor to startu
5 Jun 2013 by Rajat Bittharia
Grid based on JSON data using MVC with Entity Framework and MySQL.
2 Apr 2014 by Anand Gunasekaran
Working with text file as database can querying as RDBMS with SQL Queries.
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
16 Oct 2014 by Pavel Durov
Article about dynamic Sqlite database management on Android platform using Java class reflection.
1 Mar 2015 by mbarbac
A deep dive tutorial on Kerosene ORM Dynamic Records and other core concepts of the library
14 Sep 2015 by nam1234567
Build your own database class library with C#
4 Jan 2023 by Bert O Neill
Features and functionalities associated with Autogenerate DB Unit Test app
24 Apr 2019 by QxOrm
QxOrm C++ library: Persistence (based on QtSql Qt library) - Serialization (based on boost::serialization library) - Reflection (introspection)
18 Oct 2017 by Mauricio David
A simple, fast and free embedded .NET NoSQL Document Store in a single data file. Inspired on MongoDB, supports collections, POCO classes, Bson Documents, indexes, stream data and LINQ expressions.
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
23 Aug 2016 by Suvendu Shekhar Giri
Introduction of new useful features in SSMS 2016
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.
15 Sep 2014 by DiponRoy
Some queries to find generation of each row, all possible children, all possible parents, managing recursion
25 Jul 2012 by Wusheng Hu
This article tries to fit all levels of readers by covering both basic database concept and practical tips for handling Entity Framework.