topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • Saturday October 5, 2024, 10:30 pm
  • Proudly celebrating 15+ years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: Webapp from an existing database to manage digital collections  (Read 5049 times)

kilele

  • Charter Member
  • Joined in 2006
  • ***
  • default avatar
  • Posts: 243
    • View Profile
    • Donate to Member
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.
« Last Edit: September 03, 2016, 12:21 PM by kilele »

anandcoral

  • Honorary Member
  • Joined in 2009
  • **
  • Posts: 783
    • View Profile
    • Free Portable Apps
    • Donate to Member
Re: Webapp from an existing database
« Reply #1 on: September 03, 2016, 05:03 AM »
 
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

  • Charter Member
  • Joined in 2006
  • ***
  • default avatar
  • Posts: 243
    • View Profile
    • Donate to Member
Re: Webapp from an existing database
« Reply #2 on: September 03, 2016, 05:06 AM »
Lol. You could always develop plugins to extend features.

I've just learnt about omeka.org : http://omeka.org/cod...ugins/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?
« Last Edit: September 03, 2016, 05:31 AM by kilele »

IainB

  • Supporting Member
  • Joined in 2008
  • **
  • Posts: 7,543
  • @Slartibartfarst
    • View Profile
    • Read more about this member.
    • Donate to Member
Re: Webapp from an existing database to manage a digital library
« Reply #3 on: September 03, 2016, 09:17 AM »
@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

  • Charter Member
  • Joined in 2006
  • ***
  • default avatar
  • Posts: 243
    • View Profile
    • Donate to Member
Re: Webapp from an existing database to manage a digital library
« Reply #4 on: September 03, 2016, 11:14 AM »
@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
« Last Edit: September 03, 2016, 01:49 PM by kilele »

kilele

  • Charter Member
  • Joined in 2006
  • ***
  • default avatar
  • Posts: 243
    • View Profile
    • Donate to Member
Re: Webapp from an existing database to manage digital collections
« Reply #5 on: September 03, 2016, 01:17 PM »
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

  • Member
  • Joined in 2006
  • **
  • Posts: 2,930
    • View Profile
    • Donate to Member
Re: Webapp from an existing database to manage digital collections
« Reply #6 on: September 03, 2016, 02:03 PM »
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

  • Charter Member
  • Joined in 2006
  • ***
  • default avatar
  • Posts: 243
    • View Profile
    • Donate to Member
Re: Webapp from an existing database to manage digital collections
« Reply #7 on: September 03, 2016, 06:11 PM »
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

  • Charter Member
  • Joined in 2006
  • ***
  • default avatar
  • Posts: 243
    • View Profile
    • Donate to Member
Re: Webapp from an existing database to manage digital collections
« Reply #8 on: September 04, 2016, 05:01 AM »
Greenstone.org is a digital library cms funded by the UNESCO which has a "databaseplugin" to import existing databases: http://wiki.greensto...using_databaseplugin
You can also export their collections to be browsed on cd/dvd
« Last Edit: September 04, 2016, 06:23 AM by kilele »