Clovertech

using sqlite to replace CL tables

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

  • Creator
    Topic
  • March 14, 2013 at 4:32 pm #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

    • Creator
      Topic
    Viewing 0 reply threads
    • Author
      Replies
      • March 14, 2013 at 5:23 pm #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

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