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

I wrote myself > >You're level of cool just jumped to UNIX silverback level :-) Meh. *All* programmers of a certain age wrote their own web server. Ron ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to convert a datetime column to a date?

Thanks, I was able to patch the table by removing the single tick marks using the trim and the group by query now works as expected. -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of R Smith Sent: Thursday, March 22, 2018 7:23 AM

Re: [sqlite] How to convert a datetime column to a date?

to convert a datetime column to a date? SQLITE3 datetime fields are actually text. Fix the file that you're importing so it doesn't have quotes around the date. It looks like you're using some kind of modified CSV exporter to create the file. On 3/22/18, 9:06 AM, "sqlite-users on behalf

Re: [sqlite] How to convert a datetime column to a date?

o: SQLite mailing list Subject: Re: [sqlite] How to convert a datetime column to a date? 1. It looks like you have superfluous quotes around the dates. That's probably your issue. 2. Try "select distinct dttm from foo LIMIT 10;" On 3/22/18, 8:47 AM, "sqlite-users on b

Re: [sqlite] How to convert a datetime column to a date?

ite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of R Smith Sent: Thursday, March 22, 2018 6:48 AM To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] How to convert a datetime column to a date? On 2018/03/22 3:21 PM, Ron Watkins wrote: > It doesn'

Re: [sqlite] How to convert a datetime column to a date?

The table defines “dttm” as a “datetime” datatype. sqlite> select distinct dttm from foo; … (lots of records) '2018-03-22 06:25:01' '2018-03-22 06:26:01' '2018-03-22 06:27:01' '2018-03-22 06:28:01' '2018-03-22 06:29:01' '2018-03-22 06:30:01' '2018-03-22 06:31:01' '2018-03-22

Re: [sqlite] How to convert a datetime column to a date?

sers-boun...@mailinglists.sqlite.org] On Behalf Of R Smith Sent: Thursday, March 22, 2018 4:21 AM To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] How to convert a datetime column to a date? On 2018/03/21 5:30 PM, Ron Watkins wrote: > I have a table which contains a dat

[sqlite] How to convert a datetime column to a date?

I have a table which contains a datetime column: table|foo|foo|2|CREATE TABLE foo ( dttmdatetimenot null i int not null ) I want to select out the max(i) value for each day where there are multiple records per day. select date(dttm) dt,max(i)

Re: [sqlite] new Error database disk image is malformed

I'm coding that now. I never thought about it. Thank you! -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Jens Alfke Sent: Friday, January 5, 2018 1:34 PM To: SQLite mailing list Subject:

Re: [sqlite] new Error database disk image is malformed

/9nblggh533kc -Ron -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Jens Alfke Sent: Thursday, January 4, 2018 8:03 PM To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Subject: Re: [sqlite] new Error database disk

Re: [sqlite] new Error database disk image is malformed

;New=False;Max Page Count=10485760;Compress=True;journal_mode=WAL;" Regards, -Ron -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of R Smith Sent: Thursday, January 4, 2018 3:14 PM To: sqlite-users@mailinglists.sqlite.org Subject: Re

Re: [sqlite] new Error database disk image is malformed

is malformed On 2018/01/04 9:49 PM, Ron Barnes wrote: > Hi All, > > I keep generating this error and I can't figure out why. I have deleted and > re-created the database but it keeps popping up. > > Error > > database disk image is malformed > > > Any ideas wh

[sqlite] new Error database disk image is malformed

Hi All, I keep generating this error and I can't figure out why. I have deleted and re-created the database but it keeps popping up. Error database disk image is malformed Any ideas why? -Ron ___ sqlite-users mailing list sqlite-users

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

 Than you! -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Stephen Chrzanowski Sent: Tuesday, September 26, 2017 4:31 PM To: SQLite mailing list Subject: Re: [sqlite] Is there a way to

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

: SQLite mailing list >Subject: Re: [sqlite] Is there a way to perform a muti-level sort and >extract of large data sets? > > > >On 26 Sep 2017, at 6:24pm, Ron Barnes <rbar...@njdevils.net> wrote: > >> I need to sort them as follows... >> >> Sort Field

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

