Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Database Tutorials for Newbies


This question is not answered. Helpful answers available: 1. Correct answers available: 1.


Permlink Replies: 5 - Last Post: Nov 9, 2017 6:41 PM Last Post By: Rael Bauer
Alan Colburn

Posts: 6
Registered: 8/23/04
Database Tutorials for Newbies  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 7, 2017 1:52 PM
Hi everyone,

So I'm sort of a newbie/hobbyist. I understand the basics of Delphi, including OOP principles, and I have a basic understanding of SQL syntax. Now I'd like to learn about using databases with Delphi. I'm looking for a tutorial for Delphi database newbies to help me learn to create local, cross-platform databases. Looking for info online, I'm overwhelmed with all the systems, drivers, and other things I don't understand.

The tutorials I see that are aimed at newbies like me are older, using technologies that are mostly or only for Windows (like the ADO tutorial on the old delphi.about.com site or even BDE tutorials).

Beside ADO and Access databases, I see discussion about FireDAC, InterBase, DataSnap, Zeos, and other components, libraries, or frameworks. But I don't know enough to even know if they're things I should know about! So I'm hoping someone can point me toward the kind of newbie tutorial I'm looking for ... SQLite, Access, whatever--the database engine or format doesn't matter--just a beginner tutorial for creating local, easily deployed, cross-platform databases.

Thanks, as always!
Markus Humm

Posts: 5,113
Registered: 11/9/03
Re: Database Tutorials for Newbies  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 8, 2017 9:53 AM   in response to: Alan Colburn in response to: Alan Colburn
Am 07.11.2017 um 22:52 schrieb Alan Colburn:
Hi everyone,

So I'm sort of a newbie/hobbyist. I understand the basics of Delphi, including OOP principles, and I have a basic understanding of SQL syntax. Now I'd like to learn about using databases with Delphi. I'm looking for a tutorial for Delphi database newbies to help me learn to create local, cross-platform databases. Looking for info online, I'm overwhelmed with all the systems, drivers, and other things I don't understand.

The tutorials I see that are aimed at newbies like me are older, using technologies that are mostly or only for Windows (like the ADO tutorial on the old delphi.about.com site or even BDE tutorials).

Beside ADO and Access databases, I see discussion about FireDAC, InterBase, DataSnap, Zeos, and other components, libraries, or frameworks. But I don't know enough to even know if they're things I should know about! So I'm hoping someone can point me toward the kind of newbie tutorial I'm looking for ... SQLite, Access, whatever--the database engine or format doesn't matter--just a beginner tutorial for creating local, easily deployed, cross-platform databases.

Thanks, as always!

Hello,

you should use FireDAC which is included with Delphi as a starting
point. It is quite good enough for the majority of applications.

There should be some samples included with Delphi, look in the public
documents folder on your PC. There's some Embarcadero subfolder and
there are samples. Some might be for Interbase, their own database (a
relatrive to Firebird as Firebird is an open source off-spring if
Interbase) but it is easy enough to use SQLite as well or other databases.

Greetings

Markus
Rael Bauer

Posts: 228
Registered: 10/10/02
Re: Database Tutorials for Newbies
Helpful
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 8, 2017 4:39 PM   in response to: Alan Colburn in response to: Alan Colburn
On 2017/11/07 11:52 PM, Alan Colburn wrote:
Hi everyone,

So I'm sort of a newbie/hobbyist. I understand the basics of Delphi,
including OOP principles, and I have a basic understanding of SQL
syntax. Now I'd like to learn about using databases with Delphi. I'm
looking for a tutorial for Delphi database newbies to help me learn
to create local, cross-platform databases. Looking for info online,
I'm overwhelmed with all the systems, drivers, and other things I
don't understand.

The way Delphi works is that most component packages work in the same
way. So if you learn one component package, the other ones are likely to
work in a similar way. Also, even if you go through an old Delphi
tutorial, alot is likely to still be true.

