SQLite

Anything QL Software or Programming Related.
User avatar
genetika
Over Heated PSU
Posts: 127
Joined: Thu May 05, 2011 5:38 pm
Location: Rome, ITALY
Contact:

SQLite

Post 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.


User avatar
NormanDunbar
Forum Moderator
Posts: 2251
Joined: Tue Dec 14, 2010 9:04 am
Location: Leeds, West Yorkshire, UK
Contact:

Re: SQLite

Post 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.


Why do they put lightning conductors on churches?
Author of Arduino Software Internals
Author of Arduino Interrupts

No longer on Twitter, find me on https://mastodon.scot/@NormanDunbar.
Derek_Stewart
Font of All Knowledge
Posts: 3929
Joined: Mon Dec 20, 2010 11:40 am
Location: Sunny Runcorn, Cheshire, UK

Re: SQLite

Post 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.


Regards,

Derek
User avatar
Sparrowhawk
Super Gold Card
Posts: 624
Joined: Wed Dec 15, 2010 12:33 pm
Location: @131072
Contact:

Re: SQLite

Post 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


a.k.a. Jean-Yves
Derek_Stewart
Font of All Knowledge
Posts: 3929
Joined: Mon Dec 20, 2010 11:40 am
Location: Sunny Runcorn, Cheshire, UK

Re: SQLite

Post 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.


Regards,

Derek
User avatar
Sparrowhawk
Super Gold Card
Posts: 624
Joined: Wed Dec 15, 2010 12:33 pm
Location: @131072
Contact:

Re: SQLite

Post by Sparrowhawk »

Thanks for the update Derek.


a.k.a. Jean-Yves
User avatar
NormanDunbar
Forum Moderator
Posts: 2251
Joined: Tue Dec 14, 2010 9:04 am
Location: Leeds, West Yorkshire, UK
Contact:

Re: SQLite

Post 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.


Why do they put lightning conductors on churches?
Author of Arduino Software Internals
Author of Arduino Interrupts

No longer on Twitter, find me on https://mastodon.scot/@NormanDunbar.
Derek_Stewart
Font of All Knowledge
Posts: 3929
Joined: Mon Dec 20, 2010 11:40 am
Location: Sunny Runcorn, Cheshire, UK

Re: SQLite

Post 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.


Regards,

Derek
User avatar
Dave
SandySuperQDave
Posts: 2765
Joined: Sat Jan 22, 2011 6:52 am
Location: Austin, TX
Contact:

Re: SQLite

Post by Dave »

Would it help to have TONS of memory?


User avatar
NormanDunbar
Forum Moderator
Posts: 2251
Joined: Tue Dec 14, 2010 9:04 am
Location: Leeds, West Yorkshire, UK
Contact:

Re: SQLite

Post by NormanDunbar »

Nice one Derek. Well done.

Cheers,
Norm


Why do they put lightning conductors on churches?
Author of Arduino Software Internals
Author of Arduino Interrupts

No longer on Twitter, find me on https://mastodon.scot/@NormanDunbar.
Post Reply