   SQL Databases
  Part of a project I'm playing around with involves (supposedly) reading data from an SQL database.  Being quite lazy and happy with reading from text files, I've never bothered to look into databases for my program data, but now I have to.Can anyone recommend to me the best way to access SQL data from inside a C++ program written on a Win32 platform? :)Thanks.   
  If you use MySQL they have an entire API available to use as seen in their documentation.   ;  Of course, MySQL requires a local server running. If you're looking for something smaller and simpler, try SQLite. It's designed to be embedded into applications, rather than for use as a server application.   ;  Another simpler option is the use of SQLite. This is a free SQL database system capable of most SQL92 functionality and does not require anything at all. Just include the sources in your program and you can use a SQL database immediately.Promit.. darn!   ;  if you use mysql, you can embed it on your app so you don't have to bother start/stop it.Also, you can use SQLite, which is very simple and useful for simple projects. One feature you may find acttractive (or not) is that an entire database is fit on a single file.   ;  If a local "file based" database is suficcient for you needs, I woulddefenetly recommend SQLiteFor win32 applications you need to use version 2.8.x, at least ifyou decide to compile the library yourself form source.(Thats what I did, making a project in Borland C++ 5.02)It implements an almost complete SQL, and other nice utilitiesfor handlig/comparing dates.Im not very experienced with it yet but even as a beginner I havesuccess using it.EDIT: By the time I completed this post, sqlite was alredy mentioned   ;  Well, I guess I'm taking a look at SQLite..  as far as I can tell it looks like I'll have to compile the latest version myself to get the lib files :(.  I have compiling other peoples code, it so rarely works for me.   ;  Another option you might consider looking into is SQLite. Just felt it should be mentioned.   ;Quote:Original post by BorukiWell, I guess I'm taking a look at SQLite..  as far as I can tell it looks like I'll have to compile the latest version myself to get the lib files :(.  I have compiling other peoples code, it so rarely works for me.Tons of APIs for SQLite here.   ;  Hello,I had a look to some common SQL API some time ago, and I wrote a short journal entry about this. I know, this is a shameless plug [embarrass]   