Re: [sqlite] forcing X'' literals in sqlite3's .dump?

Stephan Beal wrote: > Just to be pedantic for a moment: the shell is GPL if you #define > USE_READLINE to a true value. Such is the reality of viral licenses. From > shell.c: The shell in its lonesome is never GPL, only the combination with readline is. If you distributed a combination of the

Re: [sqlite] How to retrieve the Specil characters from the Sql lite

On 17 Aug 2011, at 11:39pm, Kees Nuyt wrote: > On Wed, 17 Aug 2011 14:45:22 +0100, Simon Slavin > wrote: > >> Parsing a long string containing many SQL commands to >> find out where the commands are separated is non-trivial. [snip] > > It is built in. The first

Re: [sqlite] How to retrieve the Specil characters from the Sql lite

On Wed, 17 Aug 2011 14:45:22 +0100, Simon Slavin wrote: > >On 17 Aug 2011, at 2:26pm, Igor Tandetnik wrote: > >> Simon Slavin wrote: >>> Question for experts: Hmm. There's no sqlite3_exec16() ? >>> Do I misunderstand how it would be useful ? >> >>

Re: [sqlite] forcing X'' literals in sqlite3's .dump?

On Wed, Aug 17, 2011 at 11:52 PM, Richard Hipp wrote: > On Wed, Aug 17, 2011 at 12:28 PM, Stephan Beal >wrote: > > > But the reality is still: if the sqlite3 shell links with libreadline, it > > is GPL. > > > > > Not. > Sorry, i wasn't clear: the

Re: [sqlite] forcing X'' literals in sqlite3's .dump?

On Wed, Aug 17, 2011 at 12:28 PM, Stephan Beal wrote: > But the reality is still: if the sqlite3 shell links with libreadline, it > is GPL. > > Not. If *you* distribution binaries of a program that links against readline, then *you* must also be willing to distribute

Re: [sqlite] null handling import

Stephan,   Yeah, there's a lot more to SQL than I thought. Seems to be many different ways to skin the same cat. The reason it took me so long to respond to Tom was that I trying to use views to import several files with a different number and ordering of columns into a single  generic table.

Re: [sqlite] null handling import

On Wed, Aug 17, 2011 at 7:12 PM, matthew (matthew.jsoft) white < matthew.js...@btinternet.com> wrote: > I didn't realise that views could be written to. > i didn't, either. Thank you very much for posting a follow-up with your results. i now have some experimentation to do... Happy Hacking! --

Re: [sqlite] null handling import

Hi Tom,  I've been testing your suggestion over the past few days and it works fine. The great advantage of using triggers is being able to perform arbitrary checks and manipulation of the raw data. At the expense of more elaborate SQL srcipts, the CSV files can be left in a more readable

Re: [sqlite] forcing X'' literals in sqlite3's .dump?

On Wed, Aug 17, 2011 at 6:25 PM, Stephan Beal wrote: > Just to be pedantic for a moment: the shell is GPL if you #define > USE_READLINE to a true value. Such is the reality of viral licenses. From > shell.c: > And to be even more pedantic: that code came from the WRONG

Re: [sqlite] forcing X'' literals in sqlite3's .dump?

On Wed, Aug 17, 2011 at 5:09 PM, Roger Binns wrote: > They are part of the standalone shell (ie not the library). The shell > source code is under the same license as the rest of SQLite (ie as > public domain as possible) so you are free to make a copy and do > whatever

Re: [sqlite] SqLite - Help

> Is it possible to create Storedprocedure or Functions in Sqlite. ? No. > Since i am new to Sqlite. Can u suggest some best sites or links to learn > Sqlite (ofcourse i saw Sqlite.org site) Other than sqlite.org you can look at google.com. It is usually very good at finding answers on

[sqlite] type of a value bound by sqlite3_bind_blob ()?

> Roger Binns writes: > On 08/16/2011 04:59 PM, Ivan Shmakov wrote: >> In the sqlite3's .dump command's output, the binary blobs may either >> be represented as hexadecimal X''-literals, or as text strings. […] > I suggest using typeof on the data you think is blobs to verify what >

