Here is my schema using sqlite, I am not sure if this is a good way to create tree structure in sql as I have to traverse many time to obtain the entire tree, a
I am trying to get datafrom database in a list. This is my code: private class LoadData extends AsyncTask<Void, Void, Void> { private ProgressDialog
What I currently have selects based on a column having the same value.. "SELECT * FROM users WHERE uuid = ?" But what if I want to return a row based on one
I have an app that has been in production for years. It ships with the standard Sqlite DB. The lastest version of the app has SqlCipher 3.5.6 library integrated
I am using SQLite3 for development and PostgreSQL for deployment. However, I am facing the following problem: My simple search using SQLite3: def self.search(
I am not able to get any output from the following program.What i am trying to do here is store employee name and salary in a database and lat
I recently installed Drupal on Windows Server I had no errors on installation. There was a warning for OPCaching. I also don't think it should affect it but I u
Is it bad to have text as a primary key in an SQLite database? I heard that it's bad for performance reasons, is this true? And will the rowid be used as the ac
My application reads a html table and then a script (TableToCSV) converts it into a .csv format. After that I convert that .csv into a sqlite database. After th
I have ConsoleApplication on .NET Core and also i added my DbContext to dependencies, but howewer i have an error: Unable to create an object of type 'MyCon
I want to perform some data analysis of my own on my Anki history. I found out that my history should be contained in ~/.local/share/Anki2/User 1/collection.ank
I am working on database and exporting data from database to xml file but i faced this error in this line byte[] s = cur.getBlob(idx);. before I was using this
I've looked all over the place and cant find a solution that helps my case. I hope someone can help? I have this and receive Warning: sqlite_query() expects pa
I have two tables, with a same column named user_name, saying table_a, table_b. I want to, copy from table_b, column_b_1, column_b2, to table_b1, column_a_1, c
I am trying to create a sqlite3 database on my windows 7 64 bit machine. I have downloaded sqlite-shell-win32-x86-3071700.zip from http://www.sqlite.org/downloa
I am working on a small database application in Python (currently targeting 2.5 and 2.6) using sqlite3. It would be helpful to be able to provide a series of f
I am working on a small database application in Python (currently targeting 2.5 and 2.6) using sqlite3. It would be helpful to be able to provide a series of f
I am trying to use SQLite in VSCode. I have installed SQLite extension by Alexcvzz. after opening the database when I right-click on the table and select "Show
I am trying to use SQLite in VSCode. I have installed SQLite extension by Alexcvzz. after opening the database when I right-click on the table and select "Show
I am trying to use SQLite in VSCode. I have installed SQLite extension by Alexcvzz. after opening the database when I right-click on the table and select "Show