Skip to main content

Sample Database in CI Wizard Demos Explained


In this video, the design of the sample relational database used throughout the demos of CodeIgniter Wizard is explained using an E-R diagram. Originally designed in Navicat (https://www.arclerit.com/navicat/?ref=YToperand) the E-R diagram shows the entities named 'countries', 'cities' and 'people' which are linked via foreign key definitions. The 'People' table contains about every kind of data column to demonstrate a use case for various data types, so the code generator happens to produce code for a variety of fields. To learn about the new features of CodeIgniter Wizard, you can view https://youtu.be/msSVRN5tY88 For an end-to-end, 9-minute demo, watch https://youtu.be/fo2wmzZ2p3I To take a closer look at what the generated code looks like, see https://youtu.be/6Gh1LU1pV-I APP STORE LINK https://apps.apple.com/app/codeigniter-wizard/id1531951619 PRODUCT WEB SITE https://www.ozar.net/products/codeigniterwizard/?ref=DAVElopment FAQ https://www.ozar.net/products/codeigniterwizard/faq/?ref= DAVElopment SOURCE CODE OF GENERATED WEB APP https://github.com/ozarnet/ci4sampleapp THE MAKING OF THE DATABASE USED IN THE DEMO https://www.youtube.com/watch?v=GUjMfrwrtco
Labels:

Comments

Post a Comment

Popular posts from this blog

Valid styles for converting datetime to string

I wrote this little table and procedure to help me remember what style 104 did, or how to get HH:MM AM/PM out of a DATETIME column. Basically, it populates a table with the valid style numbers, then loops through those, and produces the result (and the syntax for producing that result) for each style, given the current date and time. It uses also a cursor. This is designed to be a helper function, not something you would use as part of a production environment, so I don't think the performance implications should be a big concern. Read more »
Post a Comment
Read more

Integrating SwiftUI into Existing AppKit Cocoa Projects: A Step-by-Step Guide

As Apple continues to push SwiftUI as the future of app development across its platforms, many developers find themselves in a position where they need to integrate this modern framework into their existing AppKit Cocoa projects. This integration can breathe new life into older applications, allowing developers to take advantage of SwiftUI's declarative syntax and powerful features while maintaining their existing codebase. In this guide, we'll walk through the process of adding SwiftUI to an existing AppKit Cocoa project, providing you with the knowledge to modernize your macOS applications.
Post a Comment
Read more

Tips to improve performance of database-driven Java applications

Here are four tips, not really super cool or something you never heard and I rather say fundamentals but in practice many programmers  just missed these, you may also called this database performance tips but I prefer to keep them as Java because I mostly used this when I access database from Java application. Java database performance tips 1: Reduce the number of calls you make to the database server. Believe it or not if you see performance in seconds than in most cases culprit is database access code. since connecting to database requires connections to be prepared, network round trip and processing on database side, its best to avoid database call if you can work with cached value. even if your application has quite dynamic data having a short time cache can save many database round trip which can boost your java application performance by almost 20-50% based on how many calls got reduced. In order to find out database calls just put logging for each db call in DAO layer, e...
Post a Comment
Read more