Re: [sqlite] Sqlite help
>Unfortunately, I'm not too familiar with SQLite Manager. well it's quite cool you know, try one day :) It's kind of WYSIWYG -:) Ok so unfortunatelly my database is in .gll file but when i use FF SQLite Manager in FF i can see all my tables. So i Imported my csv file to my database :-) very easy, this is how it looks http://imageshack.us/photo/my-images/197/databaser.jpg/ Wolfgang now is worst part:( for me :( Tables-> queries in column names i created name called "playlist1" In that playlist1 i would like to have all that imported songs All my music collection is in tables called "tracks" So what sqlite command i must write that sqlite would automatically compare and put imported csv data with all collection to "playlist1"? -- View this message in context: http://old.nabble.com/Sqlite-help-tp31992826p31993464.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Is there a difference between DELETE and UPDATE/INSERT in terms of syncing to disk?
For the record, the problem was that django (by default) starts a transaction before handing an http request, then commits it after the request is handled. Since we were in the middle of a transaction, all the python/django code we wrote saw the state of the DB as it was partially through a transaction, but external code didn't see the changes on disk yet. We didn't realize that we were opertaing within an uncommitted transaction, so had a the race condition where we kicked off an external process to backup the DB after the DELETE was complete, and it would sometimes see the changes, and sometimes not, depending on what happened first - the request handler completing and transaction getting committed, or the external process starting up and locking the DB. I think there is something specific about the relative speeds of the handlers that do DELETEs vs. INSERTs that biased the race condition, so who won depended on the action and led us down the wrong path. Anyhow, thanks for your help. Cheers, Sam ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite help
Am Mon, 4 Jul 2011 16:10:10 -0700 (PDT) schrieb ceekayCK: > It was quite easy to export to csv (using excel) :) > Now i have in one column Artist , and in second column Title Fine. :-) > Ok So i use sqlite Manager in Firefox Unfortunately, I'm not too familiar with SQLite Manager. > What should I do next? Next I would fire up the CLI (type "sqlite3.exe mydb.db" at the command prompt if you're using Windows, assuming your database is named mydb.db), then type ".import docdata.csv mytable" or whatever your csv file and target table are named (type ".help" for further info). I never used that function before but I'm sure it will get you onto the right track. Good luck, Wolfgang ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite help
*If* you can manage a reasonable export to .csv (using Excel, if needed, or not), then, yes, that would be a way to go IMHO. Lookup the .import command in the CLI (command line interface). OK Wolfgang It was quite easy to export to csv (using excel) :) Now i have in one column Artist , and in second column Title Ok So i use sqlite Manager in Firefox In my database i have one Table called "tracks" Structure is Column ID, Name, Type, Name are Artist Type Text Title Text What should I do next? Wolfgang will u help me? -- View this message in context: http://old.nabble.com/Sqlite-help-tp31992826p31993302.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite help
Am Mon, 4 Jul 2011 15:39:30 -0700 (PDT) schrieb ceekayCK: > If i changed .doc file to .txt or csv, will this help? > Or put all data from .doc to excel, and then split Artist and title to > separate columns and export to csv? *If* you can manage a reasonable export to .csv (using Excel, if needed, or not), then, yes, that would be a way to go IMHO. Lookup the .import command in the CLI (command line interface). But I doubt it's possible to convert a .doc file into a useful .csv file. However, as said before, that depends a lot on the specific .doc file *and* your database structure. Wolfgang ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite help
>A .doc file is basically a load of printer instructions, but generally it doesn't hold any structured data. The latter, however, is what a database needs and is made for. If i changed .doc file to .txt or csv, will this help? Or put all data from .doc to excel, and then split Artist and title to separate columns and export to csv? -- View this message in context: http://old.nabble.com/Sqlite-help-tp31992826p31993160.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite help
Am Mon, 4 Jul 2011 14:45:07 -0700 (PDT) schrieb ceekayCK: > unfortunately send me a .doc file You're at a loss there. Your friend could as well print this file and send you the printer output, essentially that would make no difference. A .doc file is basically a load of printer instructions, but generally it doesn't hold any structured data. The latter, however, is what a database needs and is made for. Depending on how this specific .doc file (and your database) looks like, there *may* be some things one could try, but they are all very time consuming and require programming skills. >Is there a magic command No. Neither in SQLite, nor in any other database system. Wolfgang ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Error: malformed database schema
On 4 Jul 2011, at 10:53pm, Alexey Pechnikov wrote: > sqlite> pragma integrity_check; > *** in database main *** > Page 5 is never used > Page 35 is never used > Page 67 is never used > Page 97 is never used Use sqlite3 to dump your database to a file of SQL commands. Use sqlite3 to use that file of commands to create a new database. Run the integrity_check on the new database. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Error: malformed database schema
$ sqlite3 test.db -- Loading resources from /home/mbg/.sqliterc SQLite version 3.7.7.1 2011-06-28 16:48:37 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> select count(*) from sqlite_master; 283 .dump ... sqlite> select count(*) from sqlite_master; Error: malformed database schema (job_user_id_idx) - no such table: main.job_record .dump ... sqlite> pragma integrity_check; *** in database main *** Page 5 is never used Page 35 is never used Page 67 is never used Page 97 is never used -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Sqlite help
Hi, At the beginning I will say that I am not a specialist in databases. I have the following problem to figure out: I have a database (sqlite). In it, about 8800 records (lyrics) I have received from a friend list (selected about 800 songs), but unfortunately send me a .doc file Is there a magic command in sqlite that will help me to choose automatically with a whole database identified 800 songs? If so, what commands should I use? Please please help :) -- View this message in context: http://old.nabble.com/Sqlite-help-tp31992826p31992826.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] sqlite3 amalgamation and unused variables
There seem to be a couple of variables in the sqlite3 amalgamation that get assigned a value but actually their value is not used. If there is an intention to get rid of these statements I will submit samples like h = pFile->h; (sqlite3.c in line 26039 version 3.7.7) But perhaps these lines originate from merging source code files into the amalgamation file?! Hartwig ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Help needed for SQLite PHP
Just FYI: James told me in private mail " SQLiteDatabase is not working for sqlite3, I changed the open script to: $dbh = new PDO('sqlite:yourdatabase.db'); Now it is working. " On Sun, 03 Jul 2011 16:08:24 +0200, Kees Nuytwrote: >On Sun, 3 Jul 2011 06:47:26 -0700 (PDT), James_21th > wrote: > >>Dear experts, >> >>I was quite excited when I see such a nice portable database---SQLite, which >>can be installed locally. >> >> [snip] >> >>My test php file is very simple: >> >>>$db = new SQLiteDatabase('test.db'); >>echo "SQLite successfully opened"; >>?> >> >>However, no matter how I tried, it give me "HTTP 500 internal server error", >>I checked the Nanoweb error log, found below message: >> >>20110703:054052 WARN: function 'pcntl_fork' not available >>20110703:054052 WARN: function 'posix_setuid' not available >> >>Do I missed anything? >> >>Your help is greatly appreciated! > >You may have used the wrong interface. >Perhaps this example helps: > >http://php.net/manual/en/intro.sqlite3.php > >I'm not sure, but SQLiteDatabase seems to refer to the deprecated >sqlite v2 interface. > >HTH -- ( Kees Nuyt ) c[_] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Minimal SQLite
On Mon, Jul 04, 2011 at 04:37:10PM +0530, trilok nuwal scratched on the wall: > Hi All, > > I want to use SQLite for one of the application which runs on a embedded > system where we have memory limitations. > > In the SQLite we have around 180+ distinct APIs, but not all APIs we are > going to use it. APIs themselves don't really represent much bulk. You'll notice that many of the APIs are small variations on a theme (like the "bind" functions), making the numbers add up quickly. That said, there are some functional areas that take up some bulk, and may not be required for your situation. Many of these can be compiled out using the "OMIT" build directives: http://www.sqlite.org/compile.html#omitfeatures Just be sure you read the notes carefully... mainly that the OMIT defines are designed to be used against the canonical source code. That means building from the source tree, including the parser code. Also note that none of the OMIT flags are officially supported, none of them are tested, and, for any given version of the source code, various combos of OMIT defines are likely to break things. If you're using an extensive number of OMIT flags, a bit of code clean-up may be required. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Minimal SQLite
On 4 Jul 2011, at 12:07pm, trilok nuwal wrote: > I want to use SQLite for one of the application which runs on a embedded > system where we have memory limitations. > > In the SQLite we have around 180+ distinct APIs, but not all APIs we are > going to use it. > > What I want is the just core APIs. Can I build SQLite in such a way that I > can avoid all the unnecessary API implement ions in the final library. I > want to avoid all the extra APIs except the core API. SQLite is distributed as source code. It's available in two forms: either lots of individual files each with their own subject area, or as one big 'amalgamation' C file. You can download both from http://www.sqlite.org/download.html Pick one form. Download it. Compile it and check that it compiles in your compiler and runs as supplied. Remove everything you don't think you need. Compile as suits you. Fix dependencies and try again. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Minimal SQLite
Hi All, I want to use SQLite for one of the application which runs on a embedded system where we have memory limitations. In the SQLite we have around 180+ distinct APIs, but not all APIs we are going to use it. What I want is the just core APIs. Can I build SQLite in such a way that I can avoid all the unnecessary API implement ions in the final library. I want to avoid all the extra APIs except the core API. If any compiler setting can help to achieve will be great. Any hint to achieve it, is also really appreciated. Thanks /TC ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] System.Data.SQLite version 1.0.74.0 released
System.Data.SQLite version 1.0.74.0 is now available on the System.Data.SQLite website: http://system.data.sqlite.org/ Further information about this release can be seen at http://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki Please post on the SQLite mailing list (sqlite-users at sqlite.org) if you encounter any problems with this release. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users