Sent: Tuesday, September 26, 2017 2:14 PM To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Subject: Re: [sqlite] Is there a way to perform a muti-level sort and extract of large data sets? On Sep 26, 2017, at 11:24 AM, Ron Barnes <rbar...@njdevils.net> wrote:

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

org> Subject: Re: [sqlite] Is there a way to perform a muti-level sort and extract of large data sets? On 26 Sep 2017, at 6:24pm, Ron Barnes <rbar...@njdevils.net> wrote: > I need to sort them as follows... > > Sort Field 1 Ascending > Sort Field 2 Ascending WITHIN field 1

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

est) Date to float up Sort Field 5 Ascending WITHIN field 4 WITHIN field 3 WITHIN field 2 WITHIN field 1 Thank you in advance! -Ron ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listi

Re: [sqlite] (no subject)

This seems to be exactly what I'm looking for. Thanks! --Ron Op ma 17 jul. 2017 om 20:23 schreef Jens Alfke <j...@mooseyard.com> > > > On Jul 17, 2017, at 11:08 AM, Ron <ron.a...@gmail.com> wrote: > > > > I am looking into the possibility of putting

Re: [sqlite] logical decoding?

gt; simpler too. > > -j > > > > > > On Jul 17, 2017, at 1:08 PM, Ron <ron.a...@gmail.com> wrote: > > > Hi, > > > > Before I dive into the SQLite internals, I'd like to ask the mailing list > > first. > > > > I am looking into the possibi

[sqlite] (no subject)

it be hard to get this info out of SQLite? PostgreSQL calls it 'logical decoding'. I may not need the full feature, but I would need all changed records. Thanks for any insights. Ron Arts ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http

Re: [sqlite] SQLite - Interrogate Date/Time field Statement question

at run-time, then the "*X* REGEXP *Y*" operator will be implemented as a call to "regexp(*Y*,*X*)". https://sqlite.org/lang_expr.html Type of regular expression needed: https://social.msdn.microsoft.com/Forums/en-US/7f38ee7b-15e2-4e2c-8389-1266f496e4b2/regular-expression-to-g

Re: [sqlite] SQLite - Interrogate Date/Time field Statement question

That worked Thank you very Much!! -Ron -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of R Smith Sent: Wednesday, April 12, 2017 10:12 AM To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] SQLite - Interrogate Date

Re: [sqlite] SQLite - Interrogate Date/Time field Statement question

nder 2 Year' WHEN DaysSince < 1826 THEN 'Under 5 Years' WHEN DaysSince < 3651 THEN 'Under 10 Years' ELSE 'Over 10 Years' END) AS category FROM Volume_Information) derivedtbl_1 GROUP BY category Thanks, -Ron -Original Message- From: sqlite-users [mailto:sqlite-users-boun...

Re: [sqlite] SQLite - Interrogate Date/Time field Statement question

and generate my counts. I very much appreciate all your effort!!! And to the SQLite community as well! Regards, -Ron -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of R Smith Sent: Wednesday, April 12, 2017 7:49 AM To: sqlite

Re: [sqlite] SQLite - Interrogate Date/Time field Statement question

) Difference from the current date? Thanks in advance, -Ron -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Jim Callahan Sent: Tuesday, April 11, 2017 11:22 PM To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Subje

Re: [sqlite] Select Statement returning incorrect information

Hello Simon, Got that one on my own! The Data was created long before me but I do have the option to alter columns if needs be. Hoping Richard can help out on the Date Select I'm struggling with! Regards, -Ron -Original Message- From: sqlite-users [mailto:sqlite-users-boun

Re: [sqlite] SQLite - Interrogate Date/Time field Statement question

, I'll be visiting Disney in July! Regards, -Ron -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Jim Callahan Sent: Tuesday, April 11, 2017 9:15 PM To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Subject: Re: [

Re: [sqlite] Select Statement returning incorrect information

