using sqlite to replace CL tables

Homepage Clovertech Forums Read Only Archives Cloverleaf Cloverleaf using sqlite to replace CL tables

  • Creator
    Topic
  • #53564
    Gary Atkinson
    Participant

    I was wondering if others have tried this before.  Take the values in a static CL table and build them out into an sqlite database.  Then create a webpage where end-users could add or remove entries in the database.  Any ideas on how to do this would be great.  I have used sqlite a few times before, but never like I have described.

    Thanks,

    Gary

Viewing 0 reply threads
  • Author
    Replies
    • #78142
      Rob Lindsey
      Participant

      We have done that here at our site.  I have a person that built the front end to the SQLite database tables in PHP.  There is a library out there for it in java I believe but I do not know the full details.  It has worked well for our team as it keeps us out of having to update a lot of information.

      I also built a way to accept a CSV data file to Add, Change, Delete or List CL tables.  It sends an email to the user.  We have a Web Front end that allows the user to build the CSV file and it sends the data to a directory where I have a program that updates the table that the user has chosen.

      There are a lot of ways to do want you are wanting.  So it really just depends on how you want to do it and what things you know.

      Rob

Viewing 0 reply threads
  • The forum ‘Cloverleaf’ is closed to new topics and replies.

Forum Statistics

Registered Users
5,119
Forums
28
Topics
9,293
Replies
34,435
Topic Tags
286
Empty Topic Tags
10