Results 1 to 3 of 3

Thread: SQL db alternatives for user directory install

  1. #1
    Join Date
    May 2010

    SQL db alternatives for user directory install

    Okay, I have an odd problem I thought I'd throw out there, high concept ideas or links are more than okay:

    I have a customer who is redistributing my software (awesome). The customer originally wanted the software to be completely packaged within the folder (no DB access), and we originally handled this by updating and modifying configuration and user rights via flat file.

    I'm looking to update the software and there's a lot of things that would be marketable (secure, scalable, etc) to other customers if I handle these things through a database.

    I do not want to have to fork the development thread, so I got this crazy idea: If there were a micro db out there that supports SQL, then all I'd have to do is write a pair of wrappers.

    So what I'm wondering is if anyone has run across a very small DB (don't care about optimization, flat file is okay, expected size per table < 10-15 records, should be installable to a user directory) that supports SQL.

    Alternatively, if I have to roll my own, I was wondering if anyone knows any good ideas/tools/guidelines/pitfalls I should be watching for.


  2. #2
    Join Date
    Aug 2004
    Have you looked at PHP's SQLite extension?
    "Well done....Consciousness to sarcasm in five seconds!" ~ Terry Pratchett, Night Watch

    How to Ask Questions the Smart Way (not affiliated with this site, but well worth reading)

    My Blog
    cwrBlog: simple, no-database PHP blogging framework

  3. #3
    Join Date
    May 2010
    That actually seems like what I'm looking for.

    I actually finally ran into SQLlite after I posted my question last night but right before I had to go to bed, so I didn't get a chance to do any reading. I certainly didn't see the php extension for it.

    Thanks Nate.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center