Click here to Skip to main content
11,412,833 members (71,717 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: MFC database
Do I want to let the MFC serialize method store my data in a binary file, create an SQL solution or do I want to create my own method using CFILE to read/write data?

The application will consist of a customer base file with inventory control. Files will most definitely become large quickly. I need it to be multi-user, which makes me lean toward SQL server or maybe MS Access.

Anyone have a specific process that they prefer?
Posted 16-Jul-12 16:57pm
DrBones691.9K
Comments
Wes Aday at 16-Jul-12 22:27pm
   
Why would you even consider Access for a multi user situation?
DrBones69 at 16-Jul-12 23:20pm
   
It's just another method that I could use, I don't particularly care for the backend/frontend seperation of the database, but it's just a thoughht.

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

For inventory control, I would definitely go towards an actual database. You said it yourself, it's going to get large fast, so relational databases are the best method of storing, recalling, and searching through large amounts of data. It might complicate things up front but it's definitely the right approach.
  Permalink  
Comments
SoMad at 16-Jul-12 22:35pm
   
I agree. Especially if you are going to be doing any database operations.
I will advice against binary serialization - once you start making changes in your data model the backwards compatibility handling becomes very nasty. Serializing to XML is a step up and compatibility is easier to handle, but can still require non-trivial updates to the code.

Soren Madsne
DrBones69 at 16-Jul-12 23:24pm
   
Would it be in my best interest to write the code in a network approach (ie. Internet compatible/capable)?
Albert Holguin at 16-Jul-12 23:48pm
   
Yes, that way your database doesn't have to be in the same computer as your client software. If you want a good model software package, see Bugzilla. They store everything to a database and allow the clients to access via internet browser, you don't have to necessarily do it via a browser but it does have a lot of advantages (platform independence, no need for client side installation, plus just about everyone knows how to use a browser).

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 379
1 Sascha Lefévre 200
2 Maciej Los 150
3 ProgramFOX 130
4 Sergey Alexandrovich Kryukov 110
0 Sergey Alexandrovich Kryukov 9,025
1 OriginalGriff 7,317
2 Maciej Los 3,570
3 Abhinav S 3,298
4 Peter Leow 3,084


Advertise | Privacy | Mobile
Web01 | 2.8.150427.1 | Last Updated 16 Jul 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100