, 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 h
key (which 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 2
You may or may not find this Adobe Lightroom thread helpful
(it winds up discussing critical sections and thread proliferation
-- which are not a SQLite issues):
https://forums.adobe.com/thread/1229203?tstart=0
Jim Callahan
On Wed, Apr 1, 2015 at 3:21 PM, Simon Slavin wrote:
> We can o
shape.html
Hope this helps,
Jim Callahan
Orlando, FL
On Tue, Apr 7, 2015 at 9:58 AM, Drago, William @ CSG - NARDA-MITEQ <
William.Drago at l-3com.com> wrote:
> Igor,
>
> Your solution works well. What I can't figure out is how to efficiently
> create a column representing V
ormation hiding" tactic
analogous to putting a complex calculation in a subroutine.
Jim Callahan
Orlando, FL
On Wed, Apr 8, 2015 at 1:36 AM, Drago, William @ CSG - NARDA-MITEQ <
William.Drago at l-3com.com> wrote:
> Jim,
>
> This works quite well. Thank you.
>
"temp" or "tmp" namespace available
for intermediate tables -- it was on my todo list, but I never got around
to exploring that option.
Jim Callahan
Orlando, FL
On Tue, Apr 14, 2015 at 5:40 AM, Jonathan Moules wrote:
> Hi List,
> I'm wondering if anyone can offe
Can you turn off logging and overwrite the database with unencrypted zeros
or nulls;
just before deleting it?
Encrypting the overwrite character(s) would give the encryption attacker a
cleartext -- a bad move right out of the "Imitation Game".
Jim
On Wed, Apr 22, 2015 at 10:34 AM, Simon Slavin
o data validation?
It is not unusual to use data bases to store pairs of numbers, for example
GIS programs use databases to store latitude and longitude pairs in
separate columns.
So, what specific problems would be created by a REAL column and an
IMAGINARY column?
Jim Callahan
Orlando, FL
On Fri,
y1' AND X = 0 AND Y = 0 AND Z = 0; -- 3D, zero based
array
Thanks to Keith, he was on the right track.
Warning, my capitalization and names may be inconsistent and my SQL might
be pseudocode, but the intent is create the structures to support the final
two queries.
Hope this helps.
Jim Callahan
O
Does the data from the network analyzer have a datetime stamp?
On Apr 25, 2015 3:45 PM, "Drago, William @ CSG - NARDA-MITEQ" <
William.Drago at l-3com.com> wrote:
> > -Original Message-
> > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-
> > users-bounces at
The original thread asking about an array of complex numbers has been
marked as "solved." The requester has decided to serialize the complex
numbers and store them in a blob. Earlier, Keith had suggested storing
complex numbers as a pair of real numbers and a separate box table. I
extended Keith's
-version.war to tomcat_home/webapps/
folder.
#5: Get the sqlite jdbc driver: sqlite-jdbc-version.jar; deploy to
tomcat_home/webapps/mondrian/WEB-INF/lib
#6: Change the connection string in Mondrian web.xml
(tomcat_home/webapps/mondrian/WEB-INF) to point to the sqlite database."
Almost make
http://jtc1sc32.org/doc/N2501-2550/32N2528-WG3-Tutorial-Opening-Plenary.pdf
So, Multi-dimensional arrays may be coming to SQL via the ISO Standard 9075
and to SQLite3 via Rasdaman, but only if, Rasdaman decides to use SQLite3
as their default backend in their 10.0.0 release.
Jim Callahan
Orlan
to SQL via the ISO Standard 9075
and to SQLite3 via Rasdaman, but only if, Rasdaman decides to use SQLite3
as their default backend in their 10.0.0 release.
Jim Callahan
Orlando, FL
On Mon, Apr 27, 2015 at 12:33 PM, Jim Callahan <
jim.callahan.orlando at gmail.com> wrote:
> Two more
ld be an
extremely small subset of data base users (less than 5%? or even less than
1%?).
Jim Callahan
Orlando, FL
On Mon, Apr 27, 2015 at 12:48 PM, Drago, William @ CSG - NARDA-MITEQ <
William.Drago at l-3com.com> wrote:
> All,
>
> I've been enjoying this discussion and have lea
Copying the file to another computer would likely work; except if the
application encrypted the data.
Jim
On Sun, Dec 6, 2015 at 5:22 PM, Simon Slavin wrote:
> If you cannot run any program apart from the ones already installed then
> your only option is to copy the database file to another
I would mention the open source statistical language R in the "data
analysis" section. The interface in the RSqlite package is much better and
faster than any of the Python interfaces in that the interface fully
understands queries as tables and that the looping for the return of rows
is done in
views" (pages or blogs) showing how packages solve
common problems in a variety of academic disciplines or application areas.
Jim Callahan
On Feb 19, 2015 11:38 AM, "Gabor Grothendieck"
wrote:
> On Wed, Feb 18, 2015 at 9:53 AM, Richard Hipp wrote:
> > On 2/18/15
eth
Falcon.
http://master.bioconductor.org/help/course-materials/2006/rforbioinformatics/labs/thurs/SQLite-R-howto.pdf
Jim
On Thu, Feb 19, 2015 at 2:08 PM, Jim Callahan <
jim.callahan.orlando at gmail.com> wrote:
> Strongly agree with using the R package Sqldf.
> I used both RSQLite
their ancestor BP terms, based on the directed acyclic graph (DAG) defined
by the Gene Ontology Consortium."
DAG, SQLite, R, Biological Processes and Gene Ontology in one paragraph;
oh, my head hurts, I think I'll stick to simpler stuff.
Jim
On Wed, Feb 25, 2015 at 3:13 PM, Jim Cal
Books that discuss BOTH R and SQL are a very small subset and assume some
knowledge of both.
R INTRODUCTORY BOOKS
1. Peter Dalgaard, "Introductory Statistics with R", 2002.
"The book is based upon a set of notes developed for the course in Basic
Statistics for Health Researchers at the Faculty of
ttp://www.postgresql.org/docs/9.1/static/functions-comparison.html
I had used Microsoft Access, so I was used to the "IS NOT NULL" syntax and
had to learn "NOTNULL".
It is not the end of the world, but it could be a gotcha.
Other than that one exception, whenever I have gotten the
S
concepts) at the SQL level.
Jim Callahan
Orlando, FL
On Sun, Jul 5, 2015 at 4:46 PM, John McKown
wrote:
> On Sun, Jul 5, 2015 at 7:44 AM, wrote:
>
> > Is there a way (free, open source, Ubuntu) to convert a
> > PostgreSQL-database with data in it to a sqlite databas
t/torvalds/linux.git
https://www.kernel.org/pub/software/scm/git/docs/user-manual.html#how-to-get-a-git-repository
Hope this helps.
Jim Callahan
Orlando, FL
On Mon, Jul 13, 2015 at 5:52 AM, Shuhrat Rahimov
wrote:
> Hello,
> I was trying to run SQLite on ARM Cortex M4 CPU. What I need is a
Here is a link to a more recent (2013) discussion with a more recent
(3.x.xx vs 2.x.xx) version of SQLite:
http://comments.gmane.org/gmane.comp.db.sqlite.general/83038
Jim
On Mon, Jul 13, 2015 at 11:22 AM, Jim Callahan <
jim.callahan.orlando at gmail.com> wrote:
> SQLite expects a fi
on Linux) or Windows (based on Windows) or Ubuntu (a Linux
distribution) and most of these already have SQLite.
Jim
On Mon, Jul 13, 2015 at 11:52 AM, Richard Hipp wrote:
> On 7/13/15, Jim Callahan wrote:
> > SQLite expects a file system.
> >
>
> Not necessarily. Out-of-the
ntains the
string "CHAR" and is thus assigned TEXT affinity."
These rules allow complex SQL CREATE TABLE statements to be run (for
compatibility) and mapped to the five storage affinities (which keep SQLite
small and fast) used by SQLite.
Jim Callahan
Orlando, FL
On Thu, Jul 1
I Simon's point about idiotic web filters is valid.
"Cnt" is innocuous in formal documentation where by context it clearly
means "count", but think of how people type text messages. If an online
chat board in html had text like messages then a machine learning algorithm
(for a web filter) would
yes, ATTACH and then join using a SELECT statement.
After you do the ATTACH, this video shows how to do the join using the
SQLite command line interface. Notice how you can keep track of identically
named fields in the two tables.
https://www.youtube.com/watch?v=NcrZoHselPk
Jim
On Tue, Jul 21,
Another option is to save the Excel file as tab separated values. Using
tabs as delimiters avoids some of the comma issues.
Jim
On Jul 30, 2015 6:07 PM, "R.Smith" wrote:
>
>
> On 2015-07-30 11:12 PM, Sylvain Pointeau wrote:
>
>> Le jeudi 30 juillet 2015, Simon Slavin a ?crit :
>>
>> Yes, as I
rking
join query that has the struture you want you have a choice of using the
SELECT...JOIN query as if it was table or converting the query to a table
with a CREATE TABLE FROM SELECT ...JOIN query.
Jim Callahan
Orlando, FL
On Sat, Mar 7, 2015 at 8:18 PM, Darren Duncan
wrote:
> On 2015-03-07
Not personally familiar with Russian translation issue, but thanks for the
English language spell check should use "You" instead of "Your" in cited
sentences.
Jim Callahan
Orlando, FL
On Mon, Mar 16, 2015 at 5:19 PM, O.Zolotov wrote:
> Dear All,
> the FAQ's item
Library fork)
https://github.com/oysteinkrog/SQLite.Net-PCL
Jim Callahan
On Thu, Apr 30, 2015 at 11:24 PM, Richard Hipp wrote:
> https://twitter.com/john_lam/status/593837681945092096
>
> --
> D. Richard Hipp
> drh at sqlite.org
>
ich builds a spatial database (ie.
for GIS) on top of SQLite and it has its own GUI:
Spatialite GUI
https://www.gaia-gis.it/fossil/spatialite_gui/index
There are probably many, many more, but this is a start.
Jim Callahan
Orlando, FL
On Sun, May 3, 2015 at 11:28 AM, Gerald Bauer
wrote:
> Hell
://github.com/ggrothendieck/sqldf
As I understand there are interfaces from a variety of other languages
including Python and PHP.
Jim Callahan
Orlando, FL
On Mon, May 4, 2015 at 8:55 AM, Gerald Bauer wrote:
> Hello,
> Thanks I've updated the awesome-sqlite list [1] and now includes a
/en/docs/user_manual/working_with_projections/working_with_projections.html
For more information on the Spatialite family of projects:
http://www.gaia-gis.it/gaia-sins/
Jim Callahan
Orlando, FL
On Wed, Feb 18, 2015 at 9:34 AM, Richard Hipp wrote:
> In a feeble effort to do "marketing", I hav
he imputed values than is warranted. 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:2
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,
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 SQL
rationalError: (Operational 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 Cal
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
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
> > invol
escribed in Sasha Issenberg's book, "The Victory Lab" and any new
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,
date. Wes has two
sections on time zones:
pages 18-26 where he downloads a usgov_bitly dataset and analyzes 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, 2
limit 3'): print
row
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
homebrew parser.
http://rogerbinns.github.io/apsw/cursor.html#cursor-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
rge 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 y
t's millions of rows (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 splittin
one apps, 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 Ni
Pocket calculators and COBOL used binary coded decimal (bcd) numbers to
avoid the representation/round off issues. But this meant another entire
number type (supported with addition, subtraction and having to be type
checked in functions) in addition to integer and floating point; most found
it
SQL is a storage and retrieval engine with limited calculation abilities in
support of storage, retrieval and reporting.
You can store numbers as integers, text or floating point and the calling
language can use whatever subroutines to translate and manipulate the
numbers.
If the calling
sanam
If renaming the file does not work; then use whatever package that can read
the file to read it in and write it back out as a comma or tab delimited
file.
In the SQLite command line interface (CLI, implemented as SQLite3.exe) one
can:
"Use the ".import" command to import CSV (comma
Might want to split bookings into a transaction table and a reservation
table.
The reservation table would have one column for each room and one row for
each calendar day (assuming this is a respectable joint with no hourly
reservations!).
Reservation table has primary key of date and room
benchmark
available on this page, but now that you understand the use cases, this
particular benchmark is not that useful in addition
to being out of date and unfair.
https://www.sqlite.org/speed.html
Jim Callahan
Data Scientist
https://www.linkedin.com/in/jamesbcallahan
Orlando, FL
On Mon, Feb 15
ks).
"Show me your flowcharts and conceal your tables, and I shall continue to
be mystified. Show me your tables, and I won?t usually need your
flowcharts; they?ll be obvious."
Fredrick Brooks, Mythical Man-Machine Month, page p. 102-3
https://en.wikiquote.org/wiki/Fred_Brooks
Jim Call
Are you using any SQL VIEWs?
"You cannot DELETE, INSERT, or UPDATE a view.
Views are read-only in SQLite."
http://sqlite.org/lang_createview.html
Jim
On Mon, Feb 29, 2016 at 10:31 PM, Vince Scafaria wrote:
> Richard, I can confirm that having a writable connection open first, prior
> to trying
ice.
Just a wishlist idea. No rush for me because I am happy in R and will
probably be moving from SQLite to client server SQL database before I move
from R to Python, Julia or Java.
Jim Callahan
Orlando, FL
<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_co
h attribution from Zentus)
https://github.com/crawshaw/sqlitejdbc
I am hopeful this new JDBC based interface will provide as satisfactory
high level channel between SQLite3 and Python.
Jim Callahan
On Thu, Jan 7, 2016 at 7:55 PM, Warren Young wrote:
> On Jan 7, 2016, at 5:22 PM, Jim Callahan
&
> the century? I prefer the oldfashoned yymmdd.
> The advantage of the four-digit year is that it can be used for sorting
> over a wide range.
Let's not create a Y2100 problem; right after fixing Y2K! ;)
a problem with the
JDBC/ODBC specs, the implementations or is the entire technical approach
beyond redemption?
Jim Callahan
Orlando, FL
<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail>
This
email has been sent from a vir
Is 4096 bytes a large enough page size?
Apparently the disk drive industry has shifted from 512 byte sectors to
4096 byte sectors.
http://tilt.lib.tsinghua.edu.cn/docs/tech/tp613_transition_to_4k_sectors.pdf
Should SQLite maintain a 1:1 ratio between page size and sector size?
or should the page
??
> From: Domingo Alvarez Duarte
> I have a question, is it enough to vacuum a database to update to the new
> page size ?
>
Apparently all you need to is "pragma page_size=4096; vacuum;" using the
> appropriate page size.
> This makes very easy to convert any(all) database(s) with a single
>
nitialized variables are allowed and memory is not automatically set
to zero the program will have non-deterministic run-time behavior because
of the random clutter in memory.
Jim Callahan
<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail_t
ft has purchased Revolution Analytics and is now
supporting a version of R.
https://mran.revolutionanalytics.com/open/
Jim Callahan
Orlando, FL
On Fri, Mar 25, 2016 at 7:49 AM, Don V Nielsen
wrote:
> I have a need for something that can parse and load into sqlite tables
> fixed length
er science textbooks give elegant examples using
recursion,
but then say the solution is not scale-able and give a less elegant
solution using iterative techniques.
Jim Callahan
Data Scientist
Orlando, FL
On Tue, Aug 9, 2016 at 10:31 AM, Rousselot, Richard A <
richard.a.rousse...@centurylink.com> w
TE
TABLE)
If "Step 1 Simple Load" does not complete; then may want to load a fixed
number of rows into separate tables (per Darren Duncan) and then combine
using an APPEND
or a UNION query (doing so before steps 2 and 3).
HTH
Jim Callahan
Data Scientist
Orlando, FL
On Wed, A
s/15326455/what-is-the-default-database-location-of-an-android-app-for-an-unrooted-device
September 9, 2013
http://stackoverflow.com/questions/18905804/where-is-my-sqlite-database-stored-in-android
<http://stackoverflow.com/questions/18905804/where-is-my-sqlite-database-stored-in-android&g
ository/tz-link.html
Some best practices
https://www.w3.org/TR/timezone/
But, as Einstein said, it's all relative.
Jim Callahan
Orlando, FL
On Tue, Jan 10, 2017 at 10:01 AM, Jeffrey Mattox <j...@mac.com> wrote:
> My application will be counting events and saving the totals fo
SAME FIELDS you can merge tables using
the procedure described in this StackOverflow answer.
Pay attention, however, the difference between UNION and UNION ALL
http://stackoverflow.com/questions/30292367/sqlite-append-two-tables-from-two-databases-that-have-the-exact-same-schema
Jim Callahan
Orlando, FL
com/en-us/commandline/wsl/about
Thus, at some point, Linux, OS/X and Windows will all support Bash scripts.
For now, there are non-native emulators MinGW/MSys and Cygwin to provide
Bash on Windows.
MinGW/MSys
http://www.mingw.org/wiki/msys
Cygwin
http://www.mingw.org/node/21
Jim Callahan
Orlando, FL
http://sqlite.1065341.n5.nabble.com/How-accept-sqlite3-commands-from-stdin-td38710.html
Jim Callahan
Orlando, FL
On Wed, Jan 11, 2017 at 4:23 PM, Roman Fleysher <
roman.fleys...@einstein.yu.edu> wrote:
> Dear SQLites,
>
> I am using exclusively sqlite3 shell for all the pr
rching) is:
https://www.bizapedia.com/fl/coral-creek-software.html
Jim Callahan
Orlando, FL
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
an additional license."
http://www.sqliteexpert.com/support.html
I am not affiliated with Coral Creek Software and the only information I
could find out about the company as opposed to the product (in less than 2
minutes of Google searching) is:
https://www.bizapedia.com/fl/coral-creek-software.html
Jim
social.msdn.microsoft.com/Forums/en-US/7f38ee7b-15e2-4e2c-8389-1266f496e4b2/regular-expression-to-get-date-format-from-string?forum=csharplanguage
Jim Callahan
On Tue, Apr 11, 2017 at 10:00 PM, Ron Barnes <rbar...@njdevils.net> wrote:
> Hi Jim,
>
> I could alter the program th
counts; so you may need Julian
dates after all.
Jim Callahan
Orlando, FL
On Tue, Apr 11, 2017 at 7:24 PM, Ron Barnes <rbar...@njdevils.net> wrote:
> Hello all,
>
> To everyone who helped me before - thank you very much!
>
> I'm coding in Visual Basic .NET (Visual Studio 201
Per Keith Medcalf's comment on the ancient master file merge,
I found this inscription concerning batch processing in the elephant's
graveyard:
https://www.ibm.com/support/knowledgecenter/zosbasics/com.ibm.zos.zconcepts/zconc_batchscen2.htm
Jim Callahan
On Wed, May 9, 2018 at 10:06 AM, Keith
2:2 or 1:3).
Jim Callahan
Orlando, FL
On Mon, May 28, 2018 at 5:35 AM, Rowan Worth <row...@dug.com> wrote:
> On 28 May 2018 at 17:29, x <tam118...@hotmail.com> wrote:
>
> > I’ve just discovered the thread in the original app decreases the
> > available memor
be handled at the application level above the
SQL core (which only
handles "ACID consistency").
HTH
Jim Callahan
Callahan Data Science LLC
Orlando, FL
On Fri, Aug 3, 2018 at 5:41 AM, Hick Gunter wrote:
> This is what I think you are asking:
>
> - You have a "m
be that the space after the number, plus certain locales
would reproduce the issue.
Jim Callahan
Callahan Data Science LLC
Orlando, FL
On Tue, Jan 23, 2018 at 10:22 AM, Ralf Junker <ralfjun...@gmx.de> wrote:
> On 23.01.2018 15:31, Richard Hipp wrote:
>
> I'm still unable to reprod
and append
(">" and ">>").
Jim Callahan
Callahan Data Science LLC
Orlando, FL
<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail_term=icon>
Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email_
80 matches
Mail list logo
