A Simple FireDAC SQLite Application - Delphi 234

LearnDelphi.tv Building database applications is easy in Delphi. Here, we will build an application to talk to an SQLite database, which we will create with the same application.

[@brucemcgee5749]

Very nice. A few things worth noting: 1) SQLite is a local database, so this example works in the Professional and Community editions of Delphi. 2) If you don't specify a database file name, Delphi will create a SQLite database in memory, complete with SQL support. 3) This in-memory database works at design time, just like an on-disk database, which can help with application design.

[@codegearguru]

I'll have try some of this out, thanks.

[@mehamada1]

the problem of delphi is now far from futrure (such as, mvc - them own not 3rd party, state management, type safe etc...)

[@James_Bl_Travel]

All the videos show how to use an existing DB. but how to create a DB with Delphi on an easy way. and on the fly? Lets say if i want to make a DB with date from Telegamm messenger? may u can make a viedeo for that? Thank you :)

[@codegearguru]

There was no database when I started the video. It was created the first time I tried to open it. Then I executed a bunch of SQL to add tables and records.

[@DuxGamingCorner]

Man.... you are sooo fast. You are speaking too quickly and presenting information at rapid pace. Occasionally, I need to go back to review specific parts of the video to understand exactly what you have done. It's even sometimes so hard to see what you clicked or changed in a split second. Anyway thank you for your time. Is there any video about how to add new records, delete them and edit programmatically? Thanks in advance.