[Class] SQLiteDB - Update on 2016-03-28

Post your working scripts, libraries and tools
just me
Posts: 5515
Joined: 02 Oct 2013, 08:51
Location: Germany

Re: [Class] SQLiteDB - Update on 2016-03-28

25 Jan 2018, 09:06

Do you mean the .mode command of SQLite3.exe? AFAIK it's not available within the C\C++ API.
ahklearner
Posts: 283
Joined: 23 Jan 2015, 01:49

Re: [Class] SQLiteDB - Update on 2016-03-28

29 Jan 2018, 03:23

just me wrote:Do you mean the .mode command of SQLite3.exe? AFAIK it's not available within the C\C++ API.
Do you know the other way to achieve this ?
just me
Posts: 5515
Joined: 02 Oct 2013, 08:51
Location: Germany

Re: [Class] SQLiteDB - Update on 2016-03-28

29 Jan 2018, 04:05

If you don't want to use SQLite3.exe, you have to add the HTML by yourself.
ahklearner
Posts: 283
Joined: 23 Jan 2015, 01:49

Re: [Class] SQLiteDB - Update on 2016-03-28

30 Jan 2018, 03:34

just me wrote:If you don't want to use SQLite3.exe, you have to add the HTML by yourself.
Thanks for your time.
AHKStudent
Posts: 308
Joined: 05 May 2018, 12:23

Re: [Class] SQLiteDB - Update on 2016-03-28

10 May 2018, 12:11

How would I go about storing a date in the database so later I can do queries from date A to date B

What data type do I use? How do I do this (obviously I can generate the current date using ahk formattime)
Qriist
Posts: 12
Joined: 11 Sep 2016, 04:02

Re: [Class] SQLiteDB - Update on 2016-03-28

01 Sep 2018, 13:28

Hello, thank your for your class.

I'm still kind of new to SQLite. I have made a script that is compiling a bunch of non-sql data into a single database. My question is, how do I queue a bunch of INSERTS so that it will operate on MANY rows at once? After some extreme performance issues (talking 3hours or so for a fraction of the inserts required) I opted to create a bulkload text that sqlite3.exe reads into the db - but I know this is suboptimal, even if it performs all of the inserts in a few seconds.
just me
Posts: 5515
Joined: 02 Oct 2013, 08:51
Location: Germany

Re: [Class] SQLiteDB - Update on 2016-03-28

02 Sep 2018, 03:06

Hi,

you might want to use a transaction

Code: Select all

DB.Exec("BEGIN TRANSACTION;")
... insert statements
... insert statements
... insert statements
DB.Exec("COMMIT TRANSACTION;")
and to concatenate several SQL statements as shown in SQLiteDB_sample.ahk

Return to “Scripts and Functions”

Who is online

Users browsing this forum: No registered users and 19 guests