Page 1 of 3

SQLite

Posted: Fri Mar 24, 2017 7:37 am
by genetika
Hi.
Is it possible to compile these sources on an expanded QL ( SGC ) ?

http://os4depot.net/index.php?function= ... sqlite.lha

:D

M.

Re: SQLite

Posted: Fri Mar 24, 2017 10:24 pm
by NormanDunbar
I'd say probably not. The blurb mentions 's lot of what appears to be Amiga specific stuff.

I was looking into a ql port of sqlite 3.x a while back. As far as I remember you needed something like visual c, I think, to compile the source as a lot of the code was generated. There was a single large c file for people without visual c.

It was too big to compile with c68 so I tried extracting all the individual headers and c files myself. I had to write a parser to do it "easily". Then life got in the way and, like a lot of things, it got put aside.

I need to fish it out again though, and have a look.


Cheers,
Norm.

Re: SQLite

Posted: Sat Mar 25, 2017 9:39 am
by Derek_Stewart
NormanDunbar wrote:I'd say probably not. The blurb mentions 's lot of what appears to be Amiga specific stuff.

I was looking into a ql port of sqlite 3.x a while back. As far as I remember you needed something like visual c, I think, to compile the source as a lot of the code was generated. There was a single large c file for people without visual c.

It was too big to compile with c68 so I tried extracting all the individual headers and c files myself. I had to write a parser to do it "easily". Then life got in the way and, like a lot of things, it got put aside.

I need to fish it out again though, and have a look.


Cheers,
Norm.
Hi Norman,

The problem with SQLite, is the source code is a single file which is an amalgamation of all the individual "C" files and the size of the file is 5.1mb, C68 only compiles upto 1mb (me thinks...), this maybe a compiled with QL-GCC?

There is a standard set to individual C files and a UNIX makefile, so I wuld say it just nneds the makefile written for C68.

But not use DBAS to write SQLite style procedures and functions.

Re: SQLite

Posted: Thu Feb 17, 2022 2:51 pm
by Sparrowhawk
Hi Derek/Norman,

Did either of you progress any further with an SQLite port (or other SQL engine)?

No pressure, no expectation, just checking in case something is still in the works.

Thanks
JY

Re: SQLite

Posted: Thu Feb 17, 2022 3:36 pm
by Derek_Stewart
Hi,

SQLite uses an amalgamated C source file which is over 1Mb in size, this causes problems with C68 in a QDOS environment.

I was going to try compiling it with QDOS-GCC and cross compile it, not got around to that.

There are the individual C files in a standard format of one file for each function, just need the makefile written.

Re: SQLite

Posted: Thu Feb 17, 2022 3:50 pm
by Sparrowhawk
Thanks for the update Derek.

Re: SQLite

Posted: Thu Feb 17, 2022 8:53 pm
by NormanDunbar
I hit the same problem with the source file size. At the time, I never had acces to the cross compiler so it sort of died. :( It is, however, on the pile of "stuff I might do one day when I have time, MrsD is away, and the dog doesn't need me for a bit"! ;) #

Cheers,
Norm.

Re: SQLite

Posted: Fri Feb 18, 2022 9:09 am
by Derek_Stewart
Hi,

I downloaded the non-Amalgamated source code to SQLite, I tested compiled each file as a module, with C68, just a couple of files need a modification for C68, and the makefile written to compile the executable.

Re: SQLite

Posted: Fri Feb 18, 2022 2:39 pm
by Dave
Would it help to have TONS of memory?

Re: SQLite

Posted: Sat Feb 19, 2022 8:39 am
by NormanDunbar
Nice one Derek. Well done.

Cheers,
Norm