sqlite

Does it matter what extension is used for SQLite database files?

by

Are there advantages or disadvantages to the file extension used for SQLite databases? It seems that SQLite itself does not require a naming convention, but there might be other reasons that a particular extension would be useful or problematic – for instance, certain tools, programming languages, installers, etc. Or end user considerations. The most common … Read more

Best way to work with dates in Android SQLite [closed]

by

Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be answered with facts and citations by editing this post. Closed 4 years ago. Improve this question I’m having some trouble working with dates on my Android application that uses SQLite. I have … Read more

Unable to load DLL ‘SQLite.Interop.dll’

by

Periodically I am getting the following exception: Unable to load DLL ‘SQLite.Interop.dll’: The specified module could not be found. (Exception from HRESULT: 0x8007007E) I am using 1.0.82.0. version, installing it with nuget in VS2010, OS Win7 64. Once exception starts to appear, it appears constantly – in debug and release and running application within or … Read more

sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 74 supplied

by

def insert(array): connection=sqlite3.connect(‘images.db’) cursor=connection.cursor() cnt=0 while cnt != len(array): img = array[cnt] print(array[cnt]) cursor.execute(‘INSERT INTO images VALUES(?)’, (img)) cnt+= 1 connection.commit() connection.close() I cannot figure out why this is giving me the error, The actual string I am trying to insert is 74 chars long, it’s: “/gifs/epic-fail-photos-there-i-fixed-it-aww-man-the-tire-pressures-low.gif” I’ve tried to str(array[cnt]) before inserting it, but … Read more

sqlite3-ruby install error on Ubuntu

by

I have the following error during sqlite3-ruby install: Building native extensions. This could take a while… ERROR: Error installing sqlite3-ruby: ERROR: Failed to build gem native extension. /usr/bin/ruby1.8 extconf.rb checking for sqlite3.h… no sqlite3.h is missing. Try ‘port install sqlite3 +universal’ or ‘yum install sqlite3-devel’ *** extconf.rb failed *** Could not create Makefile due to … Read more

Is there a .NET/C# wrapper for SQLite? [closed]

by

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for Stack Overflow. Closed 3 years ago. Improve this question I’d sort of like to use SQLite from within C#.Net, but I can’t seem to find an appropriate library. … Read more