On Sun, Dec 21, 2014 at 4:47 AM, big stone stonebi...@gmail.com wrote:
Hi all,
To prepare for end of 2014 greetings moment, here is my whish list for
2015:
- a minimal subset of analytic functions [1], that I hope may help
end-user/students popularity [2]
- better information on what is
On Wed, Sep 10, 2014 at 8:36 AM, John McKown
john.archie.mck...@gmail.com wrote:
Well, I did a git clone to fetch the LibreOffice source. It appears to
be a mixture of Java, C, and C++. Just some stats:
$find . -name '*.c' | wc
108 1083908
~/source-oem/libreoffice-core$find .
The wording in the cited link is that
Queries of the form: SELECT max(x), y FROM table returns the value
of y on the same row that contains the maximum x value.
There is some question of whether min(x) is of the form max(x).
On Thu, Aug 28, 2014 at 10:28 AM, Clemens Ladisch clem...@ladisch.de
On Thu, Mar 6, 2014 at 6:29 PM, Walter Hurry walterhu...@gmail.com wrote:
Richard Hipp wrote:
On Thu, Mar 6, 2014 at 3:41 PM, Walter Hurry walterhu...@gmail.com wrote:
A small enhancement request:
It would be great if the RPAD and LPAD functions could be implemented in
sqlite.
The
On Thu, Mar 6, 2014 at 8:41 PM, RSmith rsm...@rsweb.co.za wrote:
On 2014/03/07 01:59, Gabor Grothendieck wrote:
A small enhancement request:
It would be great if the RPAD and LPAD functions could be implemented
in
sqlite.
The SQLite you can get the effect of RPAD(x,y) using PRINTF
On Fri, Feb 14, 2014 at 2:33 PM, Max Vlasov max.vla...@gmail.com wrote:
Hi,
Some time ago when there was no instr functions, I looked at Mysql help
pages and implemented a user function locate as the one that allows
searching starting a particular position in the string. With two parameters
On Mon, Feb 10, 2014 at 10:23 AM, Richard Hipp d...@sqlite.org wrote:
The Problem:
Many new users (especially university students taking a database 101
The other features that would make teaching a bit easier would be to support
left join explicitly and support the rfc4180 standard for csv
nice to know that I will have rfc4180
when its upgraded.
On Mon, Feb 10, 2014 at 1:26 PM, Petite Abeille
petite.abei...@gmail.com wrote:
On Feb 10, 2014, at 5:19 PM, Gabor Grothendieck ggrothendi...@gmail.com
wrote:
The other features that would make teaching a bit easier would be to support
On Mon, Feb 10, 2014 at 1:56 PM, Petite Abeille
petite.abei...@gmail.com wrote:
On Feb 10, 2014, at 7:39 PM, Gabor Grothendieck ggrothendi...@gmail.com
wrote:
That should have read right join.
My personal opinion? Anyone even considering using a right outer join should
be cursed
PostgreSQL supports
create index indexname on table ( expression )
Note that it allows an expression and not just a column name.
See:
http://www.postgresql.org/docs/9.1/static/sql-createindex.html
Perhaps indexing the expression in question would be an alternative
that would keep the
Which can also be written as:
select cast(strftime('%m','now') as integer)=6
On Sun, Jun 23, 2013 at 4:11 PM, Patrik Nilsson
nipatriknils...@gmail.com wrote:
You can write:
select cast(strftime('%m',datetime('now')) as integer)=6
1
On 06/23/2013 09:45 PM, Lucas wrote:
Hello,
I am
Or even:
select cast(strftime('%m') as integer)=6
On Sun, Jun 23, 2013 at 4:16 PM, Gabor Grothendieck
ggrothendi...@gmail.com wrote:
Which can also be written as:
select cast(strftime('%m','now') as integer)=6
On Sun, Jun 23, 2013 at 4:11 PM, Patrik Nilsson
nipatriknils...@gmail.com wrote
On Thu, Jan 24, 2013 at 2:21 PM, Richard Hipp d...@sqlite.org wrote:
On Thu, Jan 24, 2013 at 2:01 PM, Jose F. Gimenez jfgime...@wanadoo.eswrote:
Richard,
thanks for replying.
We have no way of testing SQLite on Win9x and so we do not intend to
support Win9x moving forward. Some older
I am still having problems with Igor's gmail messages being marked as
spam in gmail but after the upteenth time declaring them not to be
spam google finally asked me if I wanted to report it to their gmail
team so hopefully they will fix it soon.
On Mon, Dec 3, 2012 at 11:59 PM, Clive Hayward
On Wed, Sep 19, 2012 at 12:51 PM, joe.fis...@tanguaylab.com
joe.fis...@tanguaylab.com wrote:
Too bad SQLite doesn't yet support SQL Window Functions.
Are there any SQLite Extension Libraries that support SQL:2003 type Window
Functions?
I specifically need LEAD and LAG to calculate an event
On Sun, May 6, 2012 at 8:00 PM, Donald Griggs dfgri...@gmail.com wrote:
Regarding: What precisely are the
improvements in handling of CSV inputs?
Gabor, I don't know about precisely -- I'll let others on the list tell
me where I'm off, but here's my take:
A lot of strange things call
In this link:
http://sqlite.org/releaselog/3_7_11.html
it refers to these new features:
Queries of the form: SELECT max(x), y FROM table returns the value
of y on the same row that contains the maximum x value.
Improvements to the handling of CSV inputs in the command-line shell
Is there
On Fri, May 4, 2012 at 10:20 AM, Richard Hipp d...@sqlite.org wrote:
On Fri, May 4, 2012 at 10:06 AM, Rob Richardson
rdrichard...@rad-con.comwrote:
Gabor Grothendieck mentioned a new feature of SQLite in 3.7.11:
Queries of the form: SELECT max(x), y FROM table returns the
value of y
On Fri, May 4, 2012 at 10:46 AM, Gabor Grothendieck
ggrothendi...@gmail.com wrote:
On Fri, May 4, 2012 at 10:39 AM, Richard Hipp d...@sqlite.org wrote:
On Fri, May 4, 2012 at 10:33 AM, Gabor Grothendieck ggrothendi...@gmail.com
wrote:
On Fri, May 4, 2012 at 10:20 AM, Richard Hipp d
On Mon, Apr 30, 2012 at 10:18 AM, Arbol One arbol...@programmer.net wrote:
I am learning SQL using SQLite, can anyone tell me of a good book to learn
SQL using SQLite?
Its a web page and free software, not a book, but you might try this
page to start off and then get a book after you have
On Tue, Apr 10, 2012 at 7:14 PM, Frank Chang frank_chan...@hotmail.com wrote:
Good evening, We are trying to generate automated SQLITE SQL scripts based
on the names of SQLite tables derived by substring manipulation of Windows
DOS batch file and/or Windows environment variables. For
On Sat, Mar 31, 2012 at 2:55 AM, YAN HONG YE yanhong...@mpsa.com wrote:
sqlite3 -html C:\mydatabase\mydzh.db select 'table'mm.html
this command result is not table in the mm.html file, it's this following
text:
TRTDlt;tablegt;/TD
/TR
not I wanted, how to wrie table char in my html file?
On Mon, Mar 26, 2012 at 11:38 PM, YAN HONG YE yanhong...@mpsa.com wrote:
WHEN I export sqlite database to a html file or txt file, I couldn't know how
to include the database table head.
who can tell me?
Thank you!
Use -header like this:
sqlite3 -html -header my.db select * from mytable
On Tue, Mar 27, 2012 at 3:02 PM, Simon turne...@gmail.com wrote:
select closing_price, moving_average( funky_oscillator( closing_price ) )...
There is a moving average calculation in SQLite here but given the
complexity you might prefer to do the analytical portion in your
program:
On Mon, Nov 14, 2011 at 5:32 AM, Simon Slavin slav...@bigfraud.org wrote:
On 14 Nov 2011, at 7:38am, vinayh4 wrote:
I need to create table with more than 2000 columns, How to reset
SQLITE_MAX_COLUMN value which
is 2000 . Plz help me on this issue.
You almost never need to have more
On Mon, Nov 14, 2011 at 12:21 PM, Igor Tandetnik itandet...@mvps.org wrote:
On 11/14/2011 12:11 PM, Gabor Grothendieck wrote:
The requirement for a large number of columns is actually one thing
that is often needed when using sqlite from R. Typically the use case
is that a user wishes
On Mon, Nov 14, 2011 at 12:50 PM, Simon Slavin slav...@bigfraud.org wrote:
On 14 Nov 2011, at 5:11pm, Gabor Grothendieck wrote:
The requirement for a large number of columns is actually one thing
that is often needed when using sqlite from R. Typically the use case
is that a user wishes
In R, the RSQLite driver for SQLite currently has
SQLITE_MAX_VARIABLE_NUMBER set to 999. This is used by many people
for many different projects and on different platforms and it seems
that a number of these projects want a larger number. Users don't
compile this themselves so they are stuck
On Tue, Nov 8, 2011 at 5:55 PM, Simon Slavin slav...@bigfraud.org wrote:
On 8 Nov 2011, at 10:50pm, Gabor Grothendieck wrote:
In R, the RSQLite driver for SQLite currently has
SQLITE_MAX_VARIABLE_NUMBER set to 999. This is used by many people
for many different projects and on different
On Tue, Nov 8, 2011 at 6:46 PM, Richard Hipp d...@sqlite.org wrote:
On Tue, Nov 8, 2011 at 5:50 PM, Gabor Grothendieck
ggrothendi...@gmail.comwrote:
In R, the RSQLite driver for SQLite currently has
SQLITE_MAX_VARIABLE_NUMBER set to 999. This is used by many people
for many different
On Tue, Nov 8, 2011 at 7:11 PM, Richard Hipp d...@sqlite.org wrote:
On Tue, Nov 8, 2011 at 7:08 PM, Gabor Grothendieck
ggrothendi...@gmail.comwrote:
On Tue, Nov 8, 2011 at 6:46 PM, Richard Hipp d...@sqlite.org wrote:
On Tue, Nov 8, 2011 at 5:50 PM, Gabor Grothendieck
ggrothendi
On Tue, Sep 27, 2011 at 2:14 PM, David Garfield
garfi...@irving.iisd.sra.com wrote:
Any entry in a pipe could be buffering. In a quick test here, awk is
buffering. To find the buffering, try using the pieces up to a given
stage with | cat added at the end. If this buffers, you've found
On Mon, Jun 6, 2011 at 11:54 AM, Richard Hipp d...@sqlite.org wrote:
On Mon, Jun 6, 2011 at 11:44 AM, Sidney Cadot sid...@jigsaw.nl wrote:
Would it be useful to open a ticket on this issue, or will it never be
changed e.g. for fear of breaking backward compatibility?
There are approx 2
On Wed, Dec 8, 2010 at 2:44 PM, Richard Hipp d...@sqlite.org wrote:
On Wed, Dec 8, 2010 at 2:35 PM, Petite Abeille
petite.abei...@gmail.comwrote:
Hello,
The pragma foreign_key_list appears to be deprecated in 3.7.4:
http://www.sqlite.org/pragma.html#pragma_foreign_key_list
Any reason
On Fri, Oct 29, 2010 at 12:07 PM, Jonathan Haws
jonathan.h...@sdl.usu.edu wrote:
All,
I am having some problems with a new database that I am trying to setup.
This database is a large file (about 8.7 GB without indexing). The problem
I am having is that SELECT statements are extremely slow.
On Fri, Oct 15, 2010 at 12:54 PM, Graham Smith myotis...@gmail.com wrote:
Tom,
Thanks for this.
My main reason for asking is because I am trying to encourage my
students and indeed clients to think database rather than
spreadsheet. Most of the time these aren't big or complex data sets
On Thu, Oct 7, 2010 at 5:26 PM, sjtirtha sjtir...@gmail.com wrote:
Hi,
I'm interested involving in sqlite development.
How can I start it?
If I can add to this question is there a posted wishlist,
todo list or roadmap?
Something like this:
http://www.h2database.com/html/roadmap.html
--
On Sat, Sep 4, 2010 at 7:31 AM, Mike Zang mikez...@yahoo.co.jp wrote:
I try to convert data to SQLite3 for iPad, please give me some detail
suggestion.
I think that I can save date value as below to SQLite3, I want to know
which is better, or anything else if you have good idea.
1. integer
On Sun, Aug 22, 2010 at 4:51 AM, Mike Zang mikez...@yahoo.co.jp wrote:
I have 5000 files and I want to converrt them to SQLite3 on iPad, now I
have a performance question, I am not sure which way is better for select
and insert data in SQLite3.
I have two ideas for converting.
1. convert 1
You don't need to dump the data to a csv file and then read it into R
and there is no need to use the sqlite3 console at all as R's RSQLite
package can directly read and write SQLite databases. Also see the
sqldf package.
On Tue, May 4, 2010 at 1:02 PM, Matt Young youngsan...@gmail.com wrote:
I
SQLite and R are already integrated through the RSQLite/DBI packages
and even higher level facilities (which I have posted about on this
thread) also exist. I think that such an integration would logically
be done by R people rather than sqlite people.
In the discussion on this thread
On Sat, May 1, 2010 at 12:15 PM, Richard Hipp d...@sqlite.org wrote:
On Sat, May 1, 2010 at 9:25 AM, Tim Romano tim.romano...@gmail.com wrote:
I am aware that SQLite supports
loadable extensions, but would the SQLite architecture also permit the
integration of an interpreted scripting
On Sun, Apr 18, 2010 at 12:02 PM, Wensui Liu liuwen...@gmail.com wrote:
dear listers,
i am wondering if there is a way to submit a file with many sql
statements, say several hundred lines, to sqlite.
thanks for your insight.
C:\tmp2type a.sql
create table tab (a,b);
insert into tab
Not in sqlite itself but stddev_samp and stddev_pop are available in
the spatialite loadable extension.
Be careful since they interchanged sample and population in one
version of the extension.
On Sun, Apr 18, 2010 at 9:37 PM, Peter Haworth p...@mollysrevenge.com wrote:
Does Sqlite have a STDEV
It would be nice if SQLite had a strptime-like function for things
like this and not just strftime.
On Mon, Mar 29, 2010 at 10:13 AM, Griggs, Donald
donald.gri...@allscripts.com wrote:
On 27 Mar 2010, at 10:46am, GeoffW wrote:
Just for educational purposes I have been experimenting a little
On Fri, Mar 26, 2010 at 5:00 AM, Fredrik Karlsson dargo...@gmail.com wrote:
Hi,
I have a list of id:s stored in a field. I would now like to get some
information from a table by these id:s, but exactly in this order. So,
if I have a table
1 One
2 Two
3 Three
and the sequence 3,1,2
46 matches
Mail list logo