www.webdeveloper.com
Results 1 to 3 of 3

Thread: SQL db alternatives for user directory install

  1. #1
    Join Date
    May 2010
    Posts
    168

    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.

    Best!
    Janus

  2. #2
    Join Date
    Aug 2004
    Location
    Ankh-Morpork
    Posts
    19,322
    Have you looked at PHP's SQLite extension?
    "Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
    ~ Terry Pratchett in Nation

    eBookworm.us

  3. #3
    Join Date
    May 2010
    Posts
    168
    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



Recent Articles