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: database
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....
9 Commands Cheat sheet Firestore Firebase
Here are the basic commands or cheat sheets for Firestore on Firebase for React Native, these are made to make it easier as a reference for coding and teaching training. 1. Add firebase library...
Extract one table from mysqldump backup file
Starting from the difficulties I experienced, when I wanted to retrieve a table from a large mysqldump backup file… which was around 500mb and above, while the conventional method was too time-consuming even though...
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...
Fabrik Joomla Component : Cheet Sheet Sample Code
Fabrik is one of the components in the Joomla CMS, the usefulness of the Fabrik component is a tool to easily create web applications. With Fabrik it is very easy to create forms and...