Just fun trivia that drh pointed out elsewhere late last month...
Ten years ago today, the first commit for SQLite was made in the Fossil
repo:
https://www.sqlite.org/src/timeline?c=b0848925babde524
___
sqlite-users mailing list
On Sat 27 Apr 2019 7:44 AM, Richard Hipp wrote:
On 4/26/19, Carl Chave wrote:
Should "index.cgi" from line number 1923 in subject check in include a
leading forward slash? My index.cgi scripts aren't being found with
this version (or any subsequent version) unless I explicitly include
it as
On Sun 23 Dec 2018 7:15 PM, Larry Brasfield wrote:
> Jungle Boogie wrote:
> ➢ Anyone else have issues decompressing the file? $ bzip2 -d employees.db.bz2
> bzip2: employees.db.bz2 is not a bzip2 file. bunzip2 employees.db.bz2
> bunzip2: employees.db.bz2 is not a bzip2
On Wed 19 Dec 2018 2:34 PM, Arun - Siara Logics (cc) wrote:
> This project (https://github.com/siara-cc/employee_db) hosts the Sqlite3 db
> file ported from mysql test_db found at
> https://github.com/datacharmer/test_db. It can be used to test your
> applications and database servers. To use
On Thu 20 Dec 2018 4:21 PM, Jungle Boogie wrote:
> Hi All,
>
> This is more of a how do I do this in sql question. I apologize in advance
> for a simple question, but I need to learn somehow, so any pointers are
> appreciated.
Thank you all for the helpful replies and educatio
On Thu 20 Dec 2018 6:26 PM, Barry Smith wrote:
>
>
> > On 20 Dec 2018, at 4:21 pm, Jungle Boogie wrote:
> >
> > Hi All,
> >
> > Some sample data:
> > 2018/04/15,foo,170644
> > 2018/04/15,bar.69625
> > 2018/04/22,foo,170821
> > 2018/
Hi All,
This is more of a how do I do this in sql question. I apologize in advance
for a simple question, but I need to learn somehow, so any pointers are
appreciated.
My very simple schema:
CREATE TABLE mileage (
date text,
"car" text,
"od_reading" integer
)
Some sample data:
On Tue, 11 Sep 2018 at 11:08, Richard Hipp wrote:
>
> We are in final testing for SQLite 3.25.0. Details on this release
> can be seen at
>
> https://www.sqlite.org/draft/releaselog/3_25_0.html
>
> There will be no further enhancements before the release. Bug fixes
> only. You can follow
On 13 June 2018 at 04:22, Richard Hipp wrote:
> Unfortunately, I'm going to need to shut down this mailing list due to
> robot harassment. I am working to come up with a fix or an
> alternative now. Your suggestions are welcomed.
>
OpenBSD uses Majordomo for their mailing lists:
On 7:24PM, Thu, Jun 7, 2018 George wrote:
>
> On Thu, 7 Jun 2018 14:31:22 -0400
> Richard Hipp wrote:
>
> > As an experiment, I have reconfigured the sqlite.org website to
> > redirect all HTTP requests over to HTTPS.
> >
> > Let me know if this causes anybody any unnecessary grief. It is easy
On 1:38PM, Thu, Jun 7, 2018 Keith Medcalf wrote:
>
>
> Just tell wget --no-check-certificate in the command line. wget does not
use a certificate repository and you need to obtain and specify the
expected root manually. It will be no less secure than it was before (when
using HTTP) except that
On 30 May 2018 at 03:27, Christian Schmitz
wrote:
> Hello,
>
> Congratulations to the SQLite team.
>
> As far as I see, the first checkin was 2000-05-29, which was over 18 years
> ago.
Way to go! What a truly awesome project this has been!
>
> Sincerely
> Christian
>
On Tue 08 May 2018 9:32 AM, Domingo Alvarez Duarte wrote:
> Hello !
>
> Today I tried to update my sqlite3 repository but somehow it seems not
> working properly, I execute "fossil update" as usually and it contacts the
> server and exchange info with it but it only see till this commit
>
Thus said Igor Korot on Mon, 30 Apr 2018 20:28:54 -0500
Why did you need configure?
Turns out I needed to disable editline and readline, but it eventually
builds! thanks for the input.
And yes, I am ignoring you awareessi555 AT safenmeet.xyz
Just do make.
Thank you.
On 5:20PM, Mon, Apr 30, 2018 Igor Korot <ikoro...@gmail.com> wrote:
>
> Hi,
>
> On Mon, Apr 30, 2018 at 6:30 PM, jungle Boogie <jungleboog...@gmail.com>
wrote:
> > Hi All,
> >
> > What's happening here?
> >
> > $ cc --version
> > OpenBSD
Hi All,
What's happening here?
$ cc --version
OpenBSD clang version 6.0.0 (tags/RELEASE_600/final) (based on LLVM 6.0.0)
Target: aarch64-unknown-openbsd6.3
Thread model: posix
ARM64 bit on a pine64-lts device running:
OpenBSD 6.3-current (GENERIC.MP) #91: Mon Apr 30 01:29:06 MDT 2018
On 16 March 2018 at 08:37, Richard Hipp wrote:
> This is a survey, the results of which will help us to make SQLite faster.
>
> How many tables in your schema(s) use AUTOINCREMENT?
>
0
___
sqlite-users mailing list
On Sun 21 Jan 2018 4:21 PM, Simon Slavin wrote:
>
>
> On 21 Jan 2018, at 3:05pm, Brian Curley wrote:
>
> > pipe it
> > through jq instead.
>
> I did not know jq existed. Thanks. Just gave the documentation a quick
> glance.
>
You might like to see some code examples:
On Tue 26 Dec 2017 2:09 PM, Warren Young wrote:
> On Dec 26, 2017, at 2:47 AM, J Decker wrote:
> >
> > doesn't require a fee unless they want to amke it private.
>
> You’re speaking of today’s benevolent policies.
>
Yes, I completely agree with everything you said. Nicely
On Tue 26 Dec 2017 3:08 PM, Damien Sykes wrote:
> Hi,
> This is a question I have asked myself many times (I.E. Git projects moving
> to Fossil).
> GitHub is well known and boasts over 74 million repositories, yet Fossil,
> which both hosts and utilises one of the most well-known database systems
On Mon 25 Dec 2017 11:49 PM, Shekhar Reddy wrote:
> Hi,
>
> Is there any particular reason that the source is not moved to GitHub? I
> think that would reach more number of people there.
>
So are you saying it would be the most used in the galaxy?
SQLite is the most used database engine in the
On 21 December 2017 at 10:18, Richard Hipp wrote:
> On 12/21/17, Paul Hoffman wrote:
>> Greetings. I understand that SQLite doesn't come natively with regex
>> support, but that it can be added. My question is how to do so when I
>> install. I'm building
On 22 November 2017 at 07:56, Igor Korot wrote:
> Hi,
> Postgres very recently switched to PGLister for their ML
>
> This software switch tries to do exactly that - it tries to stay
> complaint with all this DMARC stuff.
>
> Here is the announcement that was posted on their
On 21 November 2017 at 11:42, Warren Young wrote:
> On Nov 21, 2017, at 10:24 AM, Peter Da Silva
> wrote:
>>
>> But the mailers I use (Gmail’s web interface, Apple Mail and (yuck) Outlook)
>> all do basic threading.
>
> I’d describe what Apple
On 21 November 2017 at 06:30, Richard Hipp wrote:
> On 11/21/17, Paul Sanderson wrote:
>> Coincidence! I have just been in my gmail folder marking a load of SQLite
>> email as 'not spam'
>
> I've been seeing mailing list emails go to spam for a
Thus said Cecil Westerhof on Sat, 18 Nov 2017 14:43:23 +0100
I found the benefits for TCL/TK. But this is a SQLite mailing list, so not
the right place to ask questions if it is not connected to SQLite also.
What would be good resources for TCL/TK?
There's also a pretty active IRC room on
Thus said J Decker on Tue, 14 Nov 2017 13:35:55 -0800
I'll throw my 2 cents in...
A Node.js server, and use a web frontend, or electron/nwjs which are
browsers that include node, and can be standalone apps.
Funny you should mention that. I've been looking at node.js and curious
how sqlite
Hello,
I don't know know if this is an openBSD issue or something with sqlite3
- posting here for guidance.
I'd like to make a loadable module for csv, but when attempting to
generate the so file, I see this:
$ gcc -g -fPIC -shared csv.c -o csv.o
csv.c:42:24: error: sqlite3ext.h: No such
Hi Simon,
Thanks for sharing!
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Hi All,
Pardon the usual interruption of complex sqlite questions...
David Barrett was interviewed on Floss Weekly today and gave a rave
review of his project, which is based on the wonderful sqlite3
database.
I'm only 10 minutes into the interview and really love it already!
Hi there,
Just because I'm interested, I'm wondering if you can identify your
hardware, and how long it takes your system to do your desired operation on
such a large number of records.
Do let us know which option you performed the query with as well.
P.S. For best results, I'd recommend using
On 9 August 2017 at 15:02, Nico Williams wrote:
> On Wed, Aug 09, 2017 at 03:48:34PM -0600, Keith Medcalf wrote:
>> There is a solution since about 1984 ... it is called NNTP (Usenet
>> News). Google Groups is basically Usenet News with a (so some people
>> thing -- but
On 13 July 2017 at 11:49, Richard Hipp wrote:
> The 3.20.0 release of SQLite is expected in about a week. Please
> report any issues that you have with the beta as soon as possible.
>
> Code is available in the "prerelease snapshot" at
> https://sqlite.org/download.html
>
> An
On 13 July 2017 at 11:49, Richard Hipp wrote:
> The 3.20.0 release of SQLite is expected in about a week. Please
> report any issues that you have with the beta as soon as possible.
>
> Code is available in the "prerelease snapshot" at
> https://sqlite.org/download.html
>
> An
Hi All,
On 07/06/2017 10:51 PM, Pavel Volkov wrote:
Hello.
Please, make test 'test/backup2.test' more compatible with FreeBSD.
This is patch for it:
--- test/backup2.test.orig 2017-07-07 04:59:34 UTC
+++ test/backup2.test
@@ -143,7 +143,7 @@ do_test backup2-9 {
#
if
Here's a couple more.
On this page: https://www.sqlite.org/src/doc/trunk/README.md
describes the LALR(1) grammer
should be:
describes the LALR(1) grammar
Each has a suscinct
should be:
Each has a succinct
-
On this page: https://www.sqlite.org/dbstat.html
The the DBSTAT virtual
Hi All,
Here's a list of some documentation improvements.
-
On this page: https://www.sqlite.org/rbu.html
an RBU Vaccum is
should be:
an RBU Vacuum is
What about this change.
Preparing An RBU Update File
To:
Preparing an RBU Update File
Too many words:
it may be be more
Hi SQLITE Committers,
I noticed a misspelling here:
https://www.sqlite.org/appfileformat.html
catagory is misspelled; it should be: category.
First committed here:
https://www.sqlite.org/docsrc/info/6d257b8d928cfd00
Thanks!
--
---
inum: 883510009027723
sip: jungleboo...@sip2sip.info
On 20 June 2017 at 07:55, Tom Ritter wrote:
> In lieu of an official support RSS feed,
> https://www.sqlite.org/chronology.html is used to detect new versions
> of SQLite and how out of date the current one embedded in a product
> is. It worked for the past several months, but now
On 12 June 2017 at 01:03, Richard Hipp <d...@sqlite.org> wrote:
> On 6/12/17, jungle boogie <jungleboog...@gmail.com> wrote:
>> Hi All,
>>
>> curl: (7) Failed to connect to www.sqlite.org port 80: Connection refused
>
> xinetd keeps crashing. Dunno why. I'
Hi All,
curl: (7) Failed to connect to www.sqlite.org port 80: Connection refused
https is working fine:
curl --head https://www.sqlite.org
HTTP/1.1 200 OK
Connection: keep-alive
Date: Mon, 12 Jun 2017 07:37:35 +
Last-Modified: Fri, 09 Jun 2017 14:05:33 +
Content-type: text/html;
Hi All,
Pretty interesting article:
https://www.invincealabs.com/blog/2016/11/sqlite-shell-script/
This post documents how we were able to create a SQLite database that
can be executed as an ash shell script purely from SQL queries.
Found here:
On 11/13/2016 10:29 PM, Cecil Westerhof wrote:
When going to www.sqlite.org I get:
Unable to connect
Also happening for me.
Use https://www.sqlite.org/ until non-https is restored.
___
sqlite-users mailing list
Hi Dr. Hipp,
Probably a low concern for you at 1:30am your time but I can't connect
to fossil-scm.org or sqlite.org over port 80.
$ curl http://sqlite.org/
curl: (7) Failed to connect to sqlite.org port 80: Connection refused
$ curl http://fossil-scm.org
curl: (7) Failed to connect to
On 18 October 2016 at 15:09, Warren Young <w...@etr-usa.com> wrote:
> On Oct 18, 2016, at 3:59 PM, jungle Boogie <jungleboog...@gmail.com> wrote:
>>
>> On 18 October 2016 at 13:55, Warren Young <w...@etr-usa.com> wrote:
>>> Did you ./configure af
On 18 October 2016 at 13:55, Warren Young wrote:
> Did you ./configure after the upgrade? If not, do so.
yes, this is my standard config:
./configure --disable-editline; make
sqliteup is an alias in my shell to do this and then sudo make install
--
---
inum:
On 15 October 2016 at 23:45, jungle Boogie <jungleboog...@gmail.com> wrote:
> Readline.h is found here:
> # find / -name readline.h
> /usr/local/include/editline/readline.h
> /usr/local/include/readline/readline.h
> /usr/local/include/guile/2.0/readline.h
> /usr/include/
Hi All,
I just re-installed freebsd 11 on a machine of mine and as usual, I
build sqlite from source. However, I see this:
sqlite3/src/shell.c:66:11: fatal error: 'readline/readline.h' file not found
I'm quite sure I didn't have problems on the 10.x branch with sqlite,
so I don't know if things
On 26 September 2016 at 13:17, R Smith wrote:
> sqlite3.exe dropped.db "INSERT INTO DropDB_log(date, ip_address, status)
> VALUES (%DATE%, %%A, '%STATUS%');"
YES!
During my lunch break, I don't know why it didn't click to make this a
loop until I got back and saw your
Hi All,
I'm attempting to make a windows batch file that reads a text file and
inserts a new record for each entry:
sqlite3.exe dropped.db "INSERT INTO
`DropDB_log`(`date`,`ip_address`,`status`) VALUES
(%DATE%,readfile('machinelist.txt'),'%STATUS%');"
Right now, it does this:
On 9 August 2016 at 12:11, Jaime Stuardo wrote:
> Please, give more details. I have found I can encrypt the database, but how?
> I am using SQLite manager of Firefox extension.
There's a paid sqlite extension called SEE:
https://www.sqlite.org/see/doc/trunk/www/index.wiki
On 4 August 2016 at 08:14, R.A. Nagy wrote:
> Comments & suggestion for improvement be both respected, as well as
> appreciated here, as usual!
WOW! Such great energy and enthusiasm in the primer video!
I'm looking forward to the rest.
Best,
sean
--
---
inum:
On 26 May 2016 at 05:49, R.A. Nagy wrote:
> Would this be the preferred pronunciation?
>
> https://youtu.be/hB54p_Xh37M
>
That goes a bit too fast but it sounds right to my ears.
Listen to this interview:
https://changelog.com/201/
If you tune in around 17:20 seconds,
appy to know
this is not sqlite problem!
--
---
inum: 883510009027723
sip: jungleboogie at sip2sip.info
xmpp: jungle-boogie at jit.si
On 8 May 2016 at 12:28, jungle Boogie wrote:
> I'll set the TZ on the pi to match and see what happens.
We're on to something!
pi time:
$ date
Sun May 8 12:29:54 PDT 2016
x86 time:
% date
Sun May 8 12:30:04 PDT 2016
They match with cal.sql now!
http://kopy.io/GbbDR
So no prob
nsist on a perfect world, freedom will have to do." -- Bigby Wolf
--
---
inum: 883510009027723
sip: jungleboogie at sip2sip.info
xmpp: jungle-boogie at jit.si
the only guaranteed byproduct of
> those who insist on a perfect world, freedom will have to do." -- Bigby Wolf
--
---
inum: 883510009027723
sip: jungleboogie at sip2sip.info
xmpp: jungle-boogie at jit.si
etes in my case.
This whole thread sounds like a good use case for flame graphs:
http://brendangregg.com/flamegraphs
--
---
inum: 883510009027723
sip: jungleboogie at sip2sip.info
xmpp: jungle-boogie at jit.si
Hi Keith,
On 13 March 2016 at 13:31, Keith Medcalf wrote:
> On Sunday, 13 March, 2016 13:36 -07:00, jungle Boogie gmail.com> wrote:
>> Here it is in decimal: (select code from sidemeters)
>> "0"
>> "1"
>> "2"
>> "5"
>
uot;%x",code) FROM
sidemeters)
"0"
"1"
"2"
"5"
"6"
"7"
"1c"
"1d"
"1e"
"1f"
Here is with hex(code): (SELECT hex(code) FROM sidemeters)
"30"
"31"
"32"
"35"
"36"
"37"
"3238"
"3239"
"3330"
"3331"
Am I trying to use hex() incorrectly?
Thanks!
--
---
inum: 883510009027723
sip: jungleboogie at sip2sip.info
xmpp: jungle-boogie at jit.si
rily need to include
the extra %d, but it's nice for comparison.
Thanks for any input!
--
---
inum: 883510009027723
sip: jungleboogie at sip2sip.info
xmpp: jungle-boogie at jit.si
Hi Robert,
On 27 January 2016 at 14:20, Robert Weiss wrote:
> A few builds ago I got a similar message. I don't recall whether I actively
> tried to use threads or got blindsided by change. The short story is that
> linking in libpthread caused the build to succeed. The longer story is that
u are seeing and to devise a work-around. The change
> facilitates compiling SQLite with ASAN.
I think this is who you're referring to: https://hboeck.de/
I have contacted him off-list to see if he has any suggestions.
--
---
inum: 883510009027723
sip: jungleboogie at sip2sip.info
xmpp
-
---
inum: 883510009027723
sip: jungleboogie at sip2sip.info
xmpp: jungle-boogie at jit.si
Sent from my iPhone 7.1
On Jan 20, 2016 11:25 AM, "jungle Boogie" wrote:
>
> Hello All,
>
> My last successful build was SQLite version 3.11.0 2016-01-12 14:10:05
>
> I build with: ./configure --disable-editline; make
>
>
> ./.libs/libsqlite3.a(sqlite3
centered around this commit:
https://sqlite.org/src/info/9c3a0dc2e8bf202c
--
---
inum: 883510009027723
sip: jungleboogie at sip2sip.info
xmpp: jungle-boogie at jit.si
On 10 December 2015 at 10:00, Richard Hipp wrote:
> On 12/10/15, jungle Boogie wrote:
>>
>> Updating to trunk this morning results in this failure when attempting to
>> build:
>>
>
> Should be fixed now. Please try again.
Well done! Thanks.
--
---
inum:
ite3
Current installed version: SQLite version 3.10.0 2015-12-03 13:43:07
--
---
inum: 883510009027723
sip: jungleboogie at sip2sip.info
xmpp: jungle-boogie at jit.si
now for legacy.
How does one invoke the sqldiff tool? I see the c file in
tool/sqldiff.c. I don't see a download for any OS at
https://www.sqlite.org/download.html
Thanks!
--
---
inum: 883510009027723
sip: jungleboogie at sip2sip.info
xmpp: jungle-boogie at jit.si
On 10 November 2015 at 04:52, Richard Hipp wrote:
> On 11/10/15, jungle Boogie wrote:
>> On 9 November 2015 at 19:29, Richard Hipp wrote:
>>> Works for me on OpenBSD 5.8. No issues at all.
>>
>>
>> Failing on freebsd with this make file:
>> https://ww
ine 57 and will get sqlite3 to build and install.
--
---
inum: 883510009027723
sip: jungleboogie at sip2sip.info
xmpp: jungle-boogie at jit.si
On 8 November 2015 at 19:51, jungle Boogie wrote:
> sqlite3 /home/jungle/fossil-repos/sqlite3/src/shell.c
> ./.libs/libsqlite3.a -ledit -lpthread -Wl,-rpath -Wl,/usr/local/lib
> /home/jungle/fossil-repos/sqlite3/src/shell.c:71:11: fatal error:
> 'editline/readline.h' file not found
erated.
*** Error code 1
Stop.
make: stopped in /usr/home/jungle/fossil-repos/sqlite3
--
---
inum: 883510009027723
sip: jungleboogie at sip2sip.info
xmpp: jungle-boogie at jit.si
Hi Dr. H,
On 21 August 2015 at 14:23, Richard Hipp wrote:
> On 8/21/15, jungle Boogie wrote:
>>
>> Is it possible to compile in libtclsqlite3?
>>
>
> Dunno. But you can compile the libtclsqlite3.so yourself:
>
> make tclsqlite3.c
> gcc -fPIC -shared
FreeBSD-10.2-RELEASE
--
---
inum: 883510009027723
sip: jungleboogie at sip2sip.info
xmpp: jungle-boogie at jit.si
10009027723
sip: jungleboogie at sip2sip.info
xmpp: jungle-boogie at jit.si
0 max 2560 max-size 2560
Maximum memory usage: 237856 bytes
Current memory usage: 0 bytes
Number of malloc() : -1 calls
*** Error code 1
Stop.
make: stopped in /usr/home/user/fossil-repos/sqlite3
Is that anything to be concerned about?
--
---
inum: 883510009027723
si
: 883510009027723
sip: jungleboogie at sip2sip.info
xmpp: jungle-boogie at jit.si
On 4 May 2015 at 13:12, Richard Hipp wrote:
> On 5/4/15, jungle Boogie wrote:
>> Hello All,
>>
>> I don't think this is severe but just bringing it up as a new release
>> is imminent
>
> Try running "make clean; make" Let us know if that fails to c
Hello All,
I don't think this is severe but just bringing it up as a new release
is imminent
...
http://hastebin.com/dajofuzetu.md
--
---
inum: 883510009027723
sip: jungleboogie at sip2sip.info
xmpp: jungle-boogie at jit.si
On 4 May 2015 at 10:01, Tim Streater wrote:
> On 04 May 2015 at 17:31, jungle Boogie wrote:
>
>> On 4 May 2015 at 07:58, Warren Young wrote:
>>> On May 3, 2015, at 6:50 PM, jungle Boogie
>>> wrote:
>>>>
>>>> On 3 May 2015 at 11:18
On 4 May 2015 at 07:58, Warren Young wrote:
> On May 3, 2015, at 6:50 PM, jungle Boogie wrote:
>>
>> On 3 May 2015 at 11:18, Richard Hipp wrote:
>>> Any input you can provide is appreciated!
>>
>> Congratulations to you and your team on SQLite's achievement
e it's in a draft state/stage or if it's linking
incorrectly.
--
---
inum: 883510009027723
sip: jungleboogie at sip2sip.info
xmpp: jungle-boogie at jit.si
Richard,
On 8 January 2015 at 17:29, Richard Hipp wrote:
> On 1/8/15, Michal Zalewski wrote:
>
>> I have been running afl-fuzz against sqlite and bumped in a bunch of
>> bugs that seem to crash the sqlite3 binary
>
> Fixed here:
Hi Edward,
On 25 December 2014 at 19:33, Edward Lau wrote:
>
> Hi Folks:
> I have read in many posting that SQLite is fast. How fast is fast? So over
> this holiday break I tried to take a reading on the VDBE performance to get a
> general idea. I wrote a quick module to
Hello All,
Page: https://www.sqlite.org/src/wiki?name=Bug+Reports
I recommend this change:
>what the problem is.
what the problem was.
Reason: Rest of discussion is in past tense.
>There were also numerous duplicates.
There were also numerous duplicate bug reports.
Reason: more complete
Hi Giuseppe,
On 16 November 2014 00:28, Giuseppe Costanzi wrote:
> if it serves to someone I have attached it
>
Attachments don't come through, post a link to the file.
> regards
> 1966bc
>
Best,
jb
--
---
inum: 883510009027723
sip: jungleboo...@sip2sip.info
Dear Richard, Ralf
From: Richard Hipp
Sent: Wed, 22 Oct 2014 21:53:36 -0400
To: General Discussion of SQLite Database Cc: Ralf
Mardorf
Subject: Re: [sqlite] [regression] SQLite
Hello All/Richard,
Unrelated to databases, sql, and sqlite but I noticed the poor rating on
sqlite.org of an F:
https://www.ssllabs.com/ssltest/analyze.html?d=sqlite.org
It would be nice to have a better rating!
On the positive side, oracle.com doesn't even have an SSL for the homepage.
--
Dear Ross,
From: Ross Altman
Sent: Tue, 14 Oct 2014 14:38:41 -0400
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Make a database read-only?
>
Thanks everyone for the helpful
23 Sep 2014, at 12:24am, Jungle Boogie <jungleboog...@gmail.com> wrote:
>>
>> I did this:
>> sqlite> create table august
>> (MERCHANT_ID,DBA,WHITELABEL_ID,ORDER_ID,TRANSACTION_DISPLAY_DATE,TYPE,STATE,TRANSACTION_AMOUNT);
>> sqlite> .separator ","
&g
Dear Kees,
From: Kees Nuyt
Sent: Mon, 22 Sep 2014 23:59:52 +0200
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] sqlite max arguments assistance
>
> and/or the receiving table doesn't define column
> transaction_amount as a numeric
Dear Igor,
From: Igor Tandetnik
Sent: Mon, 22 Sep 2014 16:34:18 -0400
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] sqlite max arguments assistance
>
>
> Just as I thought. You are storing your values as text - not as numbers
Sep 2014, at 10:02pm, Jungle Boogie <jungleboog...@gmail.com> wrote:
>
>> Is there anything I can do post export from the other database to change the
>> values correctly?
>
> You need to strip the dollar signs off at some stage.
>
> Ideally you can do
Dear Igor,
From: Igor Tandetnik
Sent: Mon, 22 Sep 2014 16:34:18 -0400
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] sqlite max arguments assistance
>
>
> Just as I thought. You are storing your values as text - not as numbers
Hi Igor,
On 22 September 2014 12:52, Igor Tandetnik wrote:
>
>
> Dollar sign or not, the outcome you observe suggests that the values are
> stored as strings. What does this query return?
>
> select typeof(transaction_amount), count(*) from august group by 1;
>
> My guess is
Dear Igor,
From: Igor Tandetnik <i...@tandetnik.org>
Sent: Mon, 22 Sep 2014 15:25:43 -0400
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] sqlite max arguments assistance
>
> On 9/22/2014 3:12 PM, Jungle Boogie wrote:
>> select *
2 Sep 2014, at 8:12pm, Jungle Boogie <jungleboog...@gmail.com> wrote:
>
>> Result:
>> $999.63
>> (I trimmed out other items that I can't show).
>>
>> Same results with this: select max(transaction_amount) from august
>> $999.63
>>
>>
>> But
Hello All,
select * from august where transaction_amount = (select
max(transaction_amount) from august)
This statement should show be the merchant account with the top most expensive
transaction from my table called august.
Result:
$999.63
(I trimmed out other items that I can't show).
Same
99 matches
Mail list logo