I trust the quality of the Postgresql code and developer community more than I trust MySQL.
Ever since Sun bought the company behind MySQL, many of the core developers left the MySQL project, including the founder over concerns that the code was released before it was ready and rushed out the door to meet demands from Sun management. I use Postgresql at my day job, where we selected it to replace Oracle. It worked out very well and we never had a problem with it even after several years in production operation. Some of the differences between Postgresql and Mysql might not matter much for a simple, stand alone application, like this, but they matter a lot for the projects I do for my day job. Either one would probably work out fine. -Doug --- In [email protected], "brian_z111" <brian_z...@...> wrote: > > Thanks for the feedback ... the ODBC feature seems to have been 'out > of sight out of mind' ever since it was released. > > > I use postgress, a free open > > source database. > > Why Postgress over MySQL ... any reason? (in the past Tomasz > recommended MySQL). > > > --- In [email protected], "dloyer123" <dloyer123@> wrote: > > > > I just had a good experience using the odbc database driver with > > amibroker. > > > > I built a tick database, about 75GB worth. From that, I can > calculate > > volume at price, vwap and other data. I use postgress, a free open > > source database. > > > > I thought that I would have to write my own trade match and > backtest > > code in sql, but then I found the odbc sql interface to pull the > data > > into amibroker. > > > > I was plesantly surprised how fast the odbc/amibroker interface > was. > > Working with tick data is never fast, but each sql query from ami > was > > only a handful of ms. > > > > -Doug > > >
