I can't make up my own mind!!!! A LITTLE HELP PLEASE!!

Question

3.00/5 (2 votes)

See more:

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 15:57pm

DrBones69

Add a Solution

Comments

[no name] 16-Jul-12 22:27pm

Why would you even consider Access for a multi user situation?

DrBones69 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

Add a Solution

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

Albert Holguin · Accepted Answer · 2012-07-16T16:02:00

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.

Posted 16-Jul-12 16:02pm

Albert Holguin

Comments

SoMad 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 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 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).

I can't make up my own mind!!!! A LITTLE HELP PLEASE!!

1 solution

Solution 1

Add your solution here

Preview 0

I can't make up my own mind!!!! A LITTLE HELP PLEASE!!

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us