Lazarus
Home
Help
TinyPortal
Search
Login
Register
Lazarus
»
Forum
»
Programming
»
Databases
»
New to SQLite
Free Pascal
Website
Downloads
Wiki
Documentation
Bugtracker
Mailing List
Lazarus
Website
Downloads (Laz+FPC)
Packages (OPM)
FAQ
Wiki
Documentation (RTL/FCL/LCL)
Bugtracker
CCR Bugs
GIT
Mailing List
Other languages
Foundation
Website
Useful Wiki Links
Project Roadmap
Getting the Source
Screenshots
How to use the forum
Forum Rules
About donations (wiki)
Bookstore
Computer Math and Games in Pascal
(preview)
Lazarus Handbook
Search
Advanced search
Recent
Dynamic libraries in Linu...
by
Fred vS
[November 08, 2025, 10:28:42 pm]
What happens if you use "...
by
jamie
[November 08, 2025, 10:14:51 pm]
Convert table to JSON arr...
by
bytebites
[November 08, 2025, 10:08:48 pm]
Unexpected lack of error ...
by
440bx
[November 08, 2025, 09:59:06 pm]
How detect a keypress in ...
by
creaothceann
[November 08, 2025, 09:37:38 pm]
FPC v3.2.2 internal error
by
440bx
[November 08, 2025, 09:15:48 pm]
Register global hotkey
by
LemonParty
[November 08, 2025, 09:05:25 pm]
Anyone interested in help...
by
Roland57
[November 08, 2025, 08:42:50 pm]
Distance of gridlines in ...
by
wp
[November 08, 2025, 08:08:14 pm]
CustomDraw package compil...
by
wp
[November 08, 2025, 06:54:28 pm]
Drawing a picture on the ...
by
wp
[November 08, 2025, 06:34:20 pm]
Lazarus portable?
by
PascalDragon
[November 08, 2025, 06:29:28 pm]
FPC 3.2.4-rc1 available
by
PascalDragon
[November 08, 2025, 06:26:08 pm]
Initialize list in functi...
by
PascalDragon
[November 08, 2025, 06:24:02 pm]
[SOLVED]FPHTTPServer with...
by
m.abudrais
[November 08, 2025, 06:18:26 pm]
How to implement uKey-bas...
by
PascalDragon
[November 08, 2025, 06:15:20 pm]
Parsing command line stri...
by
LemonParty
[November 08, 2025, 01:21:47 pm]
synedit
by
scasparz
[November 08, 2025, 10:05:25 am]
Get Out of Squircle Jail ...
by
Hansaplast
[November 08, 2025, 09:36:22 am]
Paradox date filter
by
bytebites
[November 08, 2025, 08:25:44 am]
head hurting - DBGrid Wor...
by
robertom
[November 08, 2025, 01:52:08 am]
TScrollBox ScrollBy Metho...
by
andrew Bubble
[November 07, 2025, 11:54:17 pm]
OPCB – Object Pascal Comp...
by
fabianoallex
[November 07, 2025, 06:51:39 pm]
Blog area?
by
TBMan
[November 07, 2025, 03:57:17 pm]
MOSAIC - free terrain mak...
by
Tomi
[November 07, 2025, 02:09:39 pm]
« previous
next »
Print
Pages: [
1
]
Author
Topic: New to SQLite (Read 1510 times)
1HuntnMan
Sr. Member
Posts: 397
From Delphi 7 to Lazarus
New to SQLite
«
on:
July 25, 2024, 11:51:40 pm »
Is there a difference between SQLite & SQLite3?
Logged
dsiders
Hero Member
Posts: 1461
Re: New to SQLite
«
Reply #1 on:
July 26, 2024, 12:12:57 am »
Quote from: 1HuntnMan on July 25, 2024, 11:51:40 pm
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.
Logged
Preview the next Lazarus documentation release at:
https://dsiders.gitlab.io/lazdocsnext
Zvoni
Hero Member
Posts: 3135
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"
Logged
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: 5485
My goal: build my own game engine using Lazarus
Re: New to SQLite
«
Reply #3 on:
July 26, 2024, 09:54:40 am »
@1HuntnMan
If you need some demo codes, try these:
https://forum.lazarus.freepascal.org/index.php/topic,65185.msg496461.html#msg496461
https://forum.lazarus.freepascal.org/index.php/topic,67245.msg517135.html#msg517135
https://forum.lazarus.freepascal.org/index.php/topic,65185.msg496448.html#msg496448
This link is very helpful for anyone who wants to learn SQL Language:
https://www.w3schools.com/sql/
Logged
1HuntnMan
Sr. Member
Posts: 397
From Delphi 7 to Lazarus
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
Logged
Print
Pages: [
1
]
« previous
next »
Lazarus
»
Forum
»
Programming
»
Databases
»
New to SQLite
TinyPortal
© 2005-2018