Click here to Skip to main content

Submit your article

MySQL

MySQL

Great Reads

Ultra-Rapid PHP Application Development

by Christoph Buenger

Describes PHP application development with the free Scavix Web Development Framework (Scavix-WDF).

Nullable datetime column in .NET DataGrid with DateTimePicker

by vic_ch2000

A nullable datetime column in .NET DataGrid with DateTimePicker.

Ask Your Database for that Unique ID

by Peter Leow

Get your database to generate unique running IDs for your application

Email Search Engine

by SarmadAsghar

Building on My SQL Storage Engines and APIs to Conduct Complex Analysis Using SQL Query Language: Part 5

Latest Articles

StatefulSets and Deployments in Kubernetes

by Trần_Tuấn_Anh

Kubernetes has revolutionized the way we manage containerized applications, providing robust tools to deploy, scale, and manage workloads. Two critical resources in Kubernetes for managing applications are Deployments and StatefulSets.

Decouple ASP.NET Core Identity, Authentication and Database Engines

by Zijian

Reusable codes for OAuth security in business applications

Using IDistributed Cache with EF Core

by Bert O Neill

In this article, I provide a detailed overview of using IDistributed Cache to improve the performance of your EF Core queries, against On-Premise caching systems like Redis, NCache, SqlCache, MySqlCache, MongoDBCache and API Output caching.

Deploy MySQL and WordPress on an always free tier Arm shape

by Frédéric -lefred- Descamps

How to install WordPress on Oracle Cloud Infrastructure (OCI) using always free tier

All Articles

MySQL

Ultra-Rapid PHP Application Development

31 Oct 2014 by Christoph Buenger

Describes PHP application development with the free Scavix Web Development Framework (Scavix-WDF).

Nullable datetime column in .NET DataGrid with DateTimePicker

17 Aug 2009 by vic_ch2000

A nullable datetime column in .NET DataGrid with DateTimePicker.

Email Search Engine

11 Jan 2015 by SarmadAsghar

Building on My SQL Storage Engines and APIs to Conduct Complex Analysis Using SQL Query Language: Part 5

Brief Introduction of a Continuous SQL-stream Sending and Processing System (Part 2: MySQL)

4 Apr 2021 by Yuancai (Charlie) Ye

Continuous SQL-stream Sending and Processing System

Decouple ASP.NET Core Identity, Authentication and Database Engines

12 Jul 2024 by Zijian

Reusable codes for OAuth security in business applications

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.

How to Setup Master-Slave Replication in MySQL using CentOS

24 Nov 2017 by Renz Ladroma

How to Setup Master-Slave Replication in MySQL using CentOS

Controlling Service Startup Order in Docker Compose

20 Mar 2023 by Bogdan Marian

Ensure your Docker Compose services start in the correct order

Geolocalize a Device and Store Coordinates on Webserver

19 Jun 2015 by Emiliano Musso

Geolocalize a device and store coordinates on webserver

Software Developers are lazy but smart, that's why we RAD: The PHP.Show Concept

8 Oct 2015 by Anele 'Mashy' Mbanga

A look at a flexible Java MySQL CRUD PHP script generator

Connecting MySQL From SilverLight With Web Services

8 Aug 2013 by adriancs

Silverlight access to MySQL using Web Services.

Cross of Fields in a Table of Database Accessible via PDO

22 Sep 2022 by Member 4206974

CrossData is a PHP object for creating an HTML table or a PHP array, crossing two fields of a table from a PDO accessed database.

MySqlExpress - Simplifies the Usage of MySQL in C#/.NET

7 Dec 2022 by adriancs

Accelerate the Development with MySQL in C#

Message Manager

8 Feb 2012 by ebrahim amini sharifi

Sending and receiving message, user authentication, user permission, priority message

CRUD Operation by MySqli procedural way in PHP

14 Feb 2015 by BD Star

Create-Read-Update-Delete(CRUD) operation by MySQLi procedural way in the PHP

Auto-Generated visual basic source code from SQL

7 May 2015 by Mr. xieguigang 谢桂纲

You see, this small utility tool save much of your time, this is another happy day! I hope you can enjoyed this code.

Using JdbcTemplate in a Spring Boot Web Application

3 Dec 2018 by Han Bo Sun

In this tutorial, I will introduce the use of Spring JdbcTemplate in a Spring Boot web application. This tutorial will show how to create the necessary configuration for JdbcTemplate. And how it can be used for data insertion and retrieval.

Create And Deploy Your Own Image Classification Engine Using Clarifai API for Node.js

31 May 2019 by Arthur V. Ratz

The readers of this article will find out how to use Clarifai API for Node.js to create and deploy a lightweight vehicles images classification web-application.

