Ahmed Bouchefra: Django 3 Tutorial & CRUD Example with MySQL and Bootstrap

Django 3 is released with full async support! In this tutorial, we’ll see by example how to create a CRUD application from scratch and step by step. We’ll see how to configure a MySQL database, enable the admin interface, and create the django views. We’ll be using Bootstrap 4 for styling. You’ll learn how to: Implement CRUD operations, Configure and access a MySQL database, Create django views, templates and urls, Style the UI with Bootstrap 4 Django 3 Features Django 3 comes with many new features such as: MariaDB support:…

Read More
Programming 

MongoDB vs. MySQL: How to choose

During the dot-com bubble in the 1990s, one common software stack for web applications was LAMP, which originally stood for Linux (OS), Apache (web server), MySQL (relational database), and PHP (server programming language). MySQL was the preferred database mostly because it was free open source and had good read performance, which fit well with “Web 2.0” apps that dynamically generated sites from the database. To read this article in full, please click here (Insider Story)

Read More

MySQL CURRENT_TIMESTAMP() Function

This tutorial explains how to use the MySQL CURRENT_TIMESTAMP() function with the help of examples. By using it, you can convert or display the current date and time. The output format is either ‘YYYY-MM-DD HH:MM: SS’ format or YYYYMMDDHHMMSS, which depends on the context of the calling function, whether it is numeric or string. The function NOW() and CURRENT_TIMESTAMP() are equivalent of the CURRENT_TIMESTAMP. Please note that examples shown here will give results depending upon the present date. MySQL CURRENT_TIMESTAMP() This function provides a date and time value formatted in…

Read More

How to Emulate PERCENTILE_DISC in MySQL and Other RDBMS

In my previous article, I showed what the very useful percentile functions (also known as inverse distribution functions) can be used for. Unfortunately, these functions are not ubiquitously available in SQL dialects. As of jOOQ 3.11, they are known to work in these dialects: Dialect As aggregate function As window function MariaDB 10.3.3 No Yes Oracle 18c Yes Yes PostgreSQL 11 Yes No SQL Server 2017 No Yes Teradata 16 Yes No Oracle has the most sophisticated implementation, which supports both the ordered set aggregate function, and the window function…

Read More

MySQL Create User with Password

This tutorial explains how to create a user with password in MySQL. We’ll use the MySQL Create User command and describe it with the help of examples. By using this command, you can introduce a new user and grant him/her the required permissions or rights. Usually, you might be using the root user to access a database. The root user has complete control and can’t be restricted. Hence. It is mandatory to create users depending on the type of access s/he needs. And that’s where this command is going to…

Read More