Jump to content


Photo

RQ: SQLite


  • Please log in to reply
1 reply to this topic

#1 stream

stream

    Junior Member

  • Member
  • Pip
  • 20 posts
  • Main OS: Windows XP

Posted 21 February 2012 - 09:07 AM

Dear DevTeam,
can you plan integration of SQLite DB and of course web management as phpMyAdmin, but named SQLiteManager all under GPL
I'm sure, many of us here will be glad if you make it for us.

Thank you in advance!

#2 stream

stream

    Junior Member

  • Member
  • Pip
  • 20 posts
  • Main OS: Windows XP

Posted 03 March 2012 - 10:01 AM

Dear DevTeam,
after no answer I'll give HowTo I run it myself.

First you'll need latest available version of SQLiteManager 1.2.4 it's FREE!!!

and the latest SQLite 3.7.10

Extract the archive to C:\UniServer\home\Sqlitemanager

Edit in php.ini

....
;extension=php_pdo_pgsql.dll
extension=php_pdo_sqlite.dll
;extension=php_pgsql.dll
....
;extension=php_sockets.dll
extension=php_sqlite.dll
;extension=php_sqlite3.dll
....


Edit in httpd.conf

Alias /test_access "C:/UniServer/home/access/www/"
<Directory "C:/UniServer/home/access/www/">
Order allow,deny
Allow from all
</Directory>

Alias /sqlite "C:/UniServer/home/Sqlitemanager"
<Directory "C:/UniServer/home/Sqlitemanager">
Options All
AllowOverride AuthConfig
Order allow,deny
Allow from All
</Directory>


You can access SQLite Manager via Web Browser at: http://127.0.0.1/sqlite/index.php or http://localhost/sqlite/index.php

In bold I put what need to change to give both SQLite and SQLiteManager (like phpMyAdmin is web based)

Can somebody test and give me feedback and of course need to secure it via .htaccess (need help here) ???

Thanks in advance!

N.B. Smarty 3.1.8 as template engine will be good too to be added in my opinion and giant step with others WAMP competitors!
...and will be more useful for Web Developers.




2 user(s) are reading this topic

0 members, 2 guests, 0 anonymous users