473,382 Members | 1,376 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

Where is the best place to store such data

I have some data values that will will rarely change over the life of the
program. I don't think it is wise to save it in a database. Is it ok to save
them in Properties.Settings if I have many different values? Example I want
to save information about the user of the software, eg, name, address,
telephone #.
--
L. A. Jones
Oct 29 '06 #1
4 1778
Hi Dave,

When you say, "many different values", how many are we talking about?

Other options are the AppSettings in the .config file, a custom XML file, a
custom flat-file and the system registry. You've excluded the database as an
option, and I agree with that choice only if you don't need to establish any
relationships with data that is going to be stored in the database. Using
Settings in VS 2005 will require the least effort on your part for persisting
the data in your example, but if you have relational data then you should
think about using a structured format such as XML, or even consider the
database, regardless of its static nature.

--
Dave Sexton

"Dave" <Da**@discussions.microsoft.comwrote in message
news:9D**********************************@microsof t.com...
>I have some data values that will will rarely change over the life of the
program. I don't think it is wise to save it in a database. Is it ok to save
them in Properties.Settings if I have many different values? Example I want
to save information about the user of the software, eg, name, address,
telephone #.
--
L. A. Jones

Oct 29 '06 #2
What did I mean by "many different values"? I meant if I want to store
information about an entity which has say 'n' attributes, however, if I
should use a table, then it be '1xn' (row by column) table. Is this an
acceptable use of a table? What is the de facto (or popular) standard for
saving such data?
--
L. A. Jones
"Dave Sexton" wrote:
Hi Dave,

When you say, "many different values", how many are we talking about?

Other options are the AppSettings in the .config file, a custom XML file, a
custom flat-file and the system registry. You've excluded the database as an
option, and I agree with that choice only if you don't need to establish any
relationships with data that is going to be stored in the database. Using
Settings in VS 2005 will require the least effort on your part for persisting
the data in your example, but if you have relational data then you should
think about using a structured format such as XML, or even consider the
database, regardless of its static nature.

--
Dave Sexton

"Dave" <Da**@discussions.microsoft.comwrote in message
news:9D**********************************@microsof t.com...
I have some data values that will will rarely change over the life of the
program. I don't think it is wise to save it in a database. Is it ok to save
them in Properties.Settings if I have many different values? Example I want
to save information about the user of the software, eg, name, address,
telephone #.
--
L. A. Jones


Oct 29 '06 #3
Hi Dave,

I wasn't asking what you meant by that statement. I was asking for
quantification.

Exactly how much is "many"?

If your answer is 10000 then I'm probably going to recommend using a database
table. If your answer is 5, unrelated, arbitrary pieces of information, I'd
probably recommend Settings. If your answer is 20, static, hierarchically
related pieces of information then I'll probably recommend XML.

Where you store data all depends on relationship, quantity, type and use.
Your choice may also depend on other things such as security, performance,
scalability, interoperability, flexibility, ease of use, ease of management,
and I'm sure other variables as well.

Settings is great for data that needs to be easy to add at design-time, easy
to code for read/write at runtime, isn't required in large quantities, isn't
complex, isn't related or hierarchical in nature, and when security isn't
required.

The data you've cited in your example seems most appropriate in Settings, from
the limited information you've stated thus far.

--
Dave Sexton

"Dave" <Da**@discussions.microsoft.comwrote in message
news:FC**********************************@microsof t.com...
What did I mean by "many different values"? I meant if I want to store
information about an entity which has say 'n' attributes, however, if I
should use a table, then it be '1xn' (row by column) table. Is this an
acceptable use of a table? What is the de facto (or popular) standard for
saving such data?
--
L. A. Jones
"Dave Sexton" wrote:
>Hi Dave,

When you say, "many different values", how many are we talking about?

Other options are the AppSettings in the .config file, a custom XML file, a
custom flat-file and the system registry. You've excluded the database as
an
option, and I agree with that choice only if you don't need to establish
any
relationships with data that is going to be stored in the database. Using
Settings in VS 2005 will require the least effort on your part for
persisting
the data in your example, but if you have relational data then you should
think about using a structured format such as XML, or even consider the
database, regardless of its static nature.

--
Dave Sexton

