Ozar Blog

News, Announcements & Tutorials

How to Drop All Tables of a MySQL / MariaDB Schema At Once

Bypassing the foreign key restrictions

published on 7 Jan 2024 in Databases Database Development

Dive into our tutorial for a seamless approach to dropping tables in MySQL/MariaDB schemas. From command-line intricacies to scripted solutions, manage foreign-key constraints effortlessly. Safeguard your data with proper backups, ensuring a trouble-free database management experience.

Data Modeling Capabilities of Navicat in Action

A UML-Like Design-First Approach

published on 1 Jan 2024 in Databases Database Design and Development

Navicat comes with an incredibly responsive and elegant user interface design with improved usability, and it has been enabling users to get a visually appealing and semantically precise data models from their databases for almost a decade now.Released in November 2019, Navicat 15 (and Data Modeler 3.0) has some nice surprises in store, with an even more improved data modeling capability. You can now design generic data models and then convert them for a specific database platform.

A Step-by-Step Tutorial for a CI3-toCI4 Upgrade

How to Migrate a CodeIgniter 3 Web App to CodeIgniter 4

A Step-by-Step Tutorial for a CI3-toCI4 Upgrade

published on 9 Jul 2023 in CodeIgniter PHP

Explore the step-by-step migration process from CodeIgniter3 to CodeIgniter4, touching upon controllers, models, views, and routes. The tutorial also introduces the CodeIgniter Wizard, a significant time-saving tool for Mac users that automates CI4 code generation through reverse-engineering of existing databases, streamlining the migration process.

Understanding the Fundamental Concepts of Data Models of CI4

The Difference Between Entities and Models in CodeIgniter4.x

Understanding the Fundamental Concepts of Data Models of CI4

published on 26 Mar 2023 in CodeIgniter PHP

In many popular programming frameworks that use the Model-View-Controller (MVC) paradigms and are database-driven using an Object-Relational Mapping (ORM) system, entities and models are considered to be interchangeable terms referring to a class that represents a data entity in the database. However, CodeIgniter 4.x introduces a clear separation between entities and models - using two separate classes.

CodeIgniter Wizard 2 updated with features better than ever

CodeIgniter Wizard 2 Is Here

With Long Awaited New Features Like Auth, File Uploads, I18n, Data Export, and More...

published on 3 Sep 2022 in CodeIgniter Web Development PHP Mac Apps

CodeIgniter Wizard 2.0.2 has been released with a large number new features added to the application, the time needed for demos increased at least ten-fold. Authentication & authorization, secure file uploads for the end user, automatic image resizing post-uploads, language localization and translation in the GUI with the ability to add unlimited number of languages and locales. Also subtle features such as auto-generation of slugs, UUIDs for primary keys, and more...