Re: [sqlite] Build problem of sqlite-3.6.14.2 on Solaris 10 with gcc 4.4.0

On 12 Jun 2009, at 23:46, Dr. David Kirkby wrote: > I don't know if you work for Sun, but if you do, it would be really > good > if Sun made some open-access Suns available for developers to test > their > code, like HP do. Surely this would only matter for SPARC-related issues (which I

Re: [sqlite] Build problem of sqlite-3.6.14.2 on Solaris 10 with gcc 4.4.0

Nicolas Williams wrote: > On Sat, Jun 13, 2009 at 01:43:15AM +0100, Dr. David Kirkby wrote: >> Thank you for your help. The fact you told me I did not need to link >> libpthread was crucial to solving this. >> >> I've found that just removing the libpthread from the generated Makefile >> solves

Re: [sqlite] Build problem of sqlite-3.6.14.2 on Solaris 10 with gcc 4.4.0

Tim Bradshaw wrote: > On 12 Jun 2009, at 23:46, Dr. David Kirkby wrote: > >> I don't know if you work for Sun, but if you do, it would be really >> good >> if Sun made some open-access Suns available for developers to test >> their >> code, like HP do. > > Surely this would only matter for

[sqlite] How does SQLite handle newlines in values?

I'm very sorry if this is a very stupid question. Intuitively, I would assume that of course, any TEXT or BLOB field may contain newlines. I'm, however, puzzled about two things (it all refers to the commandline interface): - while I can insert values with newlines by using the X'ABCD'

Re: [sqlite] How does SQLite handle newlines in values?

2009/6/13 Florian v. Savigny : > > > I'm very sorry if this is a very stupid question. Intuitively, I would > assume that of course, any TEXT or BLOB field may contain > newlines. I'm, however, puzzled about two things (it all refers to the > commandline interface): > > - while

Re: [sqlite] How does SQLite handle newlines in values?

On Sat, Jun 13, 2009 at 4:16 PM, Florian v. Savigny wrote: > I'm very sorry if this is a very stupid question. Intuitively, I would > assume that of course, any TEXT or BLOB field may contain > newlines. I'm, however, puzzled about two things (it all refers to the > commandline

Re: [sqlite] Build problem of sqlite-3.6.14.2 on Solaris 10 with gcc 4.4.0

On 13 Jun 2009, at 12:29, Dr. David Kirkby wrote: > I believe if Sun make some public access machines available, there > would > be a benefit to Sun, and would hopefully avoid a lot of the GNUisms > one > sees in software. Whether the cost would outweigh the benefit I have > no > idea.

[sqlite] Allowable SQLite calls during sqlite3_extension_init ?

Hi everyone, Is it possible to invoke SQLite functions while INITing a loadable extension? I ask because I need to know if the design I've in mind is at all possible. It needs to issue a very simple select on an already opened DB and fetch one row of data, which could all be done with

[sqlite] Parsing line output (Was: How does SQLite handle newlines in values?)

Thanks to both Nino and Simon, for those prompt answers, which confirmed that my question was indeed stupid. Why inserting newlines did not work when I tried to insert them I'm not completely sure; I repeatedly got syntax errors. I reproduced Simon's example now, which worked fine (and my

Re: [sqlite] Allowable SQLite calls during sqlite3_extension_init ?

Jean-Christophe Deschamps wrote: > Is it possible to invoke SQLite functions while INITing a loadable > extension? Of course. The extension is expected to do things like registering custom functions, collations, virtual tables and so on. > I ask because I need to know if the design I've in mind

Re: [sqlite] Build problem of sqlite-3.6.14.2 on Solaris 10 with gcc 4.4.0

Tim Bradshaw wrote: > On 13 Jun 2009, at 12:29, Dr. David Kirkby wrote: > >> I believe if Sun make some public access machines available, there >> would >> be a benefit to Sun, and would hopefully avoid a lot of the GNUisms >> one >> sees in software. Whether the cost would outweigh the

Re: [sqlite] Parsing line output (Was: How does SQLite handle newlines in values?)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Florian v. Savigny wrote: > Which leads me to the motive for my question: parsing the line > output. Note that the sqlite shell is intended as a useful tool and diagnostic aid, but it is not intended to be *the* way you access SQLite. There are also

Re: [sqlite] Parsing line output (Was: How does SQLite handle newlines in values?)

Dear Roger, your revelation is rather shocking for me, because my sqlite.el library took easily one week of work when I wrote it (and has actually worked very well so far). I was completely aware it is not intended as the standard way for programs to access an SQLite database, but I had actually

[sqlite] Allowable SQLite calls during sqlite3_extension_init ?

Dear Igor, Thank you _so_ much for comforting hat part of the idea I have in mind. I have another related question and I hope you or some other guru can point me towards a solution. I use SQLite from some interpreted script language under XP (yes I know). Today's PCs are fast enough to

[sqlite] Database logic in TRIGGER and CONFLICT, or in software ?

I'm writing an application which involves lots of relations between tables. Seen from a high level, my application will have to enforce lots of rules to ensure database integrity. Before I used SQLite I would have enforced all these rules in my software. But SQLite has lots of ways to

[sqlite] SQlite3 - SQL injection using ruby

I am using sqlite3 with ruby and hope I'm not out of place here in ask for some help on how to stop or reduce injection threats via sql statements made by a user be it accidental or deliberate. I want to build a select query from user entered data and then return rows that match. e.g. stmt =