Webapp from an existing database to manage digital collections

[kilele]

Hi. Is there some software to create a site from an existing database? It would inspect your database and automatically create pages, user interfaces, administration forms, multiadministration rights, file uploaders, etc.

[anandcoral]

It would inspect your database and automatically create pages, user interfaces, administration forms, multiadministration rights, file uploaders, etc.

WOW !!

It will kill us programmers, sure 

Regards,

Anand

[kilele]

Lol. You could always develop plugins to extend features.

I've just learnt about omeka.org : http://omeka.org/codex/Plugins/CSV_Import_2.0
That's the kind of software I had in mind, aiming at digital libraries (thread name edited).
Anything else you may recommend?

[IainB]

@kilele: Omeka looks like it could be pretty nifty for what you seem to be looking for. Have you trialled it? Might be worth a go.
There's some useful stuff comes out of the Roy Rosenzweig Center for History and New Media - https://chnm.gmu.edu/
For example, if you look at their Research + Tools page, you'll see the range, including Omeka and one that I have been increasingly making use of - their info manager, Zotero.

[kilele]

@IainB
I haven't tried Omeka yet though it has only a csv importer and I'd prefer a sql importer.

Vufind.org is another one with a robust user interface for searching. I think It can only import xml

Portofino.manydesigns.com looks like what I'm interested in but seems to have payware features

[kilele]

inveniosoftware.org by the CERN looks like a nice software with a powerful search system.

Another one very cool and simple to use, awesome-table.com
It takes a google spreadsheet and builds the user interface on the fly. No mysql here either.

[Shades]

https://www.sqlmaestro.com/products/mysql/phpgenerator/  - While it isn't cheap (159 USD is their lowest cost license), it appears to be able to do what you ask. Looks like they do have a trial version.

They have similar software for Oracle, Firebird, Postgres, MS-SQL, DB2, SQL lite, SQL anywhere and universal (ODBC) databases.

[kilele]

https://www.sqlmaestro.com/products/mysql/phpgenerator/  - While it isn't cheap (159 USD is their lowest cost license), it appears to be able to do what you ask. Looks like they do have a trial version.

They have similar software for Oracle, Firebird, Postgres, MS-SQL, DB2, SQL lite, SQL anywhere and universal (ODBC) databases.

I'll take a look at the lite version.

This one is similar: http://www.phpcodegeneratorpro.com
It costs the same but cannot be updated for free beyond the first year. The sqlmaestro's one extends the period to three years.

Actually I'd like something opensource, mantained by public institutions

[kilele]

Greenstone.org is a digital library cms funded by the UNESCO which has a "databaseplugin" to import existing databases: http://wiki.greenstone.org/doku.php?id=en:user_advanced:using_databaseplugin
You can also export their collections to be browsed on cd/dvd