Hi,
On Wed, Dec 27, 2017 at 12:00 PM, Warren Young wrote:
> On Dec 27, 2017, at 7:49 AM, Nelson, Erik - 2
> wrote:
>>
>>> Also when you're forced to use a third party ticket system, fossil i
>>> missing one of its big advantages.
>>
>> I'm
Hi, Cezary et al,
On Mon, Dec 11, 2017 at 5:48 PM, Cezary H. Noweta <c...@poczta.onet.pl> wrote:
> Hello,
>
> On 2017-12-11 04:29, Igor Korot wrote:
>>
>> Thank you, but I need to keep the official SQLite code.
>
> Anyway, for the people who are intere
>>the comma delimited part of the well formed CREATE TABLE statement.
>>When
>>obtained from sqlite_master, the statement is guaranteed to be well
>>formed. Simply examine each comma delimited candidate part. If
>>present,
>>the first word between keyword CONSTRA
Hi,
On Sat, Jan 13, 2018 at 6:32 AM, Niall O'Reilly wrote:
>
>
> On 11 Jan 2018, at 13:23, Richard Hipp wrote, in reply to John G
> :
>
>> You can
>> download and/or compile your own up-to-date SQLite that is twice as
>> fast and has all the latest
Hi,
On Mon, Feb 5, 2018 at 11:41 AM, Simon Slavin wrote:
> On 5 Feb 2018, at 5:21pm, Drago, William @ CSG - NARDA-MITEQ
> wrote:
>
>> I've been using/loving SQLite for years, but the use of open source software
>> is highly discouraged where I
Hi,
On Thu, Feb 8, 2018 at 10:00 AM, Vasanth wrote:
> Please remove my id from mailing list/subscription.
Why not do it yourself?
Did you try to go to the link shown at the end of this email or any
other for that matter?
Thank you.
>
Hi,
On Sat, Dec 30, 2017 at 5:35 AM, eli wrote:
> Hello,
>
> It would be awesome if SQLite could compile as a part of bigger C++ project.
> Right now there is a bunch of pointer casting errors, that can be fixed in
> a matter of hour IMHO.
Which OS/compiler are you trying?
Hi,
On Tue, Jan 2, 2018 at 3:34 PM, wrote:
> Hi:
>
> Not only it can, but that is probably the use in the 99.00% of C++
> applications that uses SQLite.
That number should probably be 99.999(9)%... ;-)
Thank you.
>
> The only caveat is that you can get some warnings
he default parameters.
It means that I can safely pass the connection I made to the secondary
thread and update my table cache
and everything will work just fine.
Am I reading the docs correctly?
Thank you.
On Wed, Jun 20, 2018 at 9:17 PM, Igor Korot wrote:
> David,
>
> On Wed, Jun 20, 201
Hi,
On Thu, Aug 2, 2018 at 1:27 PM, John R. Sowden
wrote:
> I made a mistake. I should have said table, not database. My concern is if
> I have 4 databases each with tables associated with a particular use, like
> accounting, technical, etc., which may reside on different computers, how do
> I
k to the office.
Thank you.
>
> John
>
>
>
> On 08/02/2018 11:33 AM, Igor Korot wrote:
>>
>> Hi,
>>
>> On Thu, Aug 2, 2018 at 1:27 PM, John R. Sowden
>> wrote:
>>>
>>> I made a mistake. I should have said table, not d
Hi,
On Tue, Jun 19, 2018 at 1:56 PM, Richard Hipp wrote:
> On 6/19/18, Igor Korot wrote:
>> Hi, Wout,
>>
>> On Tue, Jun 19, 2018 at 1:31 PM, Wout Mertens
>> wrote:
>>> you can query the table with
>>> https://www.sqlite.org/pragma.html#pragm
Hi, Simon,
On Thu, Jul 5, 2018 at 11:45 AM, Simon Slavin wrote:
> On 5 Jul 2018, at 4:51pm, Igor Korot wrote:
>
>> Is there a way to get which command was executed?
>> Or which table was added/changed/dropped?
>
> There is no reason for SQLite to record
Hi,
On Thu, Mar 1, 2018 at 1:20 PM, Matías Badin wrote:
> Hi all;
> I am trying to insert a big string and i have the message: Request too long.
>
> I set my parameter as "text" but i still have this problem.
>
> Do you know if i can use another type?
BLOB?
Thank you.
Hi,
On Sat, Oct 27, 2018 at 1:41 PM am...@juno.com wrote:
>
> 10/27/18 Dear Good People: I have two issues which I have not been able to
> solve. Hopefully at least one of you good people know how to do these. The
> first is: how do I make a field wrap the text. In other words, rather than
>
"sqlite3.c", line 29907: warning: conversion to double is out of range
"sqlite3.c", line 52491: warning: statement not reached
Is it something to be worry?
Thank you.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
Dennis,
On Sat, Jan 19, 2019 at 9:31 PM Dennis Clarke wrote:
>
>
> > And SPARC version is still available for download...
>
> Let us know when you get that running.
Install of x86 went very smooth.
And I was able to compile fairly recent SQLite with Oracle Studio 12.6
with just couple of
Hi,
On Sat, Jan 19, 2019 at 4:29 PM Dennis Clarke wrote:
>
> On 1/19/19 4:47 PM, Andy Goth wrote:
> > Dennis Clarke wrote:
> >> On 2018-07-28 08:33, Andy Goth wrote:
> >>> SQLite 3.24.0 fails to build on Solaris 9 (a.k.a. Solaris 2.9)
> >
> >> It may be [worth] while to spin up a Solaris 9 zone
Hi,
Unfortunately you didn't tell what did you try to compile, where did
you get the files you tried to compile from and
you didn't even supply the error message you received from the compilation.
Please follow-up and provide this and hopefully someone here will be
able to help.
Thank you.
On
Or for the simplicity sake - just add the sqlite3.* files to the
project and compile everything.
But then you will NOT need to follow the instruction in my previous email.
As Keith said, you should choose the path and follow it - either use
the source code
or use precompiled library.
Thank you.
Hi,
On Fri, Dec 21, 2018 at 6:26 PM zydeholic wrote:
>
> My cpp code consists of this at the moment:
> #include "sqlite3.h"
> #include
> #include
> using namespace std;
>
> int main()
> {
> sqlite3 *db;
> }
>
> I have added sqlite3.h to my header files.I have added sqlite3.c to my source
words. If you can, it would be
> helpful to know the route to get there, like
>
> Linker>>Input>>???
> Thanks for your time.
>
> From: Igor Korot
> To: SQLite mailing list
> Sent: Friday, December 21, 2018 4:47 PM
> Subject: Re: [sqlite] Ne
Hi,
On Tue, Nov 20, 2018 at 10:32 AM Dominique Devienne wrote:
>
> On Tue, Nov 20, 2018 at 5:28 PM Simon Slavin wrote:
>
> > On 20 Nov 2018, at 3:34pm, Albert Banaszkiewicz <
> > albert.banaszkiew...@tomtom.com> wrote:
> >
> > > ExecuteInTransaction(writeDb1, KCreateTable);
> >
> > I can't
Hi,
On Fri, Sep 14, 2018 at 3:14 PM Andrew Stewart
wrote:
>
> Hi all,
> I realize that this is the constraint that is failing. The
> data is very large, encrypted and at a customer's site - not easy to use an
> external program to view or to transfer to my office.
>
>
Hi,
On Mon, Jan 28, 2019 at 10:17 AM wrote:
>
> Dear,
>
> I developed an application that need to create 1 table with thousand of rows
> every time when a certain event occours.
Are you coming from the FoxBase/ForPro world?
Thank you.
>
> This works in a good way, but when the number of the
Hi,
On Fri, Apr 5, 2019 at 1:36 PM Jose Isaias Cabrera wrote:
>
>
> Thanks, Simon. Works like a charm...
Unless backwards compatibility is important (do you expect to go back to
pre-foreign keys implementation), I'd do FOREIGN KEY amd forget anout that...
Thank you.
>
>
> From: Simon Davies
Hi
On Tue, Mar 12, 2019 at 5:03 PM Ted Goldblatt wrote:
>
> On Tue, Mar 12, 2019 at 12:29 PM Simon Slavin wrote:
>
> > I may have missed this already being discussed.
> >
> > Will you have access to a copy of the database as it was before corruption
> > testing ? Can you use SQLite to see
Thank you.
On Sun, Feb 10, 2019 at 1:35 AM Shawn Wagner wrote:
>
> SELECT * FROM pragma_foreign_key_list('temp1');
>
> The table name needs to be a string for the pragma_foreign_key_list virtual
> table. (It's not for the corresponding pragma statement.)
>
> On Sat, Feb 9
Hi, ALL,
[code]
sqlite> SELECT * FROM sqlite_master WHERE name LIKE '%temp%';
type|name|tbl_name|rootpage|sql
table|temp|temp|40|CREATE TABLE temp(id INTEGER PRIMARY KEY, name VARCHAR(200))
table|temp1|temp1|41|CREATE TABLE temp1(myid INTEGER PRIMARY KEY, id INTEGER, my
name VARCHAR(200),
Hi,
On Tue, Jan 29, 2019 at 7:06 PM Keith Medcalf wrote:
>
> On Tuesday, 29 January, 2019 16:28, Wout Mertens wrote:
>
> >To: SQLite mailing list
> >Subject: Re: [sqlite] SQLite slow when lots of tables
> >
> > I always have to explain to people that there's no magic sauce that
> > "real
Peter,
On Tue, Jan 29, 2019 at 7:53 PM Peter da Silva wrote:
>
> On Tue, Jan 29, 2019, 7:46 PM Igor Korot
> > You can install mySQL/MariaDB for free and use it for your needs.
> > I believe that if you pay to Oracle/MariaDB Foundation, it will be
> > just for support
Hi, ALL,
Let's say I have some database, where I have table called test.
This test table contains the field whose type is BLOB.
Now I open this database in sqlite3 CLI binary and would like to insert some png
file inside this BLOB field. And I am not talking about the file name
- the actual
Hi, Richard,
Thank you for the reply.
On Sun, Jun 9, 2019 at 7:24 PM Richard Hipp wrote:
>
> On 6/9/19, Igor Korot wrote:
> >
> > Now I open this database in sqlite3 CLI binary and would like to insert some
> > png
> > file inside this BLOB field.
>
>
>
Hi,
On Mon, Sep 9, 2019 at 9:43 PM Doug wrote:
>
> What works, please? I saw no answer.
There is an answer down below.
Thank you.
> Doug
>
> > -Original Message-
> > From: sqlite-users
> > On Behalf Of Rael Bauer
> > Sent: Monday, September 09, 2019 7:01 PM
> > To:
Hi,
On Mon, Sep 23, 2019 at 11:58 AM Pierre Clouthier
wrote:
>
> Can anyone explain how to write UTF-8 in SQLite on the Mac?
>
> We use this statement:
>
> sqlite3_exec("PRAGMA encoding = \"UTF-8\";")
You should probably use this inside
#ifdef _WINDOWS #endif
Thank you.
>
> This
Hi,
On Sun, Oct 13, 2019 at 4:12 PM Shawn Wagner wrote:
>
> The documentation for a column with NUMERIC affinity says
>
> > When text data is inserted into a NUMERIC column, the storage class of
> the text is converted to INTEGER or REAL (in order of preference) if such
> conversion is lossless
Hi,
On Wed, Feb 19, 2020 at 2:12 PM Jose Isaias Cabrera wrote:
>
>
> Thanks, Keith. Darn it! GROUP BY and ORDER BY! Got it, it's working now.
> Thanks.
>
>
>
> From: sqlite-users on behalf
> of Keith Medcalf
> Sent: Wednesday, February 19, 2020 03:09 PM
>
Hi,
On Sun, Jan 12, 2020 at 7:44 PM Xingwei Lin wrote:
>
> Hi,
>
> Is there any way can we disable the dot commands feature in sqlite?
Are you talking about the SQLite shell?
Why do you want to disable them? What is your specific scenario?
Thank you.
>
> --
> Best regards,
> Xingwei Lin
>
Hi,
On Sat, Jan 4, 2020 at 7:31 PM Amer Neely wrote:
>
> Hello all,
> I'm fairly new to SQLite, but have been using MySQL / mariadb in a local
> and web-based environment for several years. So far I'm happy and
> impressed with SQLite, but I recently noticed some odd behaviour with
> one of my
Hi,
On Tue, Jan 7, 2020 at 2:01 AM Clemens Ladisch wrote:
>
> Richard Hipp wrote:
> > On 1/5/20, Keith Medcalf wrote:
> >> select * from a, b, c using (id); -- very strange result
> >
> > PostgreSQL and MySQL process the query as follows:
> >
> >SELECT * FROM a, (b JOIN c USING(id));
> >
>
Hi,
On Fri, Dec 27, 2019 at 12:57 PM Bigthing Do wrote:
>
> Dear sqlite developers:
>
> We met an accidental crash in sqlite with the following sample:
>
> CREATE VIEW table1 ( col1 , col2 ) AS WITH aaa AS ( SELECT * FROM table1 )
> SELECT col2 FROM table1 ORDER BY 1 ;
> WITH aaa AS ( SELECT *
401 - 441 of 441 matches
Mail list logo