Embedded Database

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

Embedded Database

Logged in as: Guest

arrSession:exec spGetSession 2,9,37732

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [General Forum] >> Off-Topic Lounge >> Embedded Database
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

Embedded Database - 9/13/2006 5:32:39 PM

Mr.No

Posts: 6
Score: 0
Joined: 11/18/2005
Status: offline

Hi

I'm looking for a small footprint embedded database such as SQLite that I could use with my VBScript scripts. It should ideally hold in a single file and shouldn't be too resource hungry on the machine.

Thanks

Post #: 1

RE: Embedded Database - 9/13/2006 6:00:26 PM

Snipah

Posts: 1341
Score: 6
Joined: 11/1/2004
From: Netherlands
Status: offline

wat do you wish to store in that database?

_____________________________

For more information, please see the "Read me First" topic.

http://www.visualbasicscript.com

(in reply to Mr.No)

Post #: 2

RE: Embedded Database - 9/14/2006 12:48:16 AM

Mr.No

Posts: 6
Score: 0
Joined: 11/18/2005
Status: offline

I'd like to use the embedded database as a temporary storage for soting, grouping for onward output creatiion. Let me elaborate on my task. I have a VB6 DLL that reads data from a proprietary format and exposes a fabricated ADO recordset. My VBScript script instantiates the DLL, and processes one batch at a time. So what i want is to proceed as follows:

Instantiate the DLL
Pick up a batch and get a fabricated recordset from the DLL
Load the recordset into a work table in my database
Repeat steps 2 and 3 until I've read all available batches
Use the loaded data to generate summaries, perform groupings etc.

I can of course do this using a standard database like SQL server or Access but I prefer the simple file approach of embedded databases like Sqlite.

Cheers

(in reply to Snipah)

Post #: 3

RE: Embedded Database - 9/14/2006 7:11:59 AM

Snipah

Posts: 1341
Score: 6
Joined: 11/1/2004
From: Netherlands
Status: offline

This sounds that an Application (VB) can better handle this (and would) than VBScript, which is superb in administrative tasks....

_____________________________

For more information, please see the "Read me First" topic.

http://www.visualbasicscript.com

(in reply to Mr.No)

Post #: 4

RE: Embedded Database - 9/14/2006 4:51:57 PM

Mr.No

Posts: 6
Score: 0
Joined: 11/18/2005
Status: offline

Thanks for your input. But I want the flexibility of the script. In the meantime I've found http://republika.pl/roed/litex/automation.html
I'll probably give it a try.

(in reply to Snipah)