Re: [sqlite] forcing X'' literals in sqlite3's .dump?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/16/2011 04:59 PM, Ivan Shmakov wrote: > In the sqlite3's .dump command's output, the binary blobs may > either be represented as hexadecimal X''-literals, or as text > strings. What evidence do you have for that claim? >

Re: [sqlite] Official replacement for sqlite3_expire

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/17/2011 02:47 PM, Richard Hipp wrote: > So you, the programmer, don't need to mess > with sqlite3_expired() any more. However you do need to be aware that error codes are different between an identical statement that you called prepare on

Re: [sqlite] aggregate by break in sequence

Well, not easy in a programming language - however, certainly an option. I was hoping that there would be some kind of break in sequence aggregation available (or a trick) in Sqlite. My problem I suspect is not so uncommon. I know that I can do this in INFO (an outdated database of ArcInfo) and I

Re: [sqlite] How to retrieve the Specil characters from the Sql lite

On 17 Aug 2011, at 2:26pm, Igor Tandetnik wrote: > Simon Slavin wrote: >> Question for experts: Hmm. There's no sqlite3_exec16() ? Do I >> misunderstand how it would be useful ? > > sqlite3_exec is a thin wrapper around sqlite3_prepare, step and finalize, > maintained

Re: [sqlite] How to retrieve the Specil characters from the Sql lite

Simon Slavin wrote: > Question for experts: Hmm. There's no sqlite3_exec16() ? Do I misunderstand > how it would be useful ? sqlite3_exec is a thin wrapper around sqlite3_prepare, step and finalize, maintained for backward compatibility. Just use those, or their _16

Re: [sqlite] How to retrieve the Specil characters from the Sql lite

On 17 Aug 2011, at 6:44am, swathi wrote: >I want to retrieve some german characters form the Sqlite . How > can i use it . Please Help me Use the 16-bit routines from SQLite to store and retrieve characters. In other words, if you're binding text, see this page

Re: [sqlite] Primary Key size

On Wed, 17 Aug 2011 01:39:57 -0700 (PDT), LiranR wrote: > >Hi all ! >A quick question: >Do you know if there is a different in performance when i use 4 bytes >Integer Primary Key or 8 bytes Integer Primary Key? The INTEGER type in SQLite is a 64bit signed integer. It is

Re: [sqlite] Official replacement for sqlite3_expire

On Wed, Aug 17, 2011 at 4:22 AM, Scholz Maik (CM-AI/PJ-CF42) < maik.sch...@de.bosch.com> wrote: > Hi, > I like to use and reuse SQLite statements. > I need a way to detect, when a statement is obsolete because e.g. > the schema was changed. > > So sqlite3_expire is marked deprecated, what shall I

[sqlite] Official replacement for sqlite3_expire

Hi, I like to use and reuse SQLite statements. I need a way to detect, when a statement is obsolete because e.g. the schema was changed. So sqlite3_expire is marked deprecated, what shall I use instead? Maik ___ sqlite-users mailing list

[sqlite] How to retrieve the Specil characters from the Sql lite

Hello , I want to retrieve some german characters form the Sqlite . How can i use it . Please Help me -- *Thanks* *swathi.Empress* *4 the people* ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Read only scaling optimization

Pavel, Thank you for this information. It is exactly what I was looking for. That said if you are absolutely sure that no other process will write to the database while you are reading you can create your own VFS and make xAccess and xCheckReservedLock methods a no-op. You can read more about

[sqlite] SqLite - Help

Hi, I am new to Sqlite. I need to develop a Desktop windows application C# with Sqlite. Is it possible to create Storedprocedure or Functions in Sqlite. ? If so, can you send me an example for both. Since i am new to Sqlite. Can u suggest some best sites or links to learn Sqlite

[sqlite] Primary Key size

Hi all ! A quick question: Do you know if there is a different in performance when i use 4 bytes Integer Primary Key or 8 bytes Integer Primary Key? -- View this message in context: http://old.nabble.com/Primary-Key-size-tp32277931p32277931.html Sent from the SQLite mailing list archive at