Medium Cross-post – CodeIgniter 4 CRUD: Update

In some applications, data may never change. Yet, in others, data changes numerous times in its lifecycle. In SQL the UPDATE command changes existing rows of data. CodeIgniter 4 Models have 2 methods available for update operations: update() and save(). Continue reading and learn more about update()

(more…)

Medium Cross-post – CodeIgniter 4 CRUD: Read

Storing data is but one part of many in application development. Once data is stored, interested parties will likely want to see it. This is the Read aspect of CRUD – reading (or viewing) the data. Continue reading and see examples using CodeIgniter 4 built-in Model methods…

(more…)

Medium Cross-post: CodeIgniter 4 CRUD – Create

I’m studying and beginning to use CodeIgniter 4 in ‘real-world‘ projects and want to share what I learn, as I pick up on concepts of the framework. I’m posting a series of CRUD-related posts over on Medium and resharing them here for any readers who are interested…

(more…)

Create Table Structure From Existing Table in Oracle SQL

Do you need the same table structure as an existing table in your database, but empty of rows? Oracle SQL’s CREATE TABLE AS statement achieves this easily. Continue reading and learn how with a simple example…

(more…)

Export Query Results to CSV with SQL Developer

One of the most universal data interchange formats in the world is the CSV file. Data professionals use CSV’s without a thought. Equally, those not even in the ‘data field’ use CSV’s on a daily basis. Do you have the SQL query results for that report and need to share them in CSV format? Using the Oracle SQL Developer IDE, it is a breeze…

(more…)