Board index » cppbuilder » Which is the best choice?
Jeff
CBuilder Developer |
Jeff
CBuilder Developer |
Which is the best choice?2005-06-23 09:39:53 PM cppbuilder61 I'm going to start building a program (in C++Builder6) to help catalog a music collection, namely just the artists and titles, not mp3's. I could use some advice on how best to implement the storage medium. I think a database would be the best, but I don't have much experience with them. I'll need one that can be easily installed on any Windows machine and has good search capabilities. Any thoughts? Thanks, Jeff |
Andrue Cope [TeamB]
CBuilder Developer |
2005-06-23 09:47:06 PM
Re:Which is the best choice?
Jeff wrote:
QuoteAny thoughts? I now realise why it's so handy. In the case of a music library XML support would be a step toward making that library available as a UPnP music server since that uses XML as the transport protocol. As for the backend you could try playing with MS Access. It's cheap and cheerful and seems to work well. -- Andrue Cope [TeamB] [Bicester, Uk] info.borland.com/newsgroups/guide.html |
Pete Fraser
CBuilder Developer |
2005-06-23 10:34:07 PM
Re:Which is the best choice?
noooooooo
It's horrible and slow - please don't use Access. There are so many databases out there and some are in-memory and tie in with Borland's Db controls. Admitedly I don't use them but lots of other people do. Rgds Pete "Andrue Cope [TeamB]" < XXXX@XXXXX.COM >wrote in message QuoteJeff wrote: {smallsort} |
Vladimir Stefanovic
CBuilder Developer |
2005-06-23 10:52:35 PM
Re:Which is the best choice?Quotenoooooooo very useful for everyday needs. Music catalogue is peace of cake for ADO+MDB. I have some databases & tables in it with more than 400,000 records per table, and queries on it (if indexes are setted properly) are pretty fast. Some of my DB programs based on ADO+MDB works for years eith no problems. I have never *need* to switch to something else, really. Finally I think that for music catalogue, ADO + MS ACCESS 100 times exceed the needs of the catalogue. QuoteThere are so many databases out there and some are in-memory with BCB, that was my second birthday. The third would be when I see some replacement for QReports. That are my experiences... I have no experience with XML way of storing data but I beleave that's the ultimate solution for a long period. -- Best regards, Vladimir Stefanovic |
Jeff
CBuilder Developer |
2005-06-23 11:05:00 PM
Re:Which is the best choice?
Thanks for all the input, this is great. Do you know of any tutorials I
could look at? I'm not very familiar with databases in general. P.S. What is ADO? What is MDB? Thanks, Jeff "Vladimir Stefanovic" < XXXX@XXXXX.COM >wrote in message Quote>noooooooo |
Andrue Cope [TeamB]
CBuilder Developer |
2005-06-23 11:08:53 PM
Re:Which is the best choice?
Pete Fraser wrote:
QuoteIt's horrible and slow - please don't use Access. cheerful and readily available. Basically a nice little database that you can find on pretty much any Windows installation. But of course YMMV - databases are funny things :) -- Andrue Cope [TeamB] [Bicester, Uk] info.borland.com/newsgroups/guide.html |
Andrue Cope [TeamB]
CBuilder Developer |
2005-06-23 11:16:36 PM
Re:Which is the best choice?
Vladimir Stefanovic wrote:
QuoteThat are my experiences... I have no experience with XML way of that way and will be using XML for our APIs. I just decided that the test data might as well be the testbed for our XML. I also haven't chucked everything into one file. I have a hierarchical structure with the nodes stored in individual XML files. My original thought when I heard about XML years ago was 'how horribly innefficient using ASCII to store data'. Having played with it a bit though I've decided that's not a fair criticism (although UPnP comes in for a lot of stick because of it). I've begun to realize just how incredibly portable it is. I always used to like CSV because /everyone/ knew how to read it. But CSV had it's share of faults:No agreement on how to handle ','s and '"'s in data. No column headings. Can't handle hierarchical data. Totally useless for non-standard data. XML seems to address all these issues and over the last month I've begun to see it as 'Turbo charged CSV'. It's going to be interesting to see how it fares as an API protocol. We'll be using it not just for interprocess communication but also EXE<->DLL. -- Andrue Cope [TeamB] [Bicester, Uk] info.borland.com/newsgroups/guide.html |
Andrue Cope [TeamB]
CBuilder Developer |
2005-06-23 11:17:49 PM
Re:Which is the best choice?
Vladimir Stefanovic wrote:
Quote>noooooooo database use MDB format..and I have no idea why :) -- Andrue Cope [TeamB] [Bicester, Uk] info.borland.com/newsgroups/guide.html |
Vladimir Stefanovic
CBuilder Developer |
2005-06-23 11:31:10 PM
Re:Which is the best choice?QuoteThanks for all the input, this is great. Do you know of any tutorials I ... and finally C++Builder 6 Developer's Guide ADO is set of components (on your palette bar), like TADOTable, TADOQuery, TADOConnection, which helps you to wire your database (like MS ACCESS) to your program. When I say MDB, I mean on the MS ACCESS DB file (*.mdb). Alternatively to ADO, there is BDE with similar set of components, but I do not recommend that way when ADO exists. Try to Google arround, must be some articles... -- Best regards, Vladimir Stefanovic |
Vladimir Stefanovic
CBuilder Developer |
2005-06-23 11:38:03 PM
Re:Which is the best choice?Quote[...] All I can say is that all our Access SQL Server is needed ;): - All *.mdb tables, indices & relationshios are stord in one file. - If using ADO no pre-installation is required (like for BDE) - ADO returns LIVE datasets which was difficult for BDE - Easy to design the database - All you need for *.mdb is inside BCB IDE. - Wide range of SQL queries - Fast enough (I don't need more) - handles big files and big tables - it's working! - Easy to maintain through MS ACCESS -- Best regards, Vladimir Stefanovic |
Jeff
CBuilder Developer |
2005-06-23 11:55:06 PM
Re:Which is the best choice?
I'll look into using the ADO components with a single file MDB Access
database. Thanks for everything. "Vladimir Stefanovic" < XXXX@XXXXX.COM >wrote in message Quote>Thanks for all the input, this is great. Do you know of any tutorials I |
Andrue Cope [TeamB]
CBuilder Developer |
2005-06-24 12:02:51 AM
Re:Which is the best choice?
Vladimir Stefanovic wrote:
Quote>[...] All I can say is that all our Access went that route :) But good info anyway. -- Andrue Cope [TeamB] [Bicester, Uk] info.borland.com/newsgroups/guide.html |
Dave Smey
CBuilder Developer |
2005-06-24 08:10:37 AM
Re:Which is the best choice?
"Jeff" < XXXX@XXXXX.COM >wrote in message
QuoteThanks for all the input, this is great. Do you know of any tutorials I the following for a quick jumpstart: 1) Design a table in "Database Desktop" (a tool bundled with CB6). 2) Make a form using the Database->Form Wizard (in the main menu of CB6). By all means read the other documentation on databases in the Developer's Guide, etc. But the above is what you need to get started with a form that actually *does* something. [Then, I suppose, you can graduate from BDE, which the above steps will create, to ADO.] |
Keith
CBuilder Developer |
2005-06-25 09:14:35 PM
Re:Which is the best choice?
Pete Fraser wrote:
Quotenoooooooo keith |