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...)

[@erwinblumenhagen5767]

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.