riginal Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Ron Barnes Sent: Tuesday, April 11, 2017 9:15 PM To: 'SQLite mailing list' <sqlite-users@mailinglists.sqlite.org> Subject: [sqlite] Select Statement returning incorrect information Hello All,

[sqlite] Select Statement returning incorrect information

EN 'Less Than 25 GB' ELSE 'Larger Than 25GB' END) AS category FROM Volume_Information) derivedtbl_1 GROUP BY category Regards, -Ron ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite - Interrogate Date/Time field Statement question

would be greatly appreciated, Thanks, -Ron ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Continuous recovery of journal

? Regards, -Ron ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Reporting Solutions that work with SQLite / VB 2015?

All, Pardon me for interjecting. Are there any reporting solutions that work with VB 2015? -Ron -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of James K. Lowden Sent: Saturday, April 1, 2017 8:11 PM To: sqlite-users

[sqlite] What is the best way to select "evenly" ?

nd I'm scratching my head as to how to accomplish this. The purpose here is to distribute jobs over processing units, distributing the load as evenly as possible. Suggestions very welcome! -- Ron Aaron, CTO Aaron High-Tech, Ltd. +1 425.296.0766 +972 52.652.5543 GPG Key: 91F92EB8 <https://p

[sqlite] Getting a crash on 32-bit Linux

haps something to do with compiler flags, though I don't set the 'arch' or 'tune' to anything. So. Problem solved, and nothing really to do with sqlite per se; but I do wish compilers would do less on my behalf... -- Ron Aaron, CTO Aaron High-Tech, Ltd. +972.52.652.5543 <http://8th-dev.com>

[sqlite] Getting a crash on 32-bit Linux

On 4/14/15 21:06, Richard Hipp wrote: > On 4/14/15, Ron Aaron wrote: >> Something is very wrong, then. The file I downloaded from the >> sqlite.org site, and unzipped, has these: > Yes. My previous email had the wrong version of sqlite3.. Version > 3.8.9 states: >

[sqlite] Getting a crash on 32-bit Linux

Yes: I issued the command: unzip ~/Downloads/sqlite-amalgamation-3080900.zip file reports: Downloads/sqlite-amalgamation-3080900.zip: Zip archive data, at least v1.0 to extract md5 sum: 02e9c3a6daa8b8587cf6bef828c2e33f On 4/14/15 21:05, Nelson, Erik - 2 wrote: > Ron Aaron wr

[sqlite] Getting a crash on 32-bit Linux

Something is very wrong, then. The file I downloaded from the sqlite.org site, and unzipped, has these: ~/src/sqlite-amalgamation-3080900$ ls -l total 11856 -rw-r--r--@ 1 ron staff 147581 Apr 8 17:38 shell.c -rw-r--r--@ 1 ron staff 5507061 Apr 8 17:38 sqlite3.c -rw-r--r--@ 1 ron staff

[sqlite] Getting a crash on 32-bit Linux

On 4/14/15 18:13, Dan Kennedy wrote: > On 04/14/2015 10:00 PM, Ron Aaron wrote: >> Just updated with the version from sqlite.org and have the same problem: > > The line numbers still don't match the 3.8.9 amalgamation on the > website. Are you running [make sqlite3.c] yours

[sqlite] Getting a crash on 32-bit Linux

Just updated with the version from sqlite.org and have the same problem: #0 findInodeInfo (pFile=0x9434118, ppInode=0x9434120) at sqlite3.c:26091 #1 0x085d3234 in fillInUnixFile (pVfs=0x89422b0 , h=5, pId=0x9434118, zFilename=0x9434208 "/home/ron/proj/8th/test.db", c

[sqlite] Getting a crash on 32-bit Linux

I'm using the one from fossil... On 4/14/15 17:12, Richard Hipp wrote: > On 4/14/15, Ron Aaron wrote: >> I just updated to the 3.8.9 version of SQLite for my project, and am >> compiling for 32-bit linux (on a 64-bit box). >> >> >> I'm getting a

[sqlite] Getting a crash on 32-bit Linux

