Clovertech

sqlite

› Clovertech Forums › Read Only Archives › Cloverleaf › Cloverleaf › sqlite

  • Creator
    Topic
  • October 4, 2007 at 8:54 am #49561
    garry r fisher
    Participant

      Hi,

      Trying to use the Tcl bindings with sqlite on Cloverleaf v5.3 on W2K.

      I can get sqlite to work quite happily if I copy the dll to the lib directory of my Activestate install. Obviously this won’t work on Cloverleaf so I copied it to the local Tcl/Lib directory but it isn’t recognised as a command. Looking at a number of forums/website they suggest using a pkgIndex so I created one and it still doesn’t work.

      Can somebody provide me with the definitive installation instructions for tclsqlite3.dll? I want to use it on a production system and need to test it first – At the moment as you can see my testing is failing miserably:-(

      Regards

      Garry

    • Creator
      Topic
    Viewing 9 reply threads
    • Author
      Replies
      • October 4, 2007 at 11:18 am #62479
        Charlie Bursell
        Participant

          You need to build a pkgIndex file and put that in the Tcl path.  Since Tcl will search one level deeper than the paths defined in the auto_path variable, I typically put my phkIndex file in $HCISITEDIR/tclprocs/lib. As a matter of fact I usually put my database there as well.

          sqlite is great.  You will like it

        • October 4, 2007 at 11:58 am #62480
          garry r fisher
          Participant

            Thanks Charlie,

            Setup as you described. Something is not quite right. I start tcl, type ‘package require sqlite3’ and it drops back out to cmd.

            I edited my pkgIndex.tcl manually – is that correct? Can you suggest any other reason why its not working? Very odd.

            UPDATE : Spent a bit more time with it and read through the relevant chapter in Brent Welsh – I can get it to work in 5.4.1 but not in 5.3. Unfortunately for me the production system is on 5.3. Going copy the pkgIndex.tcl from the 5.4.1 to 5.3 directory and see if works.

            UPDATE 2: No – That doesn’t work either. Tcl scripts run fine for most commands but if I try and do ‘package require sqlite3’ or pkg_mkIndex …. then it drops out of Tcl without reporting an error. I’ve tried it on two different 5.3 installs and they both do the same. So is it Tcl or the Windows version of Tcl causing the problem – 5.3 uses Tcl 8.3 while 5.4.1 uses Tcl 8.4.

            Any ideas anyone?

            Regards

            Garry

          • October 5, 2007 at 3:50 pm #62481
            Charlie Bursell
            Participant

              Send me an e-mail and I will send you what I have

            • October 5, 2007 at 6:47 pm #62482
              Gary Atkinson
              Participant

                I’m curious  8) Is there a version for AIX?

              • October 5, 2007 at 7:22 pm #62483
                Charlie Bursell
                Participant

                  Yes, you may have to compile it

                • January 13, 2009 at 3:58 pm #62484
                  Bala Pisupati
                  Participant

                    I have ftp’ed tclsqlite-3.6.8.so on my redhat linux4.o platform. Can anyone tell me how to run the .so. I am really new to sqlite.

                  • January 13, 2009 at 4:39 pm #62485
                    Tom Rioux
                    Participant

                      We are on a UNIX platform but I’m assuming it will pretty much the same.  Take the .so file and move it to you $HCISITEDIR/tclprocs/libs directory.   You will need to do this for every site you are using sqlite in.  (I’m not sure if putting in a master site on 5.6 will work for all sites or not).  When you begin to write your code, you will need to include the following line at the beginning of your proc:

                      package require sqlite

                      Let me know if you have any more questions.   You can do a search on here for sqlite.  There are many helpful threads on here that can get you started and provide good information in getting you started in writing your code.

                      Hope this helps….

                      Tom Rioux

                      Baylor Health Care Systems

                    • January 13, 2009 at 4:44 pm #62486
                      Tom Rioux
                      Participant

                        One last note on the sqlite…Did you get your tclsqlite-3.6.8.so file from Healthvision.  I remember a couple of months ago when I was attempting to run my code, I kept getting an error.  I worked with Dean B. from Healthvision regarding the error and was told the file was one they were working on to be released with 5.7.  It wasn’t working quite like it should yet and I had to use the libsqlite3.3.4.so file instead.  Works just as good.  I think I remember this correctly and I’m not sure if the errors have been cleared up or not.

                        Hope this helps…

                        Tom Rioux

                        Baylor Health Care System

                      • January 13, 2009 at 5:04 pm #62487
                        Bala Pisupati
                        Participant

                          Thanks for your replies.

                          I got this from http://www.sqlite.org/download.html not from HealthVision

                        • January 13, 2009 at 6:28 pm #62488
                          Tom Rioux
                          Participant

                            My advice to you is to contact Healthvision support and get the sqlite version that is compatible with the Cloverleaf version you are currently running.  They are very helpful and can get you started.

                            As far creating your database, the command to do that is:

                            sqlite DBCMD .db

                            You can do this from your script that you write.

                            Thanks….

                            Tom Rioux

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