Skip to content
The generic Database Frontend for Endusers
JavaScript Perl CSS Shell
Latest commit 4a23659 Apr 9, 2014 @oetiker Merge pull request #18 from maettu/master
sync maettus changes
Failed to load latest commit information.
backend MojoApp.pm uses $self->secrets instead of $self->$secret Apr 8, 2014
demo Created ptptest database as demo for DbToRia website. Apr 28, 2011
frontend
setup @ ba281fd * use real regexps in GedafeSQL.pm table and toolbar configuration May 9, 2011
website
.gitignore
.gitmodules switch to sdbs in building Apr 28, 2011
README.pod README more qx 3.5 links found.. Apr 8, 2014
TODO.pod
WISHLIST.pod Created menu button class. Apr 29, 2011

README.pod

NAME

DbToRia - Database to Rich Internet Application

DESCRIPTION

DbToRia is generic SQL database frontend. Just point it to your database and get a user friendly web interface. By providing DbToRia with additional information about the nature of your database the user interface can be further optimized.

SETUP

Backend

Mojo:

 cpanm  Mojolicious
 cpanm  MojoX::Dispatcher::Qooxdoo::Jsonrpc

Json:

 cpanm  JSON::XS
 cpanm  Mojo::JSON::Any

DB:

 cpanm  DBI
 cpanm  DBD::(put-your-driver-here)

For quick results use testing-db (which is a SQLite):

 cpanm  DBD::SQLite

Other modules needed:

 cpanm  Config::Grammar
 cpanm  Try::Tiny

Edit the backend/etc/dbtoria.cfg file to point to the database of your choice.

For quick results put this in your backend/etc/dbtoria.cfg:

 *** General ***
 dsn = DBI:SQLite:dbname=../backend/t/sqlite_db/dbtoria_test_db

 mojo_secret = MyCookieSecret
 log_file = /tmp/dbtoria.log
 schema = public
 encoding = latin

Frontend

Get Qooxdoo SDK:

 wget http://downloads.sourceforge.net/qooxdoo/qooxdoo-3.5-sdk.zip
 unzip qooxdoo-3.5-sdk.zip

 cd frontend

If you just want to build the production ready version of the frontend:

 ./generate.sh ../qooxdoo-3.5-sdk build

If you want start hacking and debuging the frontend, build the source version by calling

 ./generate.sh ../qooxdoo-3.5-sdk source

 cd ..

Have Fun(tm)

Run DbToRia with its built-in webserver for testing:

 ./backend/bin/dbtoria.pl daemon

And point your browser at

 L<http://localhost:3000>

BACKGROUND

DbToRia contains of two parts. One is the backend which uses Perls Mojo Web Framework, its Jsonrpc-Dispatcher and some Perl code to interact with the database. The other is the frontend which uses the JavaScript Qooxdoo Framework for Rich Internet Applications and some JavaScript code to build the website you interact with.

The frontend sends json rpc requests which are handled by the backend. After the requested information is sent back using json, too, the view is updated.

Something went wrong with that request. Please try again.