Hi,
This is my first attempt of making a standalone application, so I would appreciate any help on this :)
I want to include in the program - that will be a .exe - a default dataset and give the user the option to use their own dataset.
What is the best way to do this, the recordset is about 3000 records long. Should I hardcode this? Or is there a way to bundle the dataset as a text file with the program.
Many thanks in advance
4  1487 
Hi,
This is my first attempt of making a standalone application, so I would appreciate any help on this :)
I want to include in the program - that will be a .exe - a default dataset and give the user the option to use their own dataset.
What is the best way to do this, the recordset is about 3000 records long. Should I hardcode this? Or is there a way to bundle the dataset as a text file with the program.
Many thanks in advance
Hand code: No.
3000 records? Too big for the registry.
Hmmm: True data base? Sounds like there's one in the application (details would be nice); SQL?, etc. In that case, I'd use a SQL script (extracted from your own db) and have the target db execute it.
Otherwise, the ConfigParser might be a good way to go.
Hi BartonC,
Thanks for the response. Currently I have the records in a text file that I open and read from a script. As I am trying to make the script a standalone application, and include the default dataset. Do you think it would be okay to bundle the text file with the program, and if the user selects "use default dataset" that it could just open "sample.txt" from there. I don't want to have to use a backend db with this. If I have to go down this route maybe sqllite would be a good idea?
Cheers for the response
Hi BartonC,
Thanks for the response. Currently I have the records in a text file that I open and read from a script. As I am trying to make the script a standalone application, and include the default dataset. Do you think it would be okay to bundle the text file with the program, and if the user selects "use default dataset" that it could just open "sample.txt" from there. I don't want to have to use a backend db with this. If I have to go down this route maybe sqllite would be a good idea?
Cheers for the response
Not sure if a .txt file counts as a resource in an executable.
Besides, if it's kept external, it's adjustable (like ini files).
Nor have I played with SQLLite.
What you could do is define your dataset in pure python: - class recordset:
-
attr1 = value1
-
# etc.
-
-
# or
-
-
recordset = (
-
(val1, val2, etc)
-
(val1, val2, etc)
-
(val1, val2, etc)
-
(val1, val2, etc)
-
)
and import that. This looks like hand coding, but could be generated from your text file.
It's really just a text file, but as long is you use python syntax/import it'll work.
Not sure if a .txt file counts as a resource in an executable.
Besides, if it's kept external, it's adjustable (like ini files).
Nor have I played with SQLLite.
What you could do is define your dataset in pure python: - class recordset:
-
attr1 = value1
-
# etc.
-
-
# or
-
-
recordset = (
-
(val1, val2, etc)
-
(val1, val2, etc)
-
(val1, val2, etc)
-
(val1, val2, etc)
-
)
and import that. This looks like hand coding, but could be generated from your text file.
It's really just a text file, but as long is you use python syntax/import it'll work.
Hehe, very nice idea indeed, it should also be bundled with the .exe automatically now.
Thanks :)
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Francisco |
last post by:
I have this problem:
I have a database with information about games, and users are able to vote
for them. Everytime a user votes for a game I store the unique game name
into a session variable (an...
|
by: Kay |
last post by:
A linked list is storing several names. I want to make a queue if I
input a name that is same as the linked list. How to make each node of a
linked list storing a queue that are different with each...
|
by: Dave |
last post by:
I have a system that basically stores a database within a database (I'm
sure lots have you have done this before in some form or another).
At the end of the day, I'm storing the actual data...
|
by: bissatch |
last post by:
Hi,
I am currently writing a news admin system. I would like to add the
ability to add images to each article.
What I have always done in the past is uploaded (using a form) the
image to a...
|
by: VMI |
last post by:
Is it possible to store the data in a datatable in the hard disk instead of
the memory? By default, when a datatable's being filled, the table (and
data) will remain in memory. Would it be possible...
|
by: Kyle Teague |
last post by:
What would give better performance, serializing a multidimensional array
and storing it in a single entry in a table or storing each element of
the array in a separate table and associating the...
|
by: (PeteCresswell) |
last post by:
User wants to go this route instead of storing pointers in the DB and the
documents outside.
Only time I tried it was with only MS Word docs - and that was a loooong time
ago - and it seemed to...
|
by: Martin Jørgensen |
last post by:
Hi,
I'm reading a number of double values from a file. It's a 2D-array:
1 2 3 4 5 6 7
-------------
1 3.2
2 0 2.1
3 9.3
4
|
by: Mike |
last post by:
I have developed an application, for psyc patients.... they type in
very personal information in a web form to help them work through
problems in their lives. Once they enter the info, I encrypt...
|
by: Falcolas |
last post by:
I personally feel that it's a bad idea. I've got to convince
managerial types of this.
Would some of you mind posting comments for and against the concept of
storing data in XML attributes? If...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
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$) {
}
...
|
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...
|
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
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
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...
|
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: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
