Thread: Developing database management software

  1. #1
    Registered User
    Join Date
    Apr 2004
    Posts
    14

    Question Developing database management software

    Hi guys,
    I'm a professional photographer with a bit of programming experience. I know a lot about object-oriented programming from scripting languages (PHP, ASP, JavaScript), but not too much about C++. Here's what I need to do.

    I have a large file of photographs, numbering in the thousands. The rest of my workflow is digital on a Windows XP platform, so I'd like to integrate that with a digital database, rather than the traditional file cabinet system. First, I need to assemble a database with an entry for each photo (with information about location, category, exposure, etc.). Second, I'd like to write a small program to manage this database; it should be able to add new entries, delete old ones, categorize the data by various characteristics, etc. Pretty basic stuff right now. Rather than simply use packaged database software and manage my data from there, I'm choosing the approach of intermediate software because in the future I'll add features like automatic invoices for photos sent to publishers, e-mail notifications, searches, etc.

    I have Visual C++ 6.0, and I know the basics of putting together simple SDI and dialog-based apps. I know very little about how objects, classes, etc. interact with each other, and I know absolutely nothing about interfacing with databases from C++. I might be able to hack something with Visual Basic, but I'd prefer to do it the right way with solid C++ code.

    So first and foremost, I need some sort of database software; preferably free, because I don't have a lot of cash. I might be able to get ahold of Microsoft Access, if necessary. I do have Excel... would a spreadsheet work? If not, I need some sort of freeware or open-source software to work with (I used MySQL for my web-based work... any chance of applying that to this situation?)

    Next, can anybody help walk me through the steps of connecting whatever database system I choose to use to a Windows application? I know nothing about exchanging data between the database and the application. ODBC maybe? Microsoft's documentation is, of course, totally cryptic for somebody who doesn't already know how to do it.

    I really appreciate your help. As soon as I get the project working, I'll let you all know how it goes. Thanks!

  2. #2
    Registered User
    Join Date
    Apr 2004
    Posts
    14
    Oh, by the way, I don't need to add any actual images to the database, at least not at this point. At most there will be a field for the path to a file, but only simple text strings.
    // Visual C++ 6.0... newbie with many questions!

  3. #3
    Registered User
    Join Date
    Apr 2004
    Posts
    14
    Ok, so I see that MFC has some classes dedicated to database interfacing. Still, I have no idea how to set up a database to use with a Windows program, nor the needed code to pass data between the two. Can anybody help me, or am I totally barking up the wrong tree?

  4. #4
    Registered User
    Join Date
    Oct 2001
    Posts
    2,934
    I can't help you much, as I haven't done any database programing, but I'm pretty sure you can use MySQL, because if you check out the thread below (from the C Programming forum), there's a MYSQL_ROW in there. So that poster must be using it. Of course I don't think he's using Windows, but there's probably a library for Windows.

    http://cboard.cprogramming.com/showthread.php?t=53887

  5. #5
    Registered User ventolin's Avatar
    Join Date
    Jan 2004
    Posts
    92
    Wouldnt it be easier to install PHP/MySQLAdmin/Apache? Its free to download, and quite simple to get the MySQLAdmin working, from there you can add/delete tables/data with the click of a few buttons.

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. A database sort of management system
    By relyt_123 in forum C++ Programming
    Replies: 5
    Last Post: 07-01-2008, 03:11 AM
  2. Database Management Programming.
    By Shamino in forum C++ Programming
    Replies: 2
    Last Post: 01-17-2006, 05:03 PM
  3. What Version Management Software Do You Use?
    By Geolingo in forum A Brief History of Cprogramming.com
    Replies: 1
    Last Post: 11-05-2003, 07:17 AM
  4. did SDL support software developing ?
    By black in forum Game Programming
    Replies: 4
    Last Post: 11-08-2002, 09:04 AM
  5. Database Software Ideas...
    By Visual Develope in forum A Brief History of Cprogramming.com
    Replies: 1
    Last Post: 05-29-2002, 02:07 PM