> Maybe i missed the answer to this, but
> can Freetrade run with MySQL GPL or PostgreSQL ?

Oh yeah...the original questions... :)

I haven't tried using the older MySQL with FreeTrade.  I suspect it will
work for 99%.  It will probably break anywhere there's a query with an
IN(...) clause.  This is a way around this.  You can rewrite the query
to use OR.  For example:

SELECT Created FROM invoice
WHERE ID in (1,2,3,4)

is the same as

SELECT Created FROM invoice
WHERE ID = 1
OR ID = 2
OR ID = 3
OR ID = 4


As for Postgres...that would be a lot of work.  Every query would have to be
gone over.

Here's my 10-second argument for using MySQL despite it's $200 license.
FreeTrade is an application for selling things.  You ought to see $200 in
profit from a FreeTrade site very quickly.  If not, maybe you shouldn't be
in business.

It sounds like maybe you're looking to make kiosks that won't be selling
anything, just showing off products.  If that's that's the case, maybe
there's a simpler product you can use that doesn't use MySQL...

Leon



------------------------------------------------------------
To subscribe:    [EMAIL PROTECTED]
To unsubscribe:  [EMAIL PROTECTED]
Site:            http://www.working-dogs.com/freetrade/
Problems?:       [EMAIL PROTECTED]

Reply via email to