Hello,
I need to store data in some database for my application. I need database
for easy deployment (small size), that is reliable and maybe fast.
What database is best to use in this case?
Thanks in advance,
John 17 1236
On 2006-12-06, Matko <ov************@hotmail.comwrote:
Hello,
I need to store data in some database for my application. I need database
for easy deployment (small size), that is reliable and maybe fast.
What database is best to use in this case?
Thanks in advance,
John
If this is a small single app type database, I would look at either SQLite or
Firebird. Both have .NET data providers available. I haven't used Firebird,
but I have used SQLite a little bit and it is indeed fast and fairly capable -
and very small.
--
Tom Shelton
If this is a small single app type database, I would look at either SQLite
or
Firebird. Both have .NET data providers available. I haven't used
Firebird,
but I have used SQLite a little bit and it is indeed fast and fairly
capable -
and very small.
Hello Tom,
SQLite doesn't have cascade update and delete of records in database, so I
don't consider it as good database. What about Firebird? How much is easy to
deploy and how much is size of database compared to Access?
Regards,
John
* Matko wrote:
Hello,
I need to store data in some database for my application. I need database
for easy deployment (small size), that is reliable and maybe fast.
What database is best to use in this case?
Thanks in advance,
John
Jet?
what would the advantage of using this be over using say sql express?
I'm just about to start learning about databases, its a definate
weakness of mine. I have made access databases before (self taught) but
have always got lost when i've tried to learn how to interact c# with a
database.
I'm going to start again soon, as was going to use SQL server express
with C# express.
Is this the best way to learn?
(if it makes any difference i do have full versions of Visual Studio
and SQL server which were complimentary from an expo i attended about a
year ago, but i'm using the express editions as i'm at work and don't
have the full version with me)
Thankyou.
Gary.
Peter wrote:
If you don't absolutely have to have stored procedures, I've found that
SQLite far outperforms any other. No installation, the 2.0 ADO.NET version
includes the database engine in a single Assembly, thanks to Robert Simpson
and his excellent work:
http://sqlite.phxsoftware.com/
Peter
--
Co-founder, Eggheadcafe.com developer portal: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
"Matko" wrote:
Hello,
I need to store data in some database for my application. I need database
for easy deployment (small size), that is reliable and maybe fast.
What database is best to use in this case?
Thanks in advance,
John
On 6 Dec 2006 04:50:02 -0800, ga********@myway.com wrote:
what would the advantage of using this be over using say sql express?
Well, SQL Express is
1) A 50MB download
2) Requires installation
3) Requires many more resources to run
As opposed to SQL lite which is pretty much just a DLL that you will deploy
with your application. So if your target is small footprint, SQL Lite or
SQL Compact Edition is the way to go.
So if you have
--
Bits.Bytes http://bytes.thinkersroom.com
Matko,
For me listing to your question than any database is good enough. (Although
you have in my opinion not stated your question well if I see your comment
to Tom).
To be able to scale up in feature I would in your case use the SQLExpress or
SQLCompact edition.
In another newsgroup is Bill Vaughn, completely lyric about the last one, I
have myself no expirience with that.
However it depends of course for what you need it, and as you stated it,
again, any database is good as long as you can do a select.
Cor
"Matko" <ov************@hotmail.comschreef in bericht
news:el**********@ss408.t-com.hr...
Hello,
I need to store data in some database for my application. I need database
for easy deployment (small size), that is reliable and maybe fast.
What database is best to use in this case?
Thanks in advance,
John
I don't know if Peter uses an invoice but their is a lot of samples in it. http://www.vb-tips.com/dbpages.aspx?...6-0565bbc98609
Cor
"Matko" <ov************@hotmail.comschreef in bericht
news:el**********@ss408.t-com.hr...
Hello,
I need to store data in some database for my application. I need database
for easy deployment (small size), that is reliable and maybe fast.
What database is best to use in this case?
Thanks in advance,
John
Sorry,
Wrong place
Cor
"Cor Ligthert [MVP]" <no************@planet.nlschreef in bericht
news:et**************@TK2MSFTNGP04.phx.gbl...
>I don't know if Peter uses an invoice but their is a lot of samples in it.
http://www.vb-tips.com/dbpages.aspx?...6-0565bbc98609
Cor
"Matko" <ov************@hotmail.comschreef in bericht
news:el**********@ss408.t-com.hr...
>Hello,
I need to store data in some database for my application. I need database for easy deployment (small size), that is reliable and maybe fast. What database is best to use in this case?
Thanks in advance, John
Hi
In my view , selecting a database should be driven from Business
Requriment. If you need to handle very huge amount of data, need lot of
flexibility, scalability, security... go for something big...
If some of the factors can be compromised then go for little smaller
version...
I mean to say requirement should force the selection of database.
database could be as small as a simple spread sheet, and JET
database...or simply can stoore in an xml file also.
It is all about what exactly you require and what not ... right now and
in future...
Thanks
-Srinivas.
Matko wrote:
Hello,
I need to store data in some database for my application. I need database
for easy deployment (small size), that is reliable and maybe fast.
What database is best to use in this case?
Thanks in advance,
John
I mean to say requirement should force the selection of database.
>
database could be as small as a simple spread sheet, and JET
database...or simply can stoore in an xml file also.
It is all about what exactly you require and what not ... right now and
in future...
Yes, I know, but yet there are questions still there. I know I need small
database like Access. But what is better, Access, SQLite, MySQL , or some
similar database.
I need database that is small and easy to deploy on client computer.
Database filled with lots of data wont be larger then 25MB, or 50MB at most.
Thanks
Hi,
Is the data relational?
--
Dave Sexton
"Matko" <ov************@hotmail.comwrote in message
news:el**********@ss408.t-com.hr...
>I mean to say requirement should force the selection of database.
database could be as small as a simple spread sheet, and JET database...or simply can stoore in an xml file also.
It is all about what exactly you require and what not ... right now and in future...
Yes, I know, but yet there are questions still there. I know I need small
database like Access. But what is better, Access, SQLite, MySQL , or some
similar database.
I need database that is small and easy to deploy on client computer.
Database filled with lots of data wont be larger then 25MB, or 50MB at
most.
Thanks
Can SQLite be use with several simultaneous users (eg over a network, without any conflicts)? It
wasn't clear to me from their website.
"Peter Bromberg [C# MVP]" <pb*******@yahoo.nospammin.comwrote in message
news:C2**********************************@microsof t.com...
If you don't absolutely have to have stored procedures, I've found that
SQLite far outperforms any other. No installation, the 2.0 ADO.NET version
includes the database engine in a single Assembly, thanks to Robert Simpson
and his excellent work: http://sqlite.phxsoftware.com/
Peter
--
Co-founder, Eggheadcafe.com developer portal: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
"Matko" wrote:
Hello,
I need to store data in some database for my application. I need database
for easy deployment (small size), that is reliable and maybe fast.
What database is best to use in this case?
Thanks in advance,
John
If you need advanced database features like stored procedures then use SQL
Server 2005 Express
My understanding is that the primary drawback to SSE is that not many web
hosts support it.
Not that you can't migrate the data into SQL server, of course.
-Darrel
Matko wrote:
Hello,
I need to store data in some database for my application. I need database
for easy deployment (small size), that is reliable and maybe fast.
What database is best to use in this case?
Thanks in advance,
John
Let's recommend something entirererly different. No database used here,
just the objects! http://www.advogato.org/article/398.html
"intrader" <in******@aol.comwrote in message
news:1u******************@tornado.socal.rr.com...
Let's recommend something entirererly different. No database used here,
just the objects!
http://www.advogato.org/article/398.html
ROTFLMAO!!!
"Are you crazy? What if there's a system crash?
To avoid losing data, every night your system server saves a snapshot of all
business objects to a file using plain object serialization."
Best hope the system doesn't crash at 23:55... :-)
Mark Rae wrote:
"intrader" <in******@aol.comwrote in message
news:1u******************@tornado.socal.rr.com...
>Let's recommend something entirererly different. No database used here, just the objects!
http://www.advogato.org/article/398.html
ROTFLMAO!!!
"Are you crazy? What if there's a system crash?
To avoid losing data, every night your system server saves a snapshot of all
business objects to a file using plain object serialization."
Best hope the system doesn't crash at 23:55... :-)
Writing the log of commands first, then applying the commands is
entirely safe under any conditions. You can also get mirrors going quite
effectively.
Has anyone used SqLLite with an OR Mapping tool like Wilson?
--
With Regards
Shailen Sukul
..Net Architect
(MCPD: Ent Apps, MCSD.Net MCSD MCAD)
Ashlen Consulting Services http://www.ashlen.net.au
"Rad [Visual C# MVP]" <no****@nospam.comwrote in message
news:19****************************@40tude.net...
On 6 Dec 2006 04:50:02 -0800, ga********@myway.com wrote:
>what would the advantage of using this be over using say sql express?
Well, SQL Express is
1) A 50MB download
2) Requires installation
3) Requires many more resources to run
As opposed to SQL lite which is pretty much just a DLL that you will
deploy
with your application. So if your target is small footprint, SQL Lite or
SQL Compact Edition is the way to go.
So if you have
--
Bits.Bytes http://bytes.thinkersroom.com This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: lkrubner |
last post by:
I have a webserver through Rackspace. I create a domain. I create an
FTP user. I upload some files. I create a database called
testOfSetupScript and then I create a database user named setup.
I...
|
by: Andy |
last post by:
Hi All!
We are doing new development for SQL Server 2000 and also moving from
SQL 7.0 to SQL Server 2000.
What are cons and pros for using IDENTITY property as PK in SQL SERVER
2000?
Please,...
|
by: Sarah Tanembaum |
last post by:
Beside its an opensource and supported by community, what's the fundamental
differences between PostgreSQL and those high-price commercial database (and
some are bloated such as Oracle) from...
|
by: Sandman |
last post by:
Just looking for suggestion on how to do this in my Web application.
The goal is to keep track of what a user has and hasn't read and present him or
her with new material
I am currently doing...
|
by: Odd Bjørn Andersen |
last post by:
Every night at 21.30 we perform a full offline database backup. Just before the backup starts we do a db2stop/db2start. After the db2stop there is a message in the db2diag.log, and after the backup...
|
by: Midnight Java Junkie |
last post by:
Dear Colleagues:
I feel that the dumbest questions are those that are never asked. I have
been given the opportunity to get into .NET. Our organization has a
subscription with Microsoft that...
|
by: antonyliu2002 |
last post by:
I know that this has been asked and answered thousands of times. As a
matter of fact, I know that I need to say
If Not Page.IsPostBack Then
'Do something
End If
for things that needs to be...
|
by: Paul Brady |
last post by:
Apparently, I have been living on the wrong planet.
I have written 15 databases in Microsoft Access in the past 10
years, some of which are split, one uses ODBC interface with a SQL
server, one...
|
by: Darrel |
last post by:
I'm still having a hell of a time figuring out this whole SQL Express set
up.
I finally discovered why I couldn't run the aspnet_regsql...my local sql
server wasn't running.
I turned that on,...
|
by: okonita |
last post by:
Hi all,
I am having a DB2 connectivity problem that I hope someone can help me resolve. I need this to test Replication and such other things. What am I doing wrong here? Any help that
I can get...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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: 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: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
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...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |