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 SQL
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 sqlite3_prepare*() on a multipl
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 ?
>>
>> sqlite3_exec is a thin wrapper around sqlite3_
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 resulting binary, not the shell sources, is GPL.
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 sources for that program unde
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.
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!
--
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 form
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 shell.c (not the
copy whic
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 you want with it.
>
>
Jus
> 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-re
> 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
>
-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?
>
-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 versus
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
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 for backward compatibi
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
counterparts, directly.
-
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
http://www.sqlite.o
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 stored in a compressed fo
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
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-users@s
Hello ,
I want to retrieve some german characters form the Sqlite . How
can i use it . Please Help me
--
*Thanks&Regards*
*swathi.Empress*
*4 the people*
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/m
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 VFS
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 (ofcou
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 Nabbl
25 matches
Mail list logo