22 Aug 2017 by JUST_Neeraj

A Simple Messaging\ Workflow \ETL system on MySQL and .NET

Automatic Compilation and Distribution of Reports and Analyses

3 Feb 2023 by JBartlau

This article demonstrates how Report Server offers a distribution of reports that save time, increase efficiency, and reduce potential errors.

data-visualization

Checksum Verification

22 Sep 2011 by smoore4

Loop through all files in a folder/subfolders and run a checksum that is stored in a database. E-mail descrepancies and results.

Using MySQL as the Model Store with ASP MVC in Azure

18 Sep 2015 by Kurt Friedrich

I wanted to use MySQL as the database to hold code first models with ASP MVC.

Running a Standalone PHP App in Windows

19 Mar 2023 by Michael Chourdakis

Portable nginx+php+mysql inside Windows

A Node.js Web Application Security Using Passport, Express-Sessions, JSON Web Tokens, Angular.js And MySQL

2 Feb 2020 by Arthur V. Ratz

A Simple Web Application User Authentication Project using Passport.js And JSON Web Tokens (JWT) explained

Microsoft Visual Studio LightSwitch Business Application Development

28 Nov 2011 by Member 7656529

A review of the book Microsoft Visual Studio LightSwitch Business Application Development.

Bind jQuery Chart to MySql Database using PHP

5 Mar 2012 by jqwidgets

How to connect our jQuery Chart to MySql Database using PHP

Hibernate - Many to Many Mapping via Join-Table

4 Jan 2016 by Han Bo Sun

Detailed description of how many-to-many association works with Hibernate, using MySQL and Spring

MySQL Auto Failover using Keepalived on CentOS

5 Dec 2019 by Renz Ladroma

A tutorial on how to setup Keepalived for MySQL Auto Failover

How To Install MySQL on CentOS 8

3 Feb 2022 by adriancs

Step by step guide for installing MySQL on CentOS

Extending the Kubernetes API

3 Dec 2019 by Packt Publishing

Best practices in Kubernetes

Using CURSOR in Different Databases

27 May 2019 by DiponRoy

Creating or using cursor in SQL-Server, Oracle, MySQL, PostgreSQL databases

Monitoring Group of Linked SQL Servers from a SQL Server

24 Jun 2009 by Kuldip Rindani

Monitoring group of Linked SQL Servers from a SQL Server

SQL-server-2000

Infobright/MySQL Statistics Utility

6 Jun 2012 by Ryan Krage

Display Infobright/MySQL Database Statistics in Java

Cross-Solution Microsoft Identity for Java Developers Part 3: Using MSAL to Access Azure APIs

20 Oct 2021 by Matthew Casperson

In this article, Using MSAL to Access Azure APIs, we use the OBO OAuth flow to call a service in Azure. Then, we’ll communicate the results back to the frontend application via a shared database.

Backup & Restore MySQL database on CentOS (Linux/Ubuntu) in C# with MySqlBackup.NET

3 Feb 2022 by adriancs

Building a .NET Core Linux Project with MySqlBackup.NET

Development and GDPL Review of a Web Searching Request Platform of Personal Data

10 Nov 2022 by André Marcos (Advisor), Thiago de Oliveira Lima, William Pereira de Souza

This web-based tool aims to facilitate the location of a person's data through their basic references information.

Session Management using MySQL and Spring Boot

29 Apr 2021 by Han Bo Sun

This tutorial will discuss an advanced configuration to use MySQL database as the session management.

Using IDistributed Cache with EF Core

10 Jul 2024 by Bert O Neill

In this article, I provide a detailed overview of using IDistributed Cache to improve the performance of your EF Core queries, against On-Premise caching systems like Redis, NCache, SqlCache, MySqlCache, MongoDBCache and API Output caching.

Deploy MySQL and WordPress on an always free tier Arm shape

12 Apr 2024 by Frédéric -lefred- Descamps

How to install WordPress on Oracle Cloud Infrastructure (OCI) using always free tier

MySQL XML User Defined Functions

7 Apr 2010 by BarrySolomon

Support for Reading XML in MySQL

Duplicate a Record in MySql Table with Auto Increment Key

27 Jul 2012 by Kourosh K Tari

How to duplicate a record in MySQL table with auto increment key

Lightening Fast Troubleshooting for Your Cloud Applications

6 Mar 2013 by Jon Rooney

Lightening Fast Troubleshooting for Your Cloud Applications

product-showcase

Visual Basic Using Reflection to Map DataTable in MySQL Database

5 Sep 2013 by Mr. xieguigang 谢桂纲

Easy way to map the table in the mysql database.

