New to SQLite
lazarus / 16-Databases

----------------------------------------------------------------------
1HuntnMan · 2024-07-25 21:51

Is there a difference between SQLite & SQLite3?

----------------------------------------------------------------------
dsiders · 2024-07-25 22:12

Quote from: 1HuntnMan on July 25, 2024, 11:51:40 pmIs there a
difference between SQLite & SQLite3?

SQLite is an in-process library that implements a self-contained,
serverless, zero-configuration, transactional SQL database engine.

SQLIte3 is just the latest major version.

The two are interchangeable IMO... since you cannot download SQLite2
from their website.

----------------------------------------------------------------------
Zvoni · 2024-07-26 05:57

It's like with Cars:
SQLite ("Mercedes") is the "Brand"
SQlite3 ("Mercedes 220") is the "Model"/"Version"

----------------------------------------------------------------------
Handoko · 2024-07-26 07:54

@1HuntnMan

If you need some demo codes, try these:
https://forum.lazarus.freepascal.org/index.php/topic,65185.msg496461.h
tml#msg496461
https://forum.lazarus.freepascal.org/index.php/topic,67245.msg517135.h
tml#msg517135
https://forum.lazarus.freepascal.org/index.php/topic,65185.msg496448.h
tml#msg496448

This link is very helpful for anyone who wants to learn SQL Language:
https://www.w3schools.com/sql/

----------------------------------------------------------------------
1HuntnMan · 2024-07-26 12:58

Handoko,
   Thanks, just what I needed, that was my goal today is to find docs
to transgress from dBase to Sql.
   I thought that SqLite3 was a new version but just checking.
   Thanks everyone ... 1HuntnMan