General advice about simple table storage.
-
I need some general advice. (My natural language is Portuguese). I need to do a small Windows desktop application to fill (by hand) a single table with, say, a maximum of one thousand records of some 20 fields for later manipulation. About 15 years ago I have done a database application in Access 2003 whose tables were separately stored (same folder) without a SQL server. I would like to stay away from Access and use Visual Studio Community and, also, stay away from a SQL server or the need to have it installed in the computers where the application will run. I suppose that to crate a table in a form must not be complicated (I have already played a little bit with that) but I am at a lost about storing the table on disk without SQL database/server. All examples I found in the Web involve SQL servers. Simplifying, I need to make a standalone application able to create, store and read a separate datafile. Saving the table in Excel format or similar would be acceptable because importing some data from excel could eventually be interesting. The application final output would be some ASCII file with delimited data but this file is not supposed to be read by the application. At the moment I am flying around without a place to land. Any help would be greatly appreciated. H. Martins
-
I need some general advice. (My natural language is Portuguese). I need to do a small Windows desktop application to fill (by hand) a single table with, say, a maximum of one thousand records of some 20 fields for later manipulation. About 15 years ago I have done a database application in Access 2003 whose tables were separately stored (same folder) without a SQL server. I would like to stay away from Access and use Visual Studio Community and, also, stay away from a SQL server or the need to have it installed in the computers where the application will run. I suppose that to crate a table in a form must not be complicated (I have already played a little bit with that) but I am at a lost about storing the table on disk without SQL database/server. All examples I found in the Web involve SQL servers. Simplifying, I need to make a standalone application able to create, store and read a separate datafile. Saving the table in Excel format or similar would be acceptable because importing some data from excel could eventually be interesting. The application final output would be some ASCII file with delimited data but this file is not supposed to be read by the application. At the moment I am flying around without a place to land. Any help would be greatly appreciated. H. Martins
Member 15078113 wrote:
suppose that to crate a table in a form must not be complicated
It's not; I'd recommend SQLite, if you familiar with databases. It's free and small. Also comes without UI, but you can download those separate.
Member 15078113 wrote:
Simplifying, I need to make a standalone application able to create, store and read a separate datafile. Saving the table in Excel format or similar would be acceptable
Then EPPlus or LinqToExcel might be more suitable.
Member 15078113 wrote:
The application final output would be some ASCII file with delimited data but this file is not supposed to be read by the application.
That's your fourth option; CSV files. A few thousand records would hardly be a speed-problem on modern machines (anything that can run .NET).
Bastard Programmer from Hell :suss: "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
-
Member 15078113 wrote:
suppose that to crate a table in a form must not be complicated
It's not; I'd recommend SQLite, if you familiar with databases. It's free and small. Also comes without UI, but you can download those separate.
Member 15078113 wrote:
Simplifying, I need to make a standalone application able to create, store and read a separate datafile. Saving the table in Excel format or similar would be acceptable
Then EPPlus or LinqToExcel might be more suitable.
Member 15078113 wrote:
The application final output would be some ASCII file with delimited data but this file is not supposed to be read by the application.
That's your fourth option; CSV files. A few thousand records would hardly be a speed-problem on modern machines (anything that can run .NET).
Bastard Programmer from Hell :suss: "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
Thank you very much. I have been fighting Visual Studio for a couple hours and managed to create the basic GridView configuration. Although in the much simpler Arduino environment, I am familiarized with C and I have recently written a couple Classes ( I should have started before :) ). Nevertheless helped by some web browsing I suppose I can handle the code behind the forms. I decided to leave Excel for later and concentrate in creating and reading CVS files.
Then EPPlus or LinqToExcel might be more suitable.
Thank you again.
-
I need some general advice. (My natural language is Portuguese). I need to do a small Windows desktop application to fill (by hand) a single table with, say, a maximum of one thousand records of some 20 fields for later manipulation. About 15 years ago I have done a database application in Access 2003 whose tables were separately stored (same folder) without a SQL server. I would like to stay away from Access and use Visual Studio Community and, also, stay away from a SQL server or the need to have it installed in the computers where the application will run. I suppose that to crate a table in a form must not be complicated (I have already played a little bit with that) but I am at a lost about storing the table on disk without SQL database/server. All examples I found in the Web involve SQL servers. Simplifying, I need to make a standalone application able to create, store and read a separate datafile. Saving the table in Excel format or similar would be acceptable because importing some data from excel could eventually be interesting. The application final output would be some ASCII file with delimited data but this file is not supposed to be read by the application. At the moment I am flying around without a place to land. Any help would be greatly appreciated. H. Martins
I think you should check out MD Python (Free) - LabDeck[^] its got all the features you need.They also have examples on working with Databases(all the major ones) and they can also import data from excel.This is the example page that I think will help you (Database - LabDeck[^]) and (Python Database - LabDeck[^]) they also do have UIs for databses (Drag and drop Python GUI Designer - LabDeck[^]).This should help you as it gives you the bases and examples that will help you along with some cool features.
-
Member 15078113 wrote:
suppose that to crate a table in a form must not be complicated
It's not; I'd recommend SQLite, if you familiar with databases. It's free and small. Also comes without UI, but you can download those separate.
Member 15078113 wrote:
Simplifying, I need to make a standalone application able to create, store and read a separate datafile. Saving the table in Excel format or similar would be acceptable
Then EPPlus or LinqToExcel might be more suitable.
Member 15078113 wrote:
The application final output would be some ASCII file with delimited data but this file is not supposed to be read by the application.
That's your fourth option; CSV files. A few thousand records would hardly be a speed-problem on modern machines (anything that can run .NET).
Bastard Programmer from Hell :suss: "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
Eddy Vluggen wrote:
SQLite, if you familiar with databases. It's free and small.
Microsoft SQL Server Developer edition is also free AND comes with free tools.
-
Eddy Vluggen wrote:
SQLite, if you familiar with databases. It's free and small.
Microsoft SQL Server Developer edition is also free AND comes with free tools.
..but not exactly simple; a server, and launches a service-process. Also a bit larger than SQLite.
Bastard Programmer from Hell :suss: "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.