in fillInUnixFile (pVfs=0x89422b0 , h=5, pId=0x9438118, zFilename=0x9438208 "/home/ron/proj/8th/test.db", ctrlFlags=0) at sqlite3.c:30092 #2 0x084fa69e in unixOpen (pVfs=0x89422b0 , zPath=0x9438208 "/home/ron/proj/8th/test.db", pFile=0x9438118, flags=262,

Re: [sqlite] Stored Procedure or Functions

Actually in any scripting language that has a binding to sqlite it's trival to make a table that contains scripts (stored procedures), and then execute them by selecting the script out of the table etc. I have done this with Tcl. I can't imagine any other scripting language that can run a string

[sqlite] Auto Reply: sqlite-users Digest, Vol 38, Issue 24

I am on vacation and will not be checking my email until March 2. If you have an urgent issue please contact Ashok Joshi. Ron Cohen ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Optimizing Songbird

Count() might still have to visit each row because there might also be a where clause. select count(toys) in toybox where wheels=4; (pardon rusty SQL plz) On Mon, Aug 2, 2010 at 1:37 PM, Scott Hess wrote: > On Mon, Aug 2, 2010 at 11:11 AM, Simon Slavin

Re: [sqlite] Having trouble with "Update"

> > On Wed, Feb 3, 2010 at 5:20 PM, Ron Hudson <hudson...@gmail.com> wrote: > >> Pavel Ivanov wrote: >> >>> String constants should be enclosed in single quotes. Double quotes >>> are for identifiers. So in your case you make perfectly legal no-o

[sqlite] Having trouble with "Update"

I am using the latest version of sqlite3.exe (version 3.6.22) Running Windows Vista. The sqlite3 executable and the database file are in a subdirectory of my Documents directory (where I know rights are not a problem) In the table named "check", I am trying to update the value in a field

Re: [sqlite] sqlite in-memory database far too slow in my use case

gt;> run different versions of it in the wild. I was hoping to make it >> more dynamic and adaptive to database layout changes. > > Sorry, Ron, but I don't get it. You're saying that adding more columns > means adding more fields into your structure and making your > application to

Re: [sqlite] sqlite in-memory database far too slow in my use case

