[sqlite] Happy birthday to the SQLite Fossil repo

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

Re: [sqlite] althttpd.c check-in: efdc1b8e66

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

Re: [sqlite] Sample Employee database ported to SQLite from MySQL

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

Re: [sqlite] Sample Employee database ported to SQLite from MySQL

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

Re: [sqlite] Doing math in sqlite

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

Re: [sqlite] Doing math in sqlite

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/

[sqlite] Doing math in sqlite

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:

Re: [sqlite] SQLite version 3.25.0 enters release testing

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

Re: [sqlite] Mailing list shutting down...

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:

Re: [sqlite] sqlite.org website is now HTTPS-only

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

Re: [sqlite] sqlite.org website is now HTTPS-only

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

Re: [sqlite] Congratulations on 18 years

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 >

Re: [sqlite] SQLite3 fossil repository not working ?

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 >

Re: [sqlite] unknown type name 'sqlite_int64'

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.

Re: [sqlite] unknown type name 'sqlite_int64'

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

[sqlite] unknown type name 'sqlite_int64'

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

Re: [sqlite] How many AUTOINCREMENT tables are in your schema?

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

Re: [sqlite] Feature request for the Shell Tool: .mode json

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:

Re: [sqlite] Move to Github!!?

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

Re: [sqlite] Move to Github!!?

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

Re: [sqlite] Move to Github!!?

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

Re: [sqlite] Compiling / building SQLite to include regex

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

Re: [sqlite] Many ML emails going to GMail's SPAM

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

Re: [sqlite] Many ML emails going to GMail's SPAM

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

Re: [sqlite] Many ML emails going to GMail's SPAM

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

Re: [sqlite] Good resources for TCL/TK

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

Re: [sqlite] Best way to develop a GUI front-end

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

[sqlite] openbsd: cannot compile csv.c for SO

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

Re: [sqlite] Introduction to SQLite

Hi Simon, Thanks for sharing! ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] BedrockDB interview on Floss Weekly

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!

Re: [sqlite] Is there a way to perform a muti-level sort and extract of large data sets?

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

Re: [sqlite] Mailinglist question

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

Re: [sqlite] Version 3.20.0 coming soon...

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

Re: [sqlite] Version 3.20.0 coming soon...

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

Re: [sqlite] [patch] for test/backup2.test

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

Re: [sqlite] Documentation improvement recommendations

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

[sqlite] Documentation improvement recommendations

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

[sqlite] appfileformat.html

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

Re: [sqlite] Bug Report: https://www.sqlite.org/chronology.html out of date

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

Re: [sqlite] sqlite.org port 80 - can't connect

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'

[sqlite] sqlite.org port 80 - can't connect

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;

[sqlite] SQLite as a Shell Script

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:

Re: [sqlite] Unable to connect

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

[sqlite] sites inaccessible

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

Re: [sqlite] freebsd 11 SQLite build: readline/readline.h file not found

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

Re: [sqlite] freebsd 11 SQLite build: readline/readline.h file not found

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:

Re: [sqlite] freebsd 11 SQLite build: readline/readline.h file not found

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/

[sqlite] freebsd 11 SQLite build: readline/readline.h file not found

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

Re: [sqlite] sqlite separator command on one insert column

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

[sqlite] sqlite separator command on one insert column

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:

Re: [sqlite] How restrict access to SQLite database?

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

Re: [sqlite] Education Opportunity Alert: The SQL Primer

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:

Re: [sqlite] SQL / SQLite for Beginners

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,

[sqlite] determining is-leap-year in sqlite

appy to know this is not sqlite problem! -- --- inum: 883510009027723 sip: jungleboogie at sip2sip.info xmpp: jungle-boogie at jit.si

[sqlite] determining is-leap-year in sqlite

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

[sqlite] determining is-leap-year in sqlite

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

[sqlite] determining is-leap-year in sqlite

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

[sqlite] Is it possible that dropping a big table takes very long

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

[sqlite] hexadecimal conversion on select query

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" >

[sqlite] hexadecimal conversion on select query

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

[sqlite] hexadecimal conversion on select query

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

[sqlite] Build fail: undefined reference to `pthread_create'

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

[sqlite] Build fail: undefined reference to `pthread_create'

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

[sqlite] Build fail: undefined reference to `pthread_create'

- --- inum: 883510009027723 sip: jungleboogie at sip2sip.info xmpp: jungle-boogie at jit.si

[sqlite] Build fail: undefined reference to `pthread_create'

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

[sqlite] Build fail: undefined reference to `pthread_create'

centered around this commit: https://sqlite.org/src/info/9c3a0dc2e8bf202c -- --- inum: 883510009027723 sip: jungleboogie at sip2sip.info xmpp: jungle-boogie at jit.si

[sqlite] build failure: undeclared identifier 'uintptr_h'

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:

[sqlite] build failure: undeclared identifier 'uintptr_h'

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

[sqlite] SQLDIFF problem

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

[sqlite] editline/readline.h' file not found

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

[sqlite] editline/readline.h' file not found

ine 57 and will get sqlite3 to build and install. -- --- inum: 883510009027723 sip: jungleboogie at sip2sip.info xmpp: jungle-boogie at jit.si

[sqlite] editline/readline.h' file not found

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

[sqlite] 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

[sqlite] libtclsqlite3 assistance

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

[sqlite] libtclsqlite3 assistance

FreeBSD-10.2-RELEASE -- --- inum: 883510009027723 sip: jungleboogie at sip2sip.info xmpp: jungle-boogie at jit.si

[sqlite] CSV excel import

10009027723 sip: jungleboogie at sip2sip.info xmpp: jungle-boogie at jit.si

[sqlite] make test fails because fuzzdata1.txt is missing

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

[sqlite] make test fails because fuzzdata1.txt is missing

: 883510009027723 sip: jungleboogie at sip2sip.info xmpp: jungle-boogie at jit.si

[sqlite] build failure on trunk

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

[sqlite] build failure on trunk

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

[sqlite] What software is deployed more than SQLite?

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

[sqlite] What software is deployed more than SQLite?

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

[sqlite] What software is deployed more than SQLite?

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

Re: [sqlite] a couple of crashing bugs from a fuzzer

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:

Re: [sqlite] SQLite3 internal performance

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

[sqlite] Bug report on bug reporting page (grammatical errors)

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

Re: [sqlite] Student's t-test table

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

Re: [sqlite] [regression] SQLite 3.8.7 causes Evolution to crash

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

[sqlite] SSL Rating on SQLite.org

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. --

Re: [sqlite] Make a database read-only?

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

Re: [sqlite] sqlite max arguments assistance

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

Re: [sqlite] sqlite max arguments assistance

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

Re: [sqlite] sqlite max arguments assistance

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

Re: [sqlite] sqlite max arguments assistance

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

Re: [sqlite] sqlite max arguments assistance

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

Re: [sqlite] sqlite max arguments assistance

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

Re: [sqlite] sqlite max arguments assistance

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 *

Re: [sqlite] sqlite max arguments assistance

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

[sqlite] sqlite max arguments assistance

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