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
About donations (wiki)
Bookstore
Computer Math and Games in Pascal
(preview)
Lazarus Handbook
Search
Advanced search
Recent
Simple multithreading cod...
by
LV
[
Today
at 04:39:00 pm]
Str declaration
by
Kays
[
Today
at 04:36:16 pm]
Recommended way to build ...
by
carl_caulkett
[
Today
at 04:17:44 pm]
Stack Overflow in RtlVirt...
by
simone
[
Today
at 04:13:06 pm]
Vectors to find Center of...
by
Boleeman
[
Today
at 03:48:26 pm]
7zip DLL is super broken
by
domasz
[
Today
at 03:47:13 pm]
Incorrect FPC/Lazarus bui...
by
Seenkao
[
Today
at 03:26:56 pm]
Gridprinter Newby
by
Zvoni
[
Today
at 03:03:35 pm]
Loading text data from a ...
by
carl_caulkett
[
Today
at 02:58:56 pm]
QuasiClever Fractal
by
Boleeman
[
Today
at 02:23:56 pm]
Bitmap 16bit R5G6B5
by
wp
[
Today
at 11:50:20 am]
"Show Compiler Dialog"
by
MarkMLl
[
Today
at 10:21:49 am]
AI, NLP and CAI: Text Gen...
by
schuler
[
Today
at 09:48:18 am]
Compiler error when check...
by
af0815
[
Today
at 09:35:48 am]
Hashids that you need but...
by
Thaddy
[
Today
at 06:10:34 am]
C++ conversion : what is ...
by
Thaddy
[
Today
at 05:44:34 am]
Setting the fpc path
by
TRon
[
Today
at 05:30:14 am]
Game Music Emulator
by
Guva
[
Today
at 05:25:58 am]
Is there a better web-bro...
by
QEnnay
[September 17, 2024, 11:50:29 pm]
LazReport / FreeReport qu...
by
dseligo
[September 17, 2024, 11:37:59 pm]
Complex objects and JsonO...
by
Flea
[September 17, 2024, 11:02:28 pm]
Best way to exchange data...
by
cdbc
[September 17, 2024, 10:16:27 pm]
TListView.OnChange Event ...
by
msintle
[September 17, 2024, 10:11:04 pm]
Broken Icon Display on ma...
by
msintle
[September 17, 2024, 10:09:18 pm]
how to convert pdf to png...
by
zeljko
[September 17, 2024, 08:35:54 pm]
« previous
next »
Print
Pages: [
1
]
Author
Topic: New to SQLite (Read 896 times)
1HuntnMan
Full Member
Posts: 245
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: 1217
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 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"
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: 5290
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
Full Member
Posts: 245
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