Recent

Author Topic: New to SQLite  (Read 896 times)

1HuntnMan

  • Full Member
  • ***
  • Posts: 245
  • From Delphi 7 to Lazarus
    • NewFound Photo Art
New to SQLite
« on: July 25, 2024, 11:51:40 pm »
Is there a difference between SQLite & SQLite3?

dsiders

  • Hero Member
  • *****
  • Posts: 1217
Re: New to SQLite
« Reply #1 on: July 26, 2024, 12:12:57 am »
Is 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.
Preview Lazarus 3.99 documentation at: https://dsiders.gitlab.io/lazdocsnext

Zvoni

  • Hero Member
  • *****
  • Posts: 2635
Re: New to SQLite
« Reply #2 on: July 26, 2024, 07:57:38 am »
It's like with Cars:
SQLite ("Mercedes") is the "Brand"
SQlite3 ("Mercedes 220") is the "Model"/"Version"
One System to rule them all, One Code to find them,
One IDE to bring them all, and to the Framework bind them,
in the Land of Redmond, where the Windows lie
---------------------------------------------------------------------
Code is like a joke: If you have to explain it, it's bad

Handoko

  • Hero Member
  • *****
  • Posts: 5290
  • My goal: build my own game engine using Lazarus

1HuntnMan

  • Full Member
  • ***
  • Posts: 245
  • From Delphi 7 to Lazarus
    • NewFound Photo Art
Re: New to SQLite
« Reply #4 on: July 26, 2024, 02:58:25 pm »
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

 

TinyPortal © 2005-2018