"Dave" <Da**@discussions.microsoft.comwrote in message
news:9D**********************************@microso ft.com...
>I have some data values that will will rarely change over the life of the
program. I don't think it is wise to save it in a database. Is it ok to
save
them in Properties.Settings if I have many different values? Example I
want
to save information about the user of the software, eg, name, address,
telephone #.
--
L. A. Jones



Oct 29 '06 #4
Thank you.
--
L. A. Jones
"Dave Sexton" wrote:
Hi Dave,

I wasn't asking what you meant by that statement. I was asking for
quantification.

Exactly how much is "many"?

If your answer is 10000 then I'm probably going to recommend using a database
table. If your answer is 5, unrelated, arbitrary pieces of information, I'd
probably recommend Settings. If your answer is 20, static, hierarchically
related pieces of information then I'll probably recommend XML.

Where you store data all depends on relationship, quantity, type and use.
Your choice may also depend on other things such as security, performance,
scalability, interoperability, flexibility, ease of use, ease of management,
and I'm sure other variables as well.

Settings is great for data that needs to be easy to add at design-time, easy
to code for read/write at runtime, isn't required in large quantities, isn't
complex, isn't related or hierarchical in nature, and when security isn't
required.

The data you've cited in your example seems most appropriate in Settings, from
the limited information you've stated thus far.

--
Dave Sexton

"Dave" <Da**@discussions.microsoft.comwrote in message
news:FC**********************************@microsof t.com...
What did I mean by "many different values"? I meant if I want to store
information about an entity which has say 'n' attributes, however, if I
should use a table, then it be '1xn' (row by column) table. Is this an
acceptable use of a table? What is the de facto (or popular) standard for
saving such data?
--
L. A. Jones
"Dave Sexton" wrote:
Hi Dave,

When you say, "many different values", how many are we talking about?

Other options are the AppSettings in the .config file, a custom XML file, a
custom flat-file and the system registry. You've excluded the database as
an
option, and I agree with that choice only if you don't need to establish
any
relationships with data that is going to be stored in the database. Using
Settings in VS 2005 will require the least effort on your part for
persisting
the data in your example, but if you have relational data then you should
think about using a structured format such as XML, or even consider the
database, regardless of its static nature.

--
Dave Sexton

"Dave" <Da**@discussions.microsoft.comwrote in message
news:9D**********************************@microsof t.com...
I have some data values that will will rarely change over the life of the
program. I don't think it is wise to save it in a database. Is it ok to
save
them in Properties.Settings if I have many different values? Example I
want
to save information about the user of the software, eg, name, address,
telephone #.
--
L. A. Jones


Oct 30 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Marco Aschwanden | last post by:
I want to store a file in the application directory. What is the easiest way to figure out, where my application is situated? sys.argv does not work for my purposes... do you have any other...
8
by: Charlie | last post by:
Hi: My ASP.NET app opens and closes database connection in several pages. Rather than hard coding string into every page, is there a place I can put it where all pages will be able to access it....
4
by: Marco | last post by:
Hi to All, I'm developing an application in VB .NET. I have a question: what is the best place to save personal settings of my users? I mean, when a user uses my application, it can create a...
4
by: Ranginald | last post by:
Hi, I am generally new to OOP and in learning and writing code I have developed many of my own reusable methods. A. What is the best way to store these methods for easy reuse later? I was...
10
by: Paul Cheetham | last post by:
Hi, I am developing an application that needs to store some machine-specific settings. The application is going to be published on the network in order to keep the clients on the latest version....
10
by: Mike9900 | last post by:
Hello, I would like to store application expiration date in a file and store that file in a secure place, so the application can access the file for all the users on that computer. ...
0
by: Jarod | last post by:
Hey I need to share data from many users ( Chat application ). What's the best place to store last 30 messages ? Static generic list's ? Where to store user specific data like logins and last...
2
by: WB | last post by:
I have an app that will need to store hostorical data (path & filenames) in a combo box (so that the user doesn't have to type in the same data each time the app is restarted). Is it best to keep...
12
by: Jeff | last post by:
I need to read about 100 lines of a csv file into memory. Each line contains 6 fields. What is the best way to store this into memory and then read it back. Is a array of a multi- dimsion...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.