Running a Database on a USB Flash Drive

  • Thread starter Thread starter will.leighton
  • Start date Start date
W

will.leighton

I am working on concept where I want to deliver web-based content and
functionality from a USB Flash drive for users who don't have access to
the Internet. The functionality includes personaliztion features and
preferences that will alter how the pages are served. It is a classic
three-tier model. Does anyone have experience running a database on a
USB flash drive and if so could you tell me:

1. Which database (Access, FoxPro, etc...) did you use or would you
recommend using?

2. What problems did you encounter?

3. Do you have any other ideas on technologies I could implement?

Thanks in advance.

Will
 
I am working on concept where I want to deliver web-based content and
functionality from a USB Flash drive for users who don't have access to
the Internet. The functionality includes personaliztion features and
preferences that will alter how the pages are served. It is a classic
three-tier model. Does anyone have experience running a database on a
USB flash drive and if so could you tell me:

1. Which database (Access, FoxPro, etc...) did you use or would you
recommend using?

2. What problems did you encounter?

3. Do you have any other ideas on technologies I could implement?

Thanks in advance.

Will
Click to expand...

Try inserting the flash drive into your rectum and then sticking your tongue
in the USB port on the computer. Use a mirror to see if the drive light
blinks or have your partner watch.
 
["Followup-To:" header set to comp.os.linux.hardware.]
I am working on concept where I want to deliver web-based content and
functionality from a USB Flash drive for users who don't have access to
the Internet. The functionality includes personaliztion features and
preferences that will alter how the pages are served. It is a classic
three-tier model. Does anyone have experience running a database on a
USB flash drive and if so could you tell me:
Click to expand...
A flash drive shouldn't be different from any other drive, other than the
lifetime limit on the number of writes per sector. If your application is
read-only or read-mostly, you can use whatever database you prefer.
 
In said:
I am working on concept where I want to deliver web-based content and
functionality from a USB Flash drive for users who don't have access to
the Internet. The functionality includes personaliztion features and
preferences that will alter how the pages are served. It is a classic
three-tier model. Does anyone have experience running a database on a
USB flash drive and if so could you tell me:

1. Which database (Access, FoxPro, etc...) did you use or would you
recommend using?

2. What problems did you encounter?

3. Do you have any other ideas on technologies I could implement?

Thanks in advance.
Click to expand...

USB key shows up as SCSI harddisk (/dev/sda). Not much different,
except for limit on the number of writes. So, you should try to
minimize writes, eg. 'noatime', ramdisk for /var, ...

See my .sig for Linux running on USB key.

--
William Park <[email protected]>, Toronto, Canada
ThinFlash: Linux thin-client on USB key (flash) drive
http://home.eol.ca/~parkw/thinflash.html
BashDiff: Super Bash shell
http://freshmeat.net/projects/bashdiff/
 
I am working on concept where I want to deliver web-based content and
functionality from a USB Flash drive for users who don't have access to
the Internet. The functionality includes personaliztion features and
preferences that will alter how the pages are served. It is a classic
three-tier model. Does anyone have experience running a database on a
USB flash drive and if so could you tell me:

1. Which database (Access, FoxPro, etc...) did you use or would you
recommend using?
Click to expand...

for embedded database, firebird is the best. see
http://firebird.sourceforge.net/

Firebird is the open-sourced interbase. Unlike the toy db m$-access, it
supports stored procedures and triggers, and also provides native
ADO.NET, ODBC and JDBC drivers, yet it uses very few RAM (less than
10MB).
 
Back
Top