sqlite3-regex.so

Homepage Clovertech Forums Cloverleaf sqlite3-regex.so

  • Creator
    Topic
  • #121600
    RICK L. PRITCHETT
    Participant

    Hi everyone,

    I am guessing this needed to do regex with sqlite.  So far I keep getting that sqlite3 is not a column. Does anyone have a suggestion?

    db eval “SELECT load_extension (‘sqlite3-regex.so’)”

Viewing 3 reply threads
  • Author
    Replies
    • #121601
      John Mercogliano
      Participant

      Hi Rick,

      I found I needed to do this command. “db enable_load_extension 1” before calling the load extension. Hope this works for you.

      John Mercogliano
      Sentara Healthcare
      Hampton Roads, VA

    • #121602
      RICK L. PRITCHETT
      Participant

      If on Linux and using “load sqlite3-regex.so” do we still need to enable the load option?

    • #121603
      John Mercogliano
      Participant

      Not that I found.  You have the ability to create a .sqliterc in the users home directory, I added
      .load “sqlite3-regex.so”
      To the file so its there when I need it from the command line.

      John Mercogliano
      Sentara Healthcare
      Hampton Roads, VA

    • #121608
      John Mercogliano
      Participant

      No, only for the unix command line tool.  You will still need to do enable load extension to use regexp in tcl.

      As far as the rc file, that one line I listed above is the only statement in the file.

      John Mercogliano
      Sentara Healthcare
      Hampton Roads, VA

Viewing 3 reply threads
  • You must be logged in to reply to this topic.

Forum Statistics

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