Which platform's are you actually wanting to target?

Delphi's cross-platform library is called Firemonkey.

You should find plenty of tutorials if you search for the following
terms (combined in different ways)

Firemonkey Database Tutorial
Firemonkey Mobile Tutorial
Firemonkey CodeRage

CodeRage is a free online Delphi conference. Most of their replays are
on YouTube now.

E.g.:
http://docwiki.embarcadero.com/RADStudio/Tokyo/en/Tutorial:_Connecting_to_a_SQLite_Database_from_a_Multi-Device_Application_on_Desktop_Platforms

The tutorials I see that are aimed at newbies like me are older,
using technologies that are mostly or only for Windows (like the ADO
tutorial on the old delphi.about.com site or even BDE tutorials).

Beside ADO and Access databases, I see discussion about FireDAC,
InterBase, DataSnap, Zeos, and other components, libraries, or
frameworks.

Some of the main Cross platform DB access components are
FireDAC and Devart products like LiteDAC or UniDAC.

FireDAC: Only available as an addon to Pro version.
LiteDAC: Independant vendor.
Zeos: Not sure if it works with FireMonkey. There is a good chance that
it does.

All of these components work in a very similar way. Learn one, and
you'll know how to work with the others.

Firebird/Interbase is a cross platform database, but I would recommend
you use SQLite for a local db application.

DataSnap is a server side technology, for developing server applications.

-Rael
Markus Humm

Posts: 5,113
Registered: 11/9/03
Re: Database Tutorials for Newbies  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 9, 2017 9:45 AM   in response to: Rael Bauer in response to: Rael Bauer
Am 09.11.2017 um 01:39 schrieb Rael Bauer:


Some of the main Cross platform DB access components are
FireDAC and Devart products like LiteDAC or UniDAC.

FireDAC: Only available as an addon to Pro version.

That's wrong. The pro version without addon contains a limited version
of FireDAC. It can access "local" databases only like SQLLite, an
embedded version of Firebird or IBLite (a lite version of Interbase).
I'm not sure if it's allowed to connect to a full version of Interbase,
but that's the only "big" database for pro without addon then, as this
would generate further revenue for EMBT if used in production.

Greetings

Markus
Jeff Overcash (...

Posts: 1,529
Registered: 9/23/99
Re: Database Tutorials for Newbies  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 9, 2017 10:15 AM   in response to: Markus Humm in response to: Markus Humm
Markus Humm wrote:
Am 09.11.2017 um 01:39 schrieb Rael Bauer:

Some of the main Cross platform DB access components are
FireDAC and Devart products like LiteDAC or UniDAC.

FireDAC: Only available as an addon to Pro version.

That's wrong. The pro version without addon contains a limited version
of FireDAC. It can access "local" databases only like SQLLite, an
embedded version of Firebird or IBLite (a lite version of Interbase).
I'm not sure if it's allowed to connect to a full version of Interbase,
but that's the only "big" database for pro without addon then, as this
would generate further revenue for EMBT if used in production.

Greetings

Markus

It is allowed InterBase server over localhost

Enhanced in 10.2 Tokyo! Support for local databases, including Microsoft Access
database, SQLite and MariaDB database, InterBase ToGo / IBLite, InterBase on
ocalhost, MySQL Embedded, MySQL Server on localhost, Advantage Database local
engine, PostgreSQL on localhost, Firebird Embedded, Firebird on localhost

IBX in pro allows remote connections to IB.

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)
Rael Bauer

Posts: 228
Registered: 10/10/02
Re: Database Tutorials for Newbies  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 9, 2017 6:41 PM   in response to: Markus Humm in response to: Markus Humm
On 2017/11/09 07:45 PM, Markus Humm wrote:
FireDAC: Only available as an addon to Pro version.
That's wrong.

Thanks for correcting me. This was the case when XE4 was released.
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02