by definition in SQLITE3
autoincrements) one might be able to get an approximate row count faster
using the:
sqlite3_last_insert_rowid()
function.
Jim Callahan
Orlando, FL
On Dec 13, 2014 10:17 AM, Simon Slavin slav...@bigfraud.org wrote:
On 13 Dec 2014, at 12:38pm, Richard Hipp d...@sqlite.org wrote
, is there a (unique) ID number for the person (a
primary key)? If there is an ID number you can query for that specific
number.
On the other hand if they want all the Fred Smiths; do they want
Frederick Smith or Fredrica Smith or some named Theodore Fredrick Smith,
but goes by Fred?
Hope this helps,
Jim Callahan
, SQLite is probably
already there in Android, ios or mono.
If you are developing scientific applications you might use the R
statistical language, Python or the new language Julia.
It really depends on what you are tying to do.
Jim Callahan
On Wed, Sep 10, 2014 at 4:56 PM, Maxine Nietz nevada
(in
the main 150 column table) where the precompiled SQL query doesn't have to
be executed.
HTH,
Jim Callahan
Orlando, FL
On Wed, Aug 6, 2014 at 11:51 PM, Paul Dillon paul.dil...@gmail.com wrote:
Hello,
I would like to know if splitting a big table into two smaller ones, and
then using
is the system ram?
What percent of the ram is being used?
Jim Callahan
On Wed, Aug 6, 2014 at 3:39 PM, Fabian Giesen fabi...@radgametools.com
wrote:
On 8/6/2014 11:51 AM, Jensen, Vern wrote:
*bump*
Anyone?
Not sure if this is your problem, but this kind of load puts a lot of
stress on SQLite's
-class
BTW, open source, Notepad++, has nice syntax highlighting for Python.
I have an afternoon and evening full of meetings, but I will attempt this
fix myself tomorrow (Tuesday) morning.
Cheers.
Jim Callahan
Orlando, FL
On Sun, Aug 3, 2014 at 11:31 AM, Roger Binns rog...@rogerbinns.com
statistical applications that may be used in the future.
I greatly appreciate the help of this group at this critical juncture. I
was about to abandon the entire Python branch of the project.
Jim Callahan
Orlando, FL
On Fri, Aug 1, 2014 at 6:17 PM, Keith Medcalf kmedc...@dessus.com wrote
the time
zone
and pages 303-306 where he analyzes date stamps and mentions the ptz AND
pandas Python libraries and the Olson database
Jim Callahan
Orlando, FL
On Tue, Jul 29, 2014 at 9:41 AM, Will Fong w...@digitaldev.com wrote:
Hi,
How are timezones best handled? Since dates are stored
It worked, it read the correct data from the SQLite3 SQL VIEW. Thanks!
Jim Callahan
Orlando, FL
On Sat, Aug 2, 2014 at 5:35 AM, Jim Callahan jim.callahan.orla...@gmail.com
wrote:
THANK YOU!!!
On Fri, Aug 1, 2014 at 6:17 PM, Keith Medcalf kmedc...@dessus.com wrote:
Works just fine. The SQL
Error) cannot join column using GenderID -
column is not present in both tables 'SELECT FirstName, LastName FROM
ActiveVoters LIMIT 3'
Why does the Python program know anything about the view? Why isn't table
handling transparent like at the SQLite3 command line?
Thanks,
Jim Callahan
Orlando, FL
On Fri, Aug 1, 2014 at 11:58 AM, Simon Slavin slav...@bigfraud.org wrote:
On 1 Aug 2014, at 4:45pm, Jim Callahan jim.callahan.orla...@gmail.com
wrote:
column is not present in both tables
This is usually the result of using the syntax JOIN table USING column
because SQL requires columns
On Fri, Aug 1, 2014 at 3:41 PM, Simon Slavin slav...@bigfraud.org wrote:
On 1 Aug 2014, at 8:11pm, Jim Callahan jim.callahan.orla...@gmail.com
wrote:
Why does Python get to see the innards of a View; when the query just
involves columns (in a view) that flow straight through from
Would the rtree be useful in a composite primary key and/or ad-hoc
composite query context?
http://www.sqlite.org/rtree.html
If so, how would SQLite know to create and/or use an rtree without explicit
user intervention?
Jim Callahan
But this does point out a possible enhancement to SQLite
How to query and/or group complex SQL?
Add the language to create a SQL VIEW before your SELECT statement:
CREATE VIEW viewname AS SELECT [your SQL]
http://www.sqlite.org/lang_createview.html
Then use the viewname in a second SELECT statement as you would a table.
SELECT order_id, issued,
. The regression
model predicts the most likely value of missing data but does not supply
uncertainty about that value.
There is a lot more in the Wikipedia article, but this seemed like the most
relevant section.
HTH,
Jim Callahan
On Sat, Nov 2, 2013 at 2:23 PM, Igor Tandetnik i...@tandetnik.org wrote
15 matches
Mail list logo