Re: searching for the right dbm ...

Andrea Frascari wrote: > > Hello, > > I'm developing an application that will manage medium amounts of data. > The analysis is completed, and it's now time to undertake some > architectural > decisions, such as which database to use. > The application will run on Windows 95 and NT. > What follows is a list of the main features the database is supposed to > have: > - cost: free for the end users. We need an "unlimited" licence. > - ODBC support > - SQL-based > - sicurety: hi, transaction support required: the application will > manage big > money transfers ! > - performance: hi retreival and insertion speed: the number of records > will > not be huge though (biggest tables around 25,000 recors). > > Any suggestion? > What do you folks think of Microsoft Access for instance? Does it come > with > an "unlimited" licence? > > Any information, opinion, address towords other information sources is > very welcome! > > Thanks in advance. > > Andrea Frascari - e-mail: mir5360@iperbole.bologna.it Access: If you're distributing just the db and using some other front-end to get at the data then it is free. If you're distributing the whole enchilada then there is a charge. There is a way I think to 'compile' an Access app and then you probably would not have to pay. MS will be glad to answer that question. The best PC based DB (non-serious server type) I have worked with is Sybase SQL-Anywhere. Very robust and performance is quite good. No user front end though. So you need to build your own front end using some other tool. I think you can distribute it free provided you're not creating tables or indexes or .... on the fly. Never really checked in to that so I would suggest calling Sybase for proof positive. Hope that helps. Rich Mycroft