[sqlite] sqlite on Nokia symbian
I wanna use sqlite on my Nokia C7 symbian, but I don't know how to compile sqlite c api or sqlite source on the QT symbian. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite on Windows Phone 8
Hi Scott, Noah, Joe and others I downloaded C#-Sqlite source from http://code.google.com/p/csharp-sqlite/ and compiled the Community.CsharpSqlite.WinPhone and Community.CsharpSqlite.SqliteClient.WP DLLs. In my project I installed sqlite-net and referenced the above DLLs. Now the sqlite-net wrapper including LINQ access works on Windows Phone 8. I uninstalled the official "SQLite for Windows Phone 8" extension. I don't understand how to take advantage of it. Tim Heuer writes on his blog, that the purpose is to avoid the hassle of managing different projects for every CPU. I hope to be able to take advantage of this at some point. Thank you for your help! /Peter -Original message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] (Scott Tiger) Sent: 6. november 2012 20:55 To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLite on Windows Phone 8 Hello Naoh. csharp-sqlite is not a SQLite for Windows Phone 8. Peter is talking about official release of SQLite for Windows Phone 8. http://www.sqlite.org/download.html#wp8 Hello Peter. This also discussed on msdn forum. http://social.msdn.microsoft.com/Forums/en-US/wpdevelop/thread/083fc2a4-c1a0 -4689-be69-c73361d13457/ They are talking about. "At the BUILD conference, Peter Torr said a WinRT wrapper for SQLite will be released soon". I also waiting official SQLite WinRT wrapper. Thanks. 2012/11/6 Noah Hart > Hello Peter, > > This is a common configuration. > > Please visit the C#SQLite project here: > http://code.google.com/p/csharp-sqlite/ > > and post questions to the usergroup here: > https://groups.google.com/forum/?fromgroups#!forum/csharp-sqlite > > Please keep in mind the following: > > This is not an official version of SQLite > There is completely NO affiliation with SQLite.org > Bugs should not be reported to their ticket tracking system > > Thank you, > Noah Hart > > > > > > -- > View this message in context: > http://sqlite.1065341.n5.nabble.com/SQLite-on-Windows-Phone-8-tp65316p > 65382.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-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] SQLite driver for Java
Howdy! What driver are people using to access SQLite databases from Java applications? Will -- Will Duquette -- william.h.duque...@jpl.nasa.gov Athena Development Lead -- Jet Propulsion Laboratory "It's amazing what you can do with the right tools." ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite on Windows Phone 8
Hello Naoh. csharp-sqlite is not a SQLite for Windows Phone 8. Peter is talking about official release of SQLite for Windows Phone 8. http://www.sqlite.org/download.html#wp8 Hello Peter. This also discussed on msdn forum. http://social.msdn.microsoft.com/Forums/en-US/wpdevelop/thread/083fc2a4-c1a0-4689-be69-c73361d13457/ They are talking about. "At the BUILD conference, Peter Torr said a WinRT wrapper for SQLite will be released soon". I also waiting official SQLite WinRT wrapper. Thanks. 2012/11/6 Noah Hart > Hello Peter, > > This is a common configuration. > > Please visit the C#SQLite project here: > http://code.google.com/p/csharp-sqlite/ > > and post questions to the usergroup here: > https://groups.google.com/forum/?fromgroups#!forum/csharp-sqlite > > Please keep in mind the following: > > This is not an official version of SQLite > There is completely NO affiliation with SQLite.org > Bugs should not be reported to their ticket tracking system > > Thank you, > Noah Hart > > > > > > -- > View this message in context: > http://sqlite.1065341.n5.nabble.com/SQLite-on-Windows-Phone-8-tp65316p65382.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-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] light weight write barriers
On Thu 2012-10-25 14:29:48, Theodore Ts'o wrote: > On Thu, Oct 25, 2012 at 11:03:13AM -0700, da...@lang.hm wrote: > > I agree, this is why I'm trying to figure out the recommended way to > > do this without needing to do full commits. > > > > Since in most cases it's acceptable to loose the last few chunks > > written, if we had some way of specifying ordering, without having > > to specify "write this NOW", the solution would be pretty obvious. > > Well, using data journalling with ext3/4 may do what you want. If you > don't do any fsync, the changes will get written every 5 seconds when > the automatic journal sync happens (and sub-4k writes will also get Hmm. But that would need setting journalling mode per-file, no? Like, make it journal data for all the databases, but keep normal mode for rest of system... Pavel -- (english) http://www.livejournal.com/~pavelmachek (cesky, pictures) http://atrey.karlin.mff.cuni.cz/~pavel/picture/horses/blog.html ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Shell import field separators
On 6 Nov 2012, at 11:40am, Colin Hardwick wrote: > Line 1 of the import file is fine, but line 2 is rejected as only having 7 > fields instead of 8. I've experimented with ".separator" commands to no avail > (e.g. ".separator='\t'). It appears the the shell tool is thrown by the > (clearly) mismatched single and double quotes, but since I want it to use > tabs as the separator should this be the case? The shell tool is trying to do the right thing, given its specifications. You have some alternatives. One is to write your own simple importer program which interprets the saved files how you want. Another is to use a shell command to pre-process the TSV file to replace your quote characters with some unused character, then import that file, then use SQL UPDATE commands to put the quote characters back again. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Shell import field separators
Colin Hardwick wrote:
> 40009402 FUNDNwL "NMF"NEAVB:GB;1 NQ NwL "NMF"NEAVB:GB;1 NQ
> 10031991-02-14 1991-02-14
> 40009403 FUNDNwl'MF"NEA VB:GB;1 QNwl'MF"NEA VB:GB;1 Q
> 10031991-02-14
>
> .mode tabs
> .import Feeds/Asset.txt Asset
>
> It appears the the shell tool is thrown by the (clearly) mismatched
> single and double quotes, but since I want it to use tabs as the
> separator should this be the case?
The shell tool always interprets double quotes as field delimiters; this
cannot be disabled without changing its source code.
> Of course I could write some code to look for strings like this and
> "fix" them, but then I won't end up with what the supplier has
> provided.
You could write some code to convert that file into some sensible
format. (Such as replacing line start with "INSERT INTO Asset VALUES('",
line end with "');", any tab with "','", and any ' with ''.)
Regards,
Clemens
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Shell import field separators
On Tue, Nov 6, 2012 at 1:40 PM, Colin Hardwick wrote: > Ladies & Gentlemen, > > My first post to this list, please be gentle! > > I'm trying to import tab-separated data, example here: > > 40009402FUNDNwL "NMF"NEAVB:GB;1 NQ NwL "NMF"NEAVB:GB;1 NQ > 10031991-02-14 1991-02-14 > 40009403FUNDNwl'MF"NEA VB:GB;1 QNwl'MF"NEA VB:GB;1 Q > 10031991-02-14 > > Table: > > CREATE TABLE Asset > ( > AssetCode TEXT PRIMARY KEY NOT NULL COLLATE NOCASE, > AssetTypeCode TEXT NOT NULL COLLATE NOCASE, > Name TEXT NOT NULL COLLATE NOCASE, > ShortName TEXT COLLATE NOCASE, > CurrencyCode TEXT COLLATE NOCASE, > PerformanceTaxCountryCode TEXT COLLATE NOCASE, > StartDate DATE, > QualifiedStartDate DATE > ); > > I am not in control of the format or content, but have a command file, the > gist of which is: > > .mode tabs > .import Feeds/Asset.txt Asset > > Line 1 of the import file is fine, but line 2 is rejected as only having 7 > fields instead of 8. I've experimented with ".separator" commands to no > avail (e.g. ".separator='\t'). It appears the the shell tool is thrown by > the (clearly) mismatched single and double quotes, but since I want it to > use tabs as the separator should this be the case? > > Of course I could write some code to look for strings like this and "fix" > them, but then I won't end up with what the supplier has provided. > > Am I missing a command here? Thanks for any input. > > Mac OS-X 10.8.2, shell SQLite 3.7.12 2012-04-03 19:43:07 > 86b8481be7e7692d14ce762d21bfb69504af (latest). > > Best regards, > Colin Hardwick > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > If you are comfortable compiling your own shell, it is just a matter of commenting out one line here: http://www.sqlite.org/cgi/src/artifact/24cd0aa74aff73ea08594629faead564c4c2a286?ln=1872to make it ignore quotes and treat *all* tabs as delimiters. -- ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Shell import field separators
Ladies & Gentlemen, My first post to this list, please be gentle! I'm trying to import tab-separated data, example here: 40009402FUNDNwL "NMF"NEAVB:GB;1 NQ NwL "NMF"NEAVB:GB;1 NQ 10031991-02-14 1991-02-14 40009403FUNDNwl'MF"NEA VB:GB;1 QNwl'MF"NEA VB:GB;1 Q 10031991-02-14 Table: CREATE TABLE Asset ( AssetCode TEXT PRIMARY KEY NOT NULL COLLATE NOCASE, AssetTypeCode TEXT NOT NULL COLLATE NOCASE, Name TEXT NOT NULL COLLATE NOCASE, ShortName TEXT COLLATE NOCASE, CurrencyCode TEXT COLLATE NOCASE, PerformanceTaxCountryCode TEXT COLLATE NOCASE, StartDate DATE, QualifiedStartDate DATE ); I am not in control of the format or content, but have a command file, the gist of which is: .mode tabs .import Feeds/Asset.txt Asset Line 1 of the import file is fine, but line 2 is rejected as only having 7 fields instead of 8. I've experimented with ".separator" commands to no avail (e.g. ".separator='\t'). It appears the the shell tool is thrown by the (clearly) mismatched single and double quotes, but since I want it to use tabs as the separator should this be the case? Of course I could write some code to look for strings like this and "fix" them, but then I won't end up with what the supplier has provided. Am I missing a command here? Thanks for any input. Mac OS-X 10.8.2, shell SQLite 3.7.12 2012-04-03 19:43:07 86b8481be7e7692d14ce762d21bfb69504af (latest). Best regards, Colin Hardwick ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
