query .db databases

Jack_18

Hi all I need to work on databases that have .db extension. My boss insists that this type of database is the fastest. i tried searching for it and found that its a thumbnail database on filext.com I need to put text on the database and am sure its possible. and on googling I found several links for java,etc. I don't know nothing about .db files but I know how to handle ADO.NET Help me with some info about them like its source website,etc (any info is welcome) Thanks

DaveAuld

Just because it has a .db extension doesn't mean to say that the database type (e.g. ms-sql, mysql, dbase) is the one you think it is. Your boss needs to tell you what the exact type is, and what version it is. From here you can find the correct api libraries and connectors etc, that you will need for interacting with the database

Dave Don't forget to rate messages!
Find Me On: Web|Facebook|Twitter|LinkedIn
Waving? dave.m.auld[at]googlewave.com

DaveAuld

As you will see there are 18 possibilities known on filext.com http://filext.com/file-extension/DB[^] hence the importance of knowing exactly what you are working with.

Dave Don't forget to rate messages!
Find Me On: Web|Facebook|Twitter|LinkedIn
Waving? dave.m.auld[at]googlewave.com

Jack_18

thanks for the reply. My boss says that it should has the extension of .db Thats the only matter with him. He's a jerk. I will now give an overview of my (strictly my boss') the database extension should be .db (I dunno why he's sticking with that) only one table is required. the application should run on any windows with .net 3.5 (he calls that portable) the read/write speed should be fast. that's all.

DaveAuld

Jack_18 wrote:

He's a jerk.

And thats a good way to get fired!

Dave Don't forget to rate messages!
Find Me On: Web|Facebook|Twitter|LinkedIn
Waving? dave.m.auld[at]googlewave.com

Jack_18

He knows me by another name. anyway I don't think he visits the coding forums! ;)

loyal ginger

Since your boss wants to use .db files, and the database only has one table, it's up to you to decide on which database to use. It sounds like it's a light-weight database, and no concurrency is involved. If that is the case, I suggest that you use SQLite. The database file used by SQLite can be named using any extension, so you just use .db. SQLite is fast, so your boss will be happy. If you use C/C++, you can use the source code of SQLite directly in your program. For C++ there are a few wrappers available that greatly simplify the use of SQLite. If you use C#/VB.NET, then ADO.NET implementations are available, making it very easy to use.

Jack_18

hey thanks buddy! will that be portable? the exe file should run without the need of any dlls.

Jack_18

I performed some search and found that you need "sqlite.dll" in the same folder as the exe file. I know its only 441 KB in size but its my boss. He's mad. can you give me any other choices?

Dave Kreskowiak

There are no other choices. Any database you use with it's own provider is going to a) provide the best performance and b) require the use of a library (.DLL's) to do it.

A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...