I have been working on developing this analytical tool to help interpret and analyze a database that is bundled within the package. It is very important for us to secure the database in a way that can only be accessed with our software. What is the best way of achieving it in Python? I am aware that there may not be a definitive soluti...
Hi, I am making a planner application for the iphone that can work online to store tasks in a mysql server. However, when I attempt to synchronise the two databases I have a problem. The thing seems to be that I can't insert more than one set of values at once into the iPhone database: INSERT INTO planner (title, duedate, submitdate, su...
Hello, I want to implement SQLite for my next project. I've done some research and I've found that PHP 5+ comes with two standard extenstions, that is: SQLite found here ( php.net/manual/en/book.sqlite.php ) SQLite3 found here ( php.net/manual/en/book.sqlite3.php ) I want to know if number '3' represents the version. If it does, why...
Is there a way to see all generated queries from rails in production environment like you can in development? ...
Hey guys, I suppose this is partially subjective in that it's probably dependent on everyone's interpretation of "high volume", but for the sake of discussion, I'd like to approach this in a hypothetical way. Also, if this is something that should be exclusive to ServerFault, let me know and I'll happily repost there. Obviously there ...
Hello. I have a database with 3 tables in it. They are "Projects", "Contacts" and "Project Types". I have a UI for creating (adding a record) a new project which adds a record to the "Projects" table. In that UI, I have a button to fetch Contact Names from the "Contacts" table which in turn displays a ListView of all Contacts. When the ...
I am developing mobile application in C#. I want to read the values from the database & display in the gridview control. I am not aware of of how to use the SQLiteDataReader with datagrid control in compact framework. My code is running properly but I am not able to display the values in the datagrid SQLiteDataReader SQLiteDrKeyObj = nu...
We have a VERY old Sqlite database that can NOT be resigned/changed at this late stage. It has fields like User1, User2, and ConversationDate. How would I use "GROUP BY" so that instead of 2 records output... I would only get 1? Bad output: Bob contacted Fred on 01-Jan-2007. Fred replied to Bob on 11-Jan-2007. Desired outpu...
Hiya folks, I have a question about when you distribute your app with an existing DB. Right now I've created a basic app, and from my understanding, the .db file should be in the assets folder, and when the user first runs your app it should check if the DB exists in the \data\data\ folder, if it's not there it should copy it over...co...
I want to bulk insert about 700 records into the Android database on my next upgrade. What's the most efficient way to do this? From various posts, I know that if I use Insert statements, I should wrap them in a transaction. There's also a post about using your own database, but I need this data to go into my app's standard Android da...
The line "return db.insert(DATABASE_TABLE, null, initialValues);" is returning a null pointer and I cant figure out why! I'd be grateful for any help public class Database extends Activity { @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.main); ...
I am developing mobile application in C#. I am using SQLite as a database. I am using the following code SQLiteDataReader SQLiteDrKeyObj = null; DataTable dt = new DataTable(); DataManager DataMgrObj = new DataManager(); QueryDetails QueryDetailsObj = new QueryDetails(); //int ...
Hello folks, I'm trying to find a solution for following thing. Autocompletetextview with filtering on sqlite side. I guess, I should write custom CursorAdapter, which implements Filterable, but I have no idea, where to start. Did anybody see any examples / tutorials for that? Mur ...
Hi, I am new to objective-C and iphone apps. I am accessing SQLite and have 3 rows in my table "coffee". I used the following way to grab sth out from the table, however, only then 2nd and 3rd rows are being pulled out {the 1st row is always missed}. Is that due to the logic in my while loop by checking while sqlite3_step(selectstmt) r...
I'm using Python and SQLAlchemy to query a SQLite FTS3 (full-text) store and I would like to prevent my users from using the - as an operator. How should I escape the - so users can search for a term containing the - (enabled by changing the default tokenizer) instead of it signifying "does not contain the term following the -"? ...
I'd like to delete certain Firefox cookie. The problem is I'd like to do it when Firefox is open. When I try to access the cookies.sqlite I get the database is locked error. Is there any way I can force Firefox to drop the lock without closing firefox? ...
I have a database of 50MB size in SQLite 3. All db objects are accessed through a web service. Is SQLite a good choice for an concurrent online usage of about 500 parallel users. NOTE: Users will use same tables but not same rows. Each user can see/update/delete only his data. ...
Is it possible to open a SQLiteConnection on a binary stream without first saving it to disk? Surely there's a way to 'trick' the connection into thinking the stream is a file. I mean, internally that's what it's doing anyway, right? ...
So I am programming an android application and I am getting unusual error. In the code below I am loading the data from an sql file into a sqlite database and updating a progress dialog while I do this. After successfully executing a number of statements I am getting an exception on one execSQL statement. This statement is a perfectly fo...
i would like to write insert into tbl1(a,b) select 123, (select id from tbl2 where status=987) the problem is, only one row is inserted instead of many rows. How do i fix this? using Sqlite. ...