What is the secure_file_priv Variable in MySQL?If you have ever dived deeper into the settings letting you unleash the full power of MySQL, you might already come across a couple of settings letting you perform a variety of different tasks – one of such settings is the secure_file_priv variable. ...Aug 23, 2022 · 3 min readarctype.hashnode.dev
How to Use SQL to Analyze And Visualize Data?The goal of every business is to perform efficiently, maximize profit and make strategically-guided decisions. In the current business world, the competition is high and every business needs every edge and advantage they can get to improve their odds...Aug 18, 2022 · 6 min readarctype.hashnode.dev
CHAR vs. VARCHAR: What’s the Difference?If you’ve found yourself in the MySQL space even for a little while, you already know that MySQL and other flavors of it offer a couple of data types for developers to choose from. A wide majority of the most popular data types offered by MySQL are r...Aug 16, 2022 · 6 min readarctype.hashnode.dev
MySQL’s UTF-8 Isn’t RealIf you are familiar with MySQL, you probably already know that it comes with multiple character encodings. One of the main encodings in the MySQL world and on the web in general is UTF-8 – it is used in almost every web and mobile application, and is...Aug 11, 2022 · 6 min readarctype.hashnode.dev
Building REST Endpoints with Knex and PostgreSQLWhat is Knex and PostgreSQL? Knex is a versatile, portable, and enjoyable SQL query builder for PostgreSQL, CockroachDB, MSSQL, MySQL, MariaDB, SQLite3, Better-SQLite3, Oracle, and Amazon Redshift, while PostgreSQL is an open-source object-relational...Aug 9, 2022 · 11 min readarctype.hashnode.dev
