Click here to Skip to main content
14,970,700 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
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 David Wincelberg
Strings that differ by typos can be matched.
by DaveNoderer
In this article, we explore how to set up one component, an SQL pool.
by Evgeniy Gribkov
The examples of SQL Server database documentation using both the extended properties and a third-party utility.
by Private Dobbs
How to initialise a database and then automatically keep it up to date with version releases

All Articles

Sort by Score

Database Development 

Please Sign up or sign in to vote.
16 Oct 2017
Nikola M. Živković
Introduction to NoSQL and Polyglot Persistence
Please Sign up or sign in to vote.
22 Oct 2014
essentialSQL
Database normalization in SQL explained in simple English
Please Sign up or sign in to vote.
29 Dec 2016
essentialSQL
Introduction to cross join - create row combinations
Please Sign up or sign in to vote.
27 Jun 2016
Val Okafor
Realm Database Tutorial For Android – Part 1
Please Sign up or sign in to vote.
3 Nov 2014
essentialSQL
Database Third Normal Form explained in simple English
Please Sign up or sign in to vote.
19 Jan 2016
essentialSQL
How to Write SQL – Understand Database Table Meanings and Relationships – Step 1
Please Sign up or sign in to vote.
21 Oct 2014
essentialSQL
Database Second Normal Form explained in simple English
Please Sign up or sign in to vote.
7 Sep 2015
Sander Rossel
The seventh in a series on MEAN web development.
Please Sign up or sign in to vote.
22 Oct 2014
essentialSQL
How to combine table rows using UNION in SQL Server
Please Sign up or sign in to vote.
24 Oct 2014
essentialSQL
How to sort your query results in SQL Server
Please Sign up or sign in to vote.
14 Dec 2015
Steve Naidamast
The technical management of relational databases is a highly mature technology in the software development profession.
Please Sign up or sign in to vote.
17 Jul 2016
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
Please Sign up or sign in to vote.
26 Jul 2017
Alvin Bunk
Symfony: Connecting to External Database
Please Sign up or sign in to vote.
24 Jan 2018
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").
Please Sign up or sign in to vote.
29 Jan 2011
Gilly Barr
Join on tables using Fluent NHibernate
Please Sign up or sign in to vote.
5 Mar 2011
Gilly Barr
Fluent NHibernate - Working with Database Views
Please Sign up or sign in to vote.
13 Apr 2013
Shahriar Iqbal Chowdhury/Galib
TSQL split a string by delimiter
Please Sign up or sign in to vote.
15 Jun 2014
Right Handed Monkey
MySQL Database Performance Diagnostics - Where to start?
Please Sign up or sign in to vote.
14 Sep 2014
derekman9707
Different types of database backups
Please Sign up or sign in to vote.
31 Oct 2014
essentialSQL
How to use the Intersect Operator in SQL Server
Please Sign up or sign in to vote.
25 May 2017
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?
Please Sign up or sign in to vote.
8 Jun 2017
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 [...]
Please Sign up or sign in to vote.
12 Apr 2020
Jeremy Likness
Some ah-hah moments about Kusto
Please Sign up or sign in to vote.
16 May 2011
Andrew Zwicker
How to prevent duplicates in the data
Please Sign up or sign in to vote.
24 May 2011
Mel Padden
A script that analyzes the text of each individual object and builds a tree of what depends on what.
Please Sign up or sign in to vote.
24 May 2011
Mel Padden
From a utility I'm working on. Compatible with SQL-92 INFORMATION_SCHEMA views.
Please Sign up or sign in to vote.
25 May 2011
Andrew Zwicker
A discussion of how joins significantly outperform subqueries and how this is more evident when OR conditions are involved.
Please Sign up or sign in to vote.
22 Jul 2011
rusanu
How to Multicast messages with SQL Server Service Broker
Please Sign up or sign in to vote.
10 Apr 2012
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.
Please Sign up or sign in to vote.
29 Jan 2014
Rohitmssqlfun
Database snapshot failed due to disk space issue
Please Sign up or sign in to vote.
17 Mar 2014
Sharjeel_Ahmad
Working with Visual Basic database connection
Please Sign up or sign in to vote.
24 May 2014
Debopam Pal
Oracle Database Table to JAVA Bean Class Converter
Please Sign up or sign in to vote.
25 May 2014
Debopam Pal
Oracle database table to Java Beans Class Converter
Please Sign up or sign in to vote.
15 Jun 2014
Right Handed Monkey
Android Database Example and Tutorial (thread safe version)
Please Sign up or sign in to vote.
13 Jun 2014
Right Handed Monkey
Introducing the WorxForUs Open Source Database & Network Helper for Android
Please Sign up or sign in to vote.
6 Oct 2014
Rajat-Indiandotnet
A Hidden Feature sp_MSforeachtable–Run on Entire Tables of a Database - TIP# 51
Please Sign up or sign in to vote.
6 Apr 2015
John Atten
A More Useful Port of the Chinook Database to Postgresql
Please Sign up or sign in to vote.
14 Dec 2015
Sacha Barber
This time we will proceed to look at using Scala to connect to SQL server.
Please Sign up or sign in to vote.
29 Mar 2019
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.
Please Sign up or sign in to vote.
3 Apr 2019
setevoy4
The redis-py library and work with Redis Sentinel from Python
Please Sign up or sign in to vote.
4 Dec 2016
Manjuke Fernando
It's very important to know what sort of JOINs are available in SQL Server and where exactly we can use them, in order to produce accurate results.
Please Sign up or sign in to vote.
16 Mar 2015
Sander Rossel
Getting your feet wet in NoSQL with MongoDB!
Please Sign up or sign in to vote.
20 Jan 2015
Gerd Wagner
Storing database tables in JavaScript's Local Storage
Please Sign up or sign in to vote.
21 Oct 2014
essentialSQL
Database First Normal Form explained in simple English
Please Sign up or sign in to vote.
3 Feb 2011
JasonShort
Here are 10 things to make your desktop database apps better
Please Sign up or sign in to vote.
11 Feb 2016
kevinfitzpatrick
Migrating a Project from Database First to Code First
Please Sign up or sign in to vote.
30 Jan 2013
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?
Please Sign up or sign in to vote.
24 Oct 2014
essentialSQL
Learn more about filtering results returned from your queries using the WHERE clause
Please Sign up or sign in to vote.
24 Oct 2014
essentialSQL
In today’s lesson, you’re going to learn how to filter the results returned from your queries using the WHERE clause.
Please Sign up or sign in to vote.
25 Oct 2014
essentialSQL
Simple SELECT queries in SQL Server
Please Sign up or sign in to vote.
16 Mar 2015
Sander Rossel
Using C# to get data in- and out of your (relational) database
Please Sign up or sign in to vote.
7 Aug 2017
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.
Please Sign up or sign in to vote.
7 Jul 2016
Gaston Verelst
What is the role of the database?
Please Sign up or sign in to vote.
29 Oct 2014
essentialSQL
In this lesson, you are going to explore how to do pattern matching with the SQL Where clause LIKE operator.
Please Sign up or sign in to vote.
13 Feb 2017
Val Okafor
A complete, step by step tutorial on working with Firebase Realtime Database in Android
Please Sign up or sign in to vote.
26 Feb 2014
JonB3232
Getting Started with NoSQL and MongoDB
Please Sign up or sign in to vote.
30 Mar 2016
Bryian Tan
Restore Database is terminating abnormally
Please Sign up or sign in to vote.
5 May 2015
Jasminder Singh
Onion architecture using MVC and database first approach
Please Sign up or sign in to vote.
2 Nov 2014
Ronnie Mukherjee
B-tree Indexes
Please Sign up or sign in to vote.
26 May 2015
Cindy Potvin
Saving an image in a SQLite database in your Android application
Please Sign up or sign in to vote.
29 Dec 2013
Sam Varadarajan
An introduction to SQLite.
Please Sign up or sign in to vote.
17 Apr 2011
andy404
Using Membase for ASP.NET Output Caching
Please Sign up or sign in to vote.
2 Jun 2015
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.
Please Sign up or sign in to vote.
11 May 2018
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.
Please Sign up or sign in to vote.
15 Jan 2014
Vivek Goyal
Prepared statements for database driven application
Please Sign up or sign in to vote.
23 May 2016
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 →
Please Sign up or sign in to vote.
23 May 2011
Andrew Zwicker
A discussion about SQL joins and subqueries with information about how to format join statements properly