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

Comments

Popular posts from this blog

What is .csp extension? C++ Server Pages

C++ Server Pages C++ Server Pages (CSP) is a Web Engine for advanced Web Application Development, that uses blended Markup Language / C++ scripts ( such as HTML/C++, XML/C++, WML/C++ etc.) Similar to ASP and JSP, it provides a great easiness in creating web pages with dynamic content, as well as complex business applications. However, instead of Java, Javascript or VBscript, it uses C++ . This brings some significant advantages: Incredibly high processing efficiency. Benchmarks have shown a range of 80 to 250 times higher processing speed than ASP. The use of pure C++ allows the use of tons of libraries that are currently available. It is important to notice that the libraries written in C++ are tens or hundreds of times more than in any other language. It is widely accepted that the most skilled programmers in the IT market are the C++ ones. However, CGI, ISAPI and other frameworks where C++ applies, do not provide the web developer with facilities for efficient app...

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 »