MySQL module?

BlitzMax Forums/BlitzMax Module Tweaks/MySQL module?

Jeroen

(Posted 2005) [#1]

Hi there!

It would be awesome if BlitzMax had a seperate MySQL module. Then, with the GUI library, it's possible to do neat things like RealBasic (www.realbasic.com).

bradford6

(Posted 2005) [#2]

insert MySql vs Postgres fight here...

ant DB support would be cool.

check out Lua Tables first though. very powerful data type

Hotcakes

(Posted 2005) [#3]

Mark expressed interest (shortly after the win32 and linux betas were released) in the existance of an official MaxDB module... but it's never been mentioned since...

Chris C

(Posted 2005) [#4]

I had a brief look at the C api basically the MYSQL object is
a horrid C struct, probably best handled with a simple C
wrapper rather than directly using the dll from max.
So not a straight forward job, but do-able, guess I'll save
it for when I'm bored and feeling masochistic...

regaa

(Posted 2005) [#5]

It would be really really really useful so please @ all c-coder, write this wrapper. I would pay for this one about 19€ :) .

Gavin Beard

(Posted 2005) [#6]

sounds like a good idea, if someone can point me to a good refernce on actuall creating modules for blitzmax i'll look at wrapping the functions of libmysql.dll

Chris C

(Posted 2005) [#7]

:D flame away you mysql lovers (joking!)

http://www.blitzbasic.com/Community/posts.php?topic=54756

Gavin Beard

(Posted 2006) [#8]

seems like a cool idea, only prob is my web server runs mysql and i dont think i wonna install another service, :(

FlameDuck

(Posted 2006) [#9]

It would be really really really useful so please @ all c-coder, write this wrapper. I would pay for this one about 19€ :) .

Why, when PostgreSQL is so easy to use already from BlitzMAX out-of-the-box, would you want to use MySQL?

Is it a religion thing?

seems like a cool idea, only prob is my web server runs mysql and i dont think i wonna install another service, :(

You can replace it. Most programs work with databases through an ODBC layer, so they'll work just as well with PostgreSQL.

Gavin Beard

(Posted 2006) [#10]

only prob is the server is a linux box hosted fo-r me else where in the UK. i have SSH and remote access but cost me alot tohave it fixed if i screw summin up

Gavin Beard

(Posted 2006) [#11]

would this = http://tangentsoft.net/mysql++/ not make it possible?

managed to import the .a file and use an extern block to define function connect, but it seems to always return -1

N	(Posted 2006) [#12]

No, that would actually make it less possible.

Booticus

(Posted 2006) [#13]

http://www.blitzmax.com/Community/posts.php?topic=55502