Welcome, Guest. Please login or register.
Amiga Kit Amiga Store Hollywood MAL AMIStore App Store A600 Memory

AuthorTopic: SQL database library (dynamic / linking)...  (Read 1091 times)

0 Members and 1 Guest are viewing this topic.

Offline Jose

SQL database library (dynamic / linking)...
« on: April 21, 2009, 11:47:48 PM »
I've been reading a tutorial on SQL, really much easier than I thought, never really had looked at it properly.

My goal is to code an idea I had for a small program that has an internal database, tied to other things of course. Instead of building my own database file type I thought I could use an SQL library embedded in my code. I looked around and mySQL seems to be a good contender, althoug it's GPL, and I my intention is not to realease the code, at least for now, maybe when I'm done with it (IF...).

So, can anyone recommend good alternatives ? It must be used as a link library in a C program, using the standard SQL syntax.

:pint:
\\"We made Amiga, they {bleep}ed it up\\"
 

Offline Hans_

Re: SQL database library (dynamic / linking)...
« Reply #1 on: April 22, 2009, 12:26:14 AM »
@Jose
MySQL is designed to run as a server that is separate from the clients using the database. As such, you can use a MySQL database with a non-GPL program as they communicate via a network (it's a separate process). There is no dynamic linking so it's not a single program as per the GPL.  

If you really want the database code to be internal to the program, then SQLite (public domain) is an option. However, if your database gets big, you're better off running a MySQL server, and accessing it via TCP/IP, even if it's on the same machine.

Hans
http://hdrlab.org.nz/ - Amiga OS 4 projects, programming articles and more. Home of the RadeonHD driver for Amiga OS 4.x project.
 

Offline Jose

Re: SQL database library (dynamic / linking)...
« Reply #2 on: April 22, 2009, 12:52:21 AM »
@Hans

There's a version of mySQL that can be runn embedded in a program, at least that's what I understood from taking a look at it's HUGE docs. But the license is GPL.
Ok I could install a server locally but let's say I want to distribute my program with a database of acunpuncture points and pictures, I won't be able to include the server in my distribution of the program..

I'll take a look at SQLite, thanks for the hint :)
\\"We made Amiga, they {bleep}ed it up\\"
 

Offline mdv2000

Re: SQL database library (dynamic / linking)...
« Reply #3 on: April 22, 2009, 03:01:25 AM »
Jose,
  What platform are you targeting?  If you want to write a program for just Windows there is a lot of options!  If you want cross platform, the easiest is Java with the Hypersonic SQL DB.

Actually,  the easier way to stay free and cross platform would be a Java solution!  And if you know C, java is just a long weekend to learn for the most part!

Mike
Mike Valverde
---------------------------------
"Only AMIGA makes it possible!"

A2000HD +A2630+ w/8MB+500MB SCSI HD
 + Buddha IDE + 1.3 and 3.1 ROM (WB 3.1)
 

Offline persia

Re: SQL database library (dynamic / linking)...
« Reply #4 on: April 22, 2009, 03:42:44 AM »
Not sure what you are after but it seems like sqlite may be the answer.

[SIGPIC][/SIGPIC]

What we\'re witnessing is the sad, lonely crowing of that last, doomed cock.
 

Offline Fats

Re: SQL database library (dynamic / linking)...
« Reply #5 on: April 22, 2009, 09:44:16 PM »
Quote

persia wrote:
Not sure what you are after but it seems like sqlite may be the answer.


A discussion on Amiga versions of sqlite

Staf.
Trust me...                                              I know what I\'m doing
 

Offline Jose

Re: SQL database library (dynamic / linking)...
« Reply #6 on: April 22, 2009, 10:23:15 PM »
Yes, seems like SQLite is the answer. I'd code it for Amiga 68k / OS4 / MOS and even AROS. I'd also like to do a winblows version:)

\\"We made Amiga, they {bleep}ed it up\\"
 

Offline lorddef

Re: SQL database library (dynamic / linking)...
« Reply #7 on: April 22, 2009, 10:37:12 PM »
Well there's always postgresql, it's bsd licenced.

Not sure how much of a massive task it's be to get it going though. If you wanted the server you'd be dealing with shared memory for starters.
Restraining orders are just another way of saying I love you!