P Kishor schreef: > On Sun, Oct 18, 2009 at 10:37 AM, Ron Arts <r...@arts-betel.org> wrote: >> Very true Simon, >> >> this has been the fastest way so far and I can do around >> 35 selects/second this way, using prepared statements >> (on my m

Re: [sqlite] sqlite in-memory database far too slow in my use case

into the internal memory structures to gets my record from there. thanks, Ron Simon Slavin schreef: > On 18 Oct 2009, at 8:37am, Ron Arts wrote: > >> Is there a way to bypass the virtual machine altogether and reach >> directly >> into the btree and just retrieve one record by it's o

Re: [sqlite] sqlite in-memory database far too slow in my use case

es from clients occasionally. My application needs to scale beyond tens of thousand of clients, and should also communicatie with similar apps running on other machines for high availability and geographical separation. Thanks, Ron ___ sqlite-users

[sqlite] reach into a memory database and retrieve a record by it's oid

or should I try to reach out into btree directly and parse the data directly? I need to speed up record retrieval from a in-memory database, and I know beforehand that 99% of my queries involve retrieving one record by primary integer key. Thanks, Ron Arts

Re: [sqlite] sqlite in-memory database far too slow in my use case (new benchmark inside)

Are there compile time switches which I can use to speed up selects in memory databases? Will the amalgamated version be faster than linking the lib at runtime? Thanks, Ron Pavel Ivanov schreef: >> I use the following queries: >> >> CREATE TABLE company(id INTEGER PRI

Re: [sqlite] sqlite in-memory database far too slow in my use case (new benchmark inside)

ly from > other processes you can place all your inserts in one transaction or > in case of your real application just start transaction at the > beginning and commit/rollback it at the end. > > Tell us if it still doesn't satisfy you. > Pavel, does the cache work for memory datsbase

Re: [sqlite] sqlite in-memory database far too slow in my use case (new benchmark inside)

Alexey Pechnikov schreef: > Hello! > > On Sunday 11 October 2009 12:04:37 Ron Arts wrote: >>CREATE TABLE company(id INTEGER PRIMARY KEY ASC, name) >> >> Then I insert 50 records like this: >> >>INSERT INTO company (id, na

Re: [sqlite] sqlite in-memory database far too slow in my use case (new benchmark inside)

Olaf Schmidt schreef: > "Ron Arts" <r...@arts-betel.org> schrieb im > Newsbeitrag news:4ad10a9e.3040...@arts-betel.org... > >> Here's my new benchmark output: >> >> sqlite3 insert 50 records time: 17.19 secs >> sqlite3 select 50 records t

Re: [sqlite] sqlite in-memory database far too slow in my use case

Jay A. Kreibich schreef: > On Sat, Oct 10, 2009 at 07:24:33PM +0200, Ron Arts scratched on the wall: > >> I'm afraid the process of >> constructing SQL queries / parsing them by sqlite, and >> interpreting the results in my app, multiple times per >> event will be

Re: [sqlite] sqlite in-memory database far too slow in my use case

a hashed index on an existing sqlite memory table this way? Thanks, Ron PS: I *am* impressed by sqlite's speed. Simon Slavin schreef: > On 10 Oct 2009, at 7:04pm, Roger Binns wrote: > >> Ron Arts wrote: >>> So I am wondering if I can drop the glib Hash Tables, and >>>

[sqlite] sqlite in-memory database far too slow in my use case

and tips, Ron ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] error: sqlite doesn't free mutexes on windows

cheShutdown() and sqlite3_os_end() do not > decrement var winMutex_lock > so when sqlite3MutexEnd() is called the var winMutex is still == 3, and > mutexes are not destroyed Did you ever resolve this? Ron Wilson, Engineering Project Lead (o) 434.455.6453, (m) 434.851.1612, w

Re: [sqlite] translating CSV file into sqlite3 database for iPhone?

> This is why I generally advocate TAB delimited files over CSV How does .mode tabs cope with quoted strings with tabs or newlines in them? RW Ron Wilson, Engineering Project Lead (o) 434.455.6453, (m) 434.851.1612, www.harris.com HARRIS CORPORATION | RF Communications Divis

Re: [sqlite] translating CSV file into sqlite3 database for iPhone?

you have quoted strings in your csv that have commas or newlines in them, the import will do surprising things. I had to write my own code to do imports with quoted strings. RW Ron Wilson, Engineering Project Lead (o) 434.455.6453, (m) 434.851.1612, www.harris.com HARRIS CORPORATION | RF

Re: [sqlite] Installing SQLite

ut I'm 99% sure this will not meet the OP's expectations either. Also, I for one would appreciate it if in the future you avoid making the sweeping generalization that "Winduhs" users are dummies or lemmings. I'm sure others would agree. RW Ron Wilson, Engineering Project Lead (o) 434.4

Re: [sqlite] Lemon parser : compile error when using "%token_destructor" directive

W P.S. I like what I see in the revision history. Ron Wilson, Engineering Project Lead, 434.455.6453 HARRIS CORPORATION | RF Communications Division assuredcommunications(tm) -Original Message- From: Vincent Zweije [mailto:vzwe...@wcc-group.com] Sent: Monday, June 15, 200

Re: [sqlite] Lemon parser : compile error when using "%token_destructor" directive

It has been a while since I used lemon (big fan though). Did you resolve this issue or do you still need help? RW Ron Wilson, Engineering Project Lead, 434.455.6453 HARRIS CORPORATION | RF Communications Division assuredcommunications(tm) -Original Message- From: sqlite

Re: [sqlite] sqlite database to xml converter??

Cruel. Just cruel. RW Ron Wilson, Engineering Project Lead, Tyco Electronics, 434.455.6453 -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Vinnie Sent: Friday, April 17, 2009 8:49 AM To: sqlite-users@sqlite.org Subject

Re: [sqlite] Newbie: Further reading / books recommendations

a kindle, but it is interesting to see such technical books available. How many times have you traveled to a customer's site and thought, "Now if I only had my ABC reference?" I wonder if I could get my boss to buy me a kindle. RW Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 43

Re: [sqlite] minor config bug sqlite-amalgamation-3.6.11.tar.gz

Ah yesss. My apologies. Please don't bill me. Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453 -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of D. Richard Hipp Sent: Wednesday, March 18, 2009 1:32 PM

Re: [sqlite] minor config bug sqlite-amalgamation-3.6.11.tar.gz

. march 18. Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453 -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of D. Richard Hipp Sent: Wednesday, March 18, 2009 11:59 AM To: General Discussion of SQLite Database

Re: [sqlite] WHERE clause doesn't seem to work right

See section 3.0 http://www.sqlite.org/datatypes.html Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453 -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Fitter Man Sent: Friday, March 13, 2009 11:10 AM

Re: [sqlite] drop table question ?

Sorry for the redundant reply. It looks like it was already answered. RW Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453 -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Wilson, Ron P Sent: Tuesday

Re: [sqlite] drop table question ?

You will have to do this with code. select name from sqlite_master where name like 'x%'; that will give you a list of all tables that start with x; you can then delete all tables with names in the result set. RW Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453

Re: [sqlite] Index keywords

If you click the link for 'create table' on the page below, you get here: http://www.sqlite.org/lang_createtable.html Most of the constraint keywords are explained briefly there. RW Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453 -Original Message- From: sqlite

Re: [sqlite] howto setup SQLite with Powershell ?

elsewhere because this is neither the powershell list nor the System.Data.SQLite list, but please stick around if only to give the answer once you figure it out. RW Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

Re: [sqlite] SQLite syntax diagrams

I love the diagrams. They are much easier to read (for me) than plain text. To make them searchable, perhaps alt-text would suffice? RW Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf

Re: [sqlite] Reducing SQLite Memory footprint(!)

uruOMeter where name="Ron Wilson"; 2 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brown, Daniel Sent: Friday, August 22, 2008 1:59 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Reducing SQLite Memory footprint(!) I jus

Re: [sqlite] .import with .separator and quoted strings

Hmm. Ok I'll think about munging the data. If I find some time perhaps I'll submit some code to support quoted values in the sqlite3 command line tool. RW Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

Re: [sqlite] .import with .separator and quoted strings

Here is an easy way to reproduce the symptom. Given the following file as input for the .import command: ---csvtest.csv--- "1","wilson, ron" "2","momma, your" - Here is the sqlite output: SQLite version 3.5.9 Enter ".help" for i

[sqlite] .import with .separator and quoted strings

sqlite>select level from sqlGuruOMeter where name="Ron Wilson"; 2 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Proposed removal of (mis-)feature

+1 for removal of quote munging. RW Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453 sqlite>select level from sqlGuruOMeter where name="Ron Wilson"; 2 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of D. Richard Hipp S

Re: [sqlite] bug with NULL in NOT IN

Ah. Thanks for the clarification. It seems to me that using NULL as 'anything' or 'unknown' - it becomes a wildcard of sorts and could create a lot of confusion in queries. note to self : use NULL with extreme caution. Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453

Re: [sqlite] bug with NULL in NOT IN

his explains the result, but logically doesn't follow because in fact NULL does exist in both tables. Interesting. RW Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of D. Richard Hipp Sent:

Re: [sqlite] SQlite and C works with "like" but not with "="

Also, don't forget trailing white space, e.g. "Hexion " != "Hexion". RW Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Igor Tandetnik Sent: Saturday, June 14, 2008

Re: [sqlite] graph question

sqlite>select level from sqlGuruOMeter where name="Ron Wilson"; 2 Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wilson, Ron P Sent: Monday, June 09, 2008 1:49 P

Re: [sqlite] graph question

Wicked. Thanks David and Dennis! And this works like a charm for all parents: select f || ' ' || group_concat(t, ' ') from w group by f; This pushes me up to a '2' on the SQL Guru Meter. RW SQLGuru-O-Meter |0-+--510| Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453

Re: [sqlite] graph question

Yes. I have been lurking here long enough to hear that response 100x - and it is a fair answer. Thanks! RW Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Igor Tandetnik Sent: Monday

[sqlite] graph question

where f=1; 2 3 4 5 6 7 I would like the output to look like this: 1 2 3 4 5 6 7 i.e. parent child1 child2 ... childN is there any way to do that with sql or should I just do it in my program? RW --Tyco Electronics-- Ron Wilson, S/W Systems Engineer III 434.455.6453

Re: [sqlite] How to speed up my queries?

PS. Also, I am not sure about the BETWEEN command - does it use indices? If not you could write the query without BETWEEN. RW Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Christophe

Re: [sqlite] How to speed up my queries?

00 38IfZero 1 40000 RW Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Christophe Leske Sent: Tuesday, June 03, 2008 1:56 PM To: General

Re: [sqlite] How to speed up my queries?

Hi Christophe, 1. Please give us an example query. SELECT * FROM Cities where LONGITUDE_DDS=? AND LATITUDE_DDS=? 2. Paste in the EXPLAIN results from the command line tool. 3. Is the database file local or are you accessing it over a network? RW Ron Wilson, S/W Systems Engineer III, Tyco

Re: [sqlite] transaction recovery question

Welcome to the list! First - some sample code or queries would be helpful. Second - start a new topic (http://en.wikipedia.org/wiki/Thread_hijacking). RW Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

Re: [sqlite] a suggestion to write tutorial for sqlite

the same thing a lot easier with the v2 methods." "The v2 methods?" "Yeah." "But this is SQlite3. Why would I use v2 methods?" http://www.sqlite.org/quickstart.html Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453 ___

Re: [sqlite] Use of two columns for a key and query on first clm.

order by id is not guaranteed. use 'order by id' and it will. Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Neville Franks Sent: Thursday, March 20, 2008 8:07 PM To: sqlite-users

Re: [sqlite] SQL Blobs - what am i doing wrong here?(code inside)

300 0400 0500 0600 0700 0800 0900 *** RW Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of C S Sent: Wednesday, March 12, 2008 12:07 PM To: Gene

Re: [sqlite] SQL Blobs - what am i doing wrong here?(code inside)

spaces added for clarification: 1| 0100 0200 0300 0400 0500 0600 0700 0800 0900 Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of C S Sent: Wednesday, March 12, 2008 10:48 AM

Re: [sqlite] SQL Blobs - what am i doing wrong here?(code inside)

void *blob = reinterpretcast(imageArray); void *blob = reinterpretcast(imageArray); Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of C S Sent: Wednesday, March 12, 2008 9:37 AM

Re: [sqlite] Unrecognized "Z" UTC time zone signifier

). Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ralf Junker Sent: Friday, February 22, 2008 9:09 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Unrecognized "Z" UTC

RE: [sqlite] Re: "Can't we all just get along?" [Was: Re: "always-trim" -feature suggestion]]

erson, hate their opinion." Ron Wilson, Senior Engineer, MPR Associates, 518.831.7546 -Original Message- From: Aristotle Pagaltzis [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 09, 2008 2:37 PM To: sqlite-users@sqlite.org Subject: [sqlite] Re: "Can't we all just get along

RE: [sqlite] no mention of SQLite :(

hehe - check it out. first comment: why no mention sqlite? second comment: because its a trade magazine; consider their income source. third comment: thanks for name dropping SQL Anywhere in your article; it beats sliced bread on mondays. it couldn't be more perfect. Ron Wilson, Senior

RE: [sqlite] Date Problems

> I could accept 28 Feb or 1 Mar as a > reasonable answer and I can make that point to my users. 365/12 = 30.4 2006/03/31 - 30 days = 2006/03/01 just subtract 30 days and be done with it. i think you can justify that to your customers. Ron Wilson, Senior Engineer, MPR Associates, 518.83

  1   2   >