Take the 2-minute tour ×
Programmers Stack Exchange is a question and answer site for professional programmers interested in conceptual questions about software development. It's 100% free, no registration required.

I'm an open source web application for use in my university. Currently professors usually have a website, but do to the fact that they're teaching multiple classes in a given term, they don't care to spend time and make an extensible, functional website.

The purpose of this project is to create an OSS website that can be dropped in place and enabled by simply running an init.php file.

I'm curious though as how to handle information storage for such a task. A full server database is a bit outside of the scope I'm looking for, but something like SQlite would fit very well.

The problem I'm running into is that not all departments have SQlite installed on their servers, and getting them all to do so won't happen.

Can anyone think of a way to include SQlite into an application where the drivers aren't already installed on the system, or a more common alternative that would provide a similar level of power/flexibility?

share|improve this question
1  
SQLite is an outboard DLL, not a device driver. Drop the DLL into the application folder, and see what happens. Your school may need to give the DLL permissions, but no installation is required. –  Robert Harvey Aug 28 '13 at 16:15
    
Don't you just need one server with a database installed on the server for all the sites to use? Seems like they're all on the same network? –  JeffO Aug 28 '13 at 17:12
    
@Jeffo: Not really. Every department has its own database, and they are not all using the same engines. I don't have access to each department that may want to use this application. –  Jacobm001 Aug 28 '13 at 17:16

1 Answer 1

Since you have this tagged as PHP...

For PHP versions 5.0 up to but not including 5.4, SQLite was included in PHP by default. So there's nothing to install unless your particular build was compiled specifically not to include it.

For later versions, you'll need to install the SQLite extension. On linux you can do this by installing the php5-sqlite3 package.

share|improve this answer
    
Based on your comment I did a little more checking and did a printout of phpinfo(). Looks like mysql and odbc are the only drivers enabled for PDO. Sqlite has been removed entirely :/ –  Jacobm001 Aug 28 '13 at 16:32
    
What version of php is it? It looks like the bundling of sqlite was recently changed. –  GrandmasterB Aug 28 '13 at 16:34
    
PHP 5.3.3-7+squeeze17 with Suhosin-Patch (cli) (built: Aug 23 2013 15:06:16) –  Jacobm001 Aug 28 '13 at 16:38
1  
See my above edit - they may need to install & enable the php-sqlite package. Since they have MySQL installed, you might consider just using that. That'd give you better application support since essentially every open source system php project that uses a database defaults to mysql. –  GrandmasterB Aug 28 '13 at 16:40

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.