Using EF Core with MySQL in DotNet Core 1.0

2 Dec 2017 by Siddharth R Barman

Interact with MySQL database using EF Core in DotNet Core 1.0.

entity-framework

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.

Automate Database Backups with Customizable Recurring Schedules

1 Jul 2020 by Hariprasanth S

A CLI to automate database backups with customizable recurring schedules

Manually Install MySQL on Windows Without Using MySQL Installer

22 Nov 2023 by adriancs

A quick walkthrough of manually installing MySQL on Windows without use of MySQL installer.

Audio-Gallery-Suite (A complete audio gallery solution made with HTML5/CSS3/jQuery-JS/PHP/C#)

30 Apr 2013 by Robin Rizvi

Audio-Gallery-Suite is a complete audio gallery solution made with HTML5/CSS3/Jquery-JS/PHP-Ajax/C# that includes a web audio gallery and a software for managing the web audio gallery.

Mo+ - A model oriented programming language and IDE for model oriented development

21 Mar 2017 by Dave Clemmer

Mo+ is the first technology that fully supports model oriented development, allowing software developers to powerfully scale the work they already do.

code-generation

Minimalist Meta-Model for CRUD Applications

28 Dec 2011 by Evoluteur

A look at the minimal metadata needed (database mapping and user interface) for generic CRUD applications using the example of a to do list.

Using an Access, MySQL, PostgreSQL or SQLite Database from VBA

16 Jan 2018 by Pragmateek

Using an Access, MySQL, PostgreSQL or SQLite Database from VBA

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.

How to Handle Appointments and Send Automated Reminder Calls using PHP and your MySQL Database

30 Oct 2013 by Simon Robert VoIP

This article presents a simple example on how to insert automated reminders about appointments, meetings to MySQL table with the help of PHP

Visual Representation of SQL Joins

3 Feb 2009 by C.L. Moffatt

This article describes SQL Joins in a visual manner, and also the most efficient way to write the visualized Joins.

SQL-Server-2005

SQL-server-2000

HowTo: Install the Northwind and Pubs Sample Databases in SQL Server 2008 Express

18 Oct 2013 by Brian C Hart

To save you from hunting through the docs and locating downloads, we gather both databases here and walk you through installing them using SQL Server Management Studio Express -- updated for SQL Server 2008 Express Edition!

SQL-Server-2005

SQL-server-2000

A Natural Language Processing Engine (NLP) for Chatbots In Node.js, JavaScript/jQuery, HTML5, CSS, MDBootstrap4, Angular2 and MySQL

30 Jan 2024 by Arthur V. Ratz

Create and deploy a rule-based NLP engine

Beginner's Guide to HTML5 & CSS3 - Server Side Story

15 Nov 2014 by Peter Leow

A bridging introduction to server-side scripting.

Kerosene Dynamic Data Services

11 Mar 2014 by mbarbac

Implementing the Repository and Unit of Work Patterns dynamically using Kerosene ORM

Making a Search Engine

3 May 2013 by kburman6

This article discusses the making of a search engine.

Internet of Things: Programming IoT Devices, Web Services and IoT Clients

13 Jan 2015 by Naren Neelamegam

A complete walk through on IoT Device programming, Web Service programming and IoT Client programming.

microcontroller

Create a div based grid functioning on JSON data using MVC with Entity Framework and MySQL

5 Jun 2013 by Rajat Bittharia

Grid based on JSON data using MVC with Entity Framework and MySQL.

Distributed Transaction between Microsoft SQL Server and MariaDB - A Myth

23 Oct 2013 by BharatRamV

Distributed transaction between MS SQL Server and MariaDB - A myth.

SQL-Server-2008

GUIDs as fast primary keys under multiple databases

15 Mar 2013 by Jeremy Todd

Using the right approach can make GUIDs nearly as fast as integer primary keys on almost any database system.

Connecting to MySQL from Visual C#

20 Mar 2014 by Lizandro Campbell

Using Visual C# 2008 to establish connection to a MySQL 5.1 database with MySQL Connector/NET 5.1.7

stored-procedure

MySQL-Connector

Writing a MySQL Storage Engine from Scratch

19 Jun 2016 by cruppstahl

Describes how to write a MySQL storage engine - a plugin which is responsible for persisting MySQL table data.

A propertymapping Extension for DataReaders

26 Jan 2016 by Jörgen Andersson

A propertymapping extension for DataReaders

Custom Fluent Nhibernate Membership and Role Provider

12 Aug 2012 by Suhel Shah

Custom implementation of Microsoft Membership and Role provider using Fluent Nhibernate

Infobright/MySQL Statistics Utility (C++)

24 Jul 2012 by Ryan Krage, Binfeng Yuan

Display Infobright/MySQL Database Statistics in C++

Return DataTable And Using Entity Framework

5 Apr 2020 by DiponRoy

Select data as DataTable object for a database using Entity Framework

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

MySQL Database Backup Utility

6 Jun 2010 by Wayne Gaylard

A class to generate a complete backup of a MySQL database.

MySQL-Fullltext: Start for a Simple Search-engine using MySQL

8 Sep 2013 by Winfried Wille

MySQL-Fullltext: Start for a simple search-engine using MySQL C-API, WCF, and jQuery

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)

Extending Kerosene ORM for WCF support

2 Mar 2015 by mbarbac

Kerosene ORM support for complete database-alike WCF services and connections

PHP A to Z

25 Jun 2013 by Gazmend Jakupi

Tutorial for developing in PHP

Building on My SQL Storage Engines and APIs to Conduct Complex Analysis Using SQL Query Language: Part 3

16 Jul 2014 by SarmadAsghar

Junk Drawer

7 Mar 2016 by dale.newman

Importing Excel & Delimited Files into a Junk Database

Insert, Update, Search and Delete (CRUD operation) using ASP.Net and MySQL

17 Aug 2012 by AmitGajjar

Create, Read, Update and Delete operations in ASP.Net with MySQL database with N-Tier Architecture

web_development

Building a Framework - Part I (DAL)

5 Feb 2014 by V.

First article on creating a reusable framework

MySqlBackup.NET - MySQL Backup Solution for C#, VB.NET, ASP.NET

24 Sep 2021 by adriancs

A tool to export and import MySQL database in .NET

Joining Tables in SQL

3 Apr 2013 by Pierre Kellerman

Explaining different ways to join tables

Membership and Role providers for MySQL

20 Dec 2005 by Rakotomalala Andriniaina

This article provides two files that contain a Membership Provider and a Role Provider for ASP.NET v2.0.

MySQL Schema in C#

18 Jan 2004 by Rajib Bahar

An article on HOW-TO grab MySQL schema in C#. This program utilizes ODBC API.

MySQL User Defined Functions

20 Sep 2006 by DarkLizener

Tutorial on writing your own MySQL User Defines Functions

How to : Using PHP Fusion 7 CAPTCHA

12 Feb 2009 by Mohammad Dayyan

Shows you how using PHP Fusion 7 CAPTCHA class

Audit Trail – Tracing Data Changes in Database

30 Aug 2010 by Petr Kozelek

Logging of data changes in relational databases

How to Access web-server MySQL Database in Java?

23 Mar 2016 by rohit7209

Use AccessRemoteMySQLDB-API in your project to access web-server MySQL database

MySQL-Connector

Emoji and web application

27 Nov 2013 by Tharaka MTR

Emoji; is the Japanese term for the ideograms or smileys used mostly in Japanese electronic messages and webpages.

1 Jun 2016 by icemanind

Automatically generate Business and Data layers in C# or VB.Net from a SQL Server, Microsoft Access, MySql or SQLite database design.

Connecting to MySQL Database using C# and .NET

7 Apr 2010 by User 992674

This article shows you how to connect to MySQL database using MySQL Connector for .NET

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

Tracing SQL Queries in Real Time for MySQL Databases using WinDbg and Basic Assembler Knowledge

3 Nov 2011 by Rene Pally

Assembly and MySQL

Coding with Klocwork: A Dev Perspective

6 Mar 2015 by Chris_Riley

Klocwork is kind of like my code spell check, or professional editor. It just makes me sound good. And if I were part of a larger dev team it would be quite a powerful management tool.

RESTGrid

18 Mar 2019 by JUST_Neeraj

A simple Workflow\ETL system in .NET Core which uses REST services to interact with the outside world

Integrating Full Text Search to Spring MVC with Hibernate

17 Oct 2014 by Han Bo Sun

In this article, I will show you how to integrate Hibernate Search into a simple yet feature complete web application with the Spring MVC and Hibernate enabled.

Repository Pattern using Dependency Injection (Autofac) in MVC application

19 Nov 2014 by Akshit Rana

In this article, I will explain how to implement Respository pattern and how to enable dependency injection feature to your MVC Application.

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.

Accessing: MySQL Database using MySQL C API

1 Nov 2011 by Renato Tegon Forti

A set of class to access and manipulate MySQL database using MySQL C API

Using User Defined Functions in Table Inserts and Seeding with Stored Procedures

26 Aug 2009 by Andy_L_J

Generate unique column values using UDFs and Stored Procedures

SQL-Server-2008

SQL-Server-2005