React Native Expo SQLite local storage tutorial
In this post, we’ll look at how to use SQLite to store and persist data locally in our React Native and Expo apps. SQLite is supported by practically all mobile devices. To access it,...
Tagged: sql
What is MySQL DBMS?
About 100 million copies of the MySQL software have been downloaded or distributed during its lifetime, making it the most widely used open source database program in the world. Because MySQL solves key issues...
Dynamic pivot tables (transform rows to columns)
A pivot table in MySQL with dynamic headers. Assume we have a table of properties – ‘properties’ (script for its creation is provided below), and we need to do data transformation for the report....
SQL query optimization tips with index, subquery, and cross join
1. Use numeric data type as primary key or foreign key Often beginners will design tables using string types as keys, and this will result in future performance when the data is large, so...
PHP Joomla: Generate certificates with the mpdf library
The company I work for happens to have to issue various certificates to many users, it would be very tiring if I had to input user names one by one. By generating the certificate...
PHP: Creating Custom Feedback Forms in Joomla
There are various components provided by Joomla CMS to create forms, one of which is Fabric, but sometimes we also want to create our own custom forms for our own reasons, the form will...