Using the _ character to separate words is an informal language standard,
s in: method_do_this...
On Tue, Feb 28, 2012 at 12:40 AM, Dan Kennedy danielk1...@gmail.com wrote:
On 02/28/2012 12:09 AM, Jos Groot Lipman wrote:
It was reported before (and not solved)
// The cmd string direct output to result
// Execute the command, then open result and read
#include stdlib.h
#include string.h
#include stdio.h
void main() {
FILE *f;
char buff[100];
const char * query = select 'hello Sqlite3';;
const char * cmd = sqlite3 test.db name result;
f = fopen(name,
https://github.com/Matt-Young/Embedded-SQL
It speaks Json text at the console, and operates from self directed
serialized Bson like streams formatted onto Sqlite triple tables.
Working, but just out of the lab, buggy, good for browsing. c code
16, 2012 at 11:58 PM, Roger Binns rog...@rogerbinns.com wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 16/01/12 21:46, Matt Young wrote:
Group projects, collected together because sqlite is the common
foundation. Would be nice?
You'll need to use longer sentences. What exactly
and still needing a self contained user id management. So, import the
standard user id function from the sqlite repositories and be done with it.
On Tue, Jan 17, 2012 at 5:01 AM, Matt Young youngsan...@gmail.com wrote:
Mainly grouping sqlite applications in the embedded environment, hopefully
http://javascriptsource.com/forms/dynamic-table.html
Looks great if you operate from a browser. Can we still get sqlite
embedded into the browser, or do we have to plug it in?
On Tue, Jan 17, 2012 at 8:05 AM, Chris Green c...@isbd.net wrote:
I'm after an application which will allow me to
http://www.c-sharpcorner.com/UploadFile/prasad_1/RegExpressionSample72005040853AM/RegExpressionSample1.aspx
At that site they parse your string using regex in c#, though I did't see a
time stamp test, and their is the equivalent regex functions, many, in a c
libs.
On Tue, Jan 17, 2012 at
Group projects, collected together because sqlite is the common
foundation. Would be nice?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I used the strcpy_s function from Microsoft, the so called safe version
that includes a char count. I used it under the Studio debugger. Set a
buffer of 200 chars to zero, set the char count to 20 in strcpy_s, and the
debugger wrote in the top 180!!
I freaked, didn't see that as safe at all!
On
select count() from sqlite_master;
No??
On Wed, Dec 21, 2011 at 10:32 AM, smallboat smallboa...@yahoo.com wrote:
Hello,
I have a sqlite file. I would like to open it and know how many tables in
it.
What is the command line to open a sqlite file and get to know how many
tables in it?
Good idea, as soon as I figure out how it works!
On Wed, Nov 23, 2011 at 2:41 PM, Nico Williams n...@cryptonector.comwrote:
Docs would help people understand what you're up to...
Nico
--
___
sqlite-users mailing list
sqlite-users@sqlite.org
A base of code that implements about every embedded function for sqlite3,
source code on my blog. It is a triple machine, looks at the world as
ripples for ontology. I tries to follow SQLITE standards. The control
program pops triple off of the configure table and executes them,
installing more
In the documentation on trigger, begin has no semicolon, and it works.
From the command line, I can begin and end transaction, but I need the
semicolon after begin. Is there a difference?
___
sqlite-users mailing list
sqlite-users@sqlite.org
sqlite drop trigger if exists mytrigger;
sqlite create trigger mytrigger after insert on result
... begin
... select 'Test2';
... end;
sqlite insert into result values(0,0,0);
sqlite
Explain the path of select here?
___
sqlite-users mailing
Well, it was listed as an initial option o the trigger, so I didn't quite
get it either.
On Sat, Nov 19, 2011 at 7:02 PM, Igor Tandetnik itandet...@mvps.org wrote:
Matt Young youngsan...@gmail.com wrote:
sqlite drop trigger if exists mytrigger;
sqlite create trigger mytrigger after insert
200 lines of code with embedded c. (headers omitted)
This code comes up and reads triples from a table view called self, reads
triples one at a time. The triples are either a configure and load sql
statement command, or the triple is executed, as a random sql procedure
doing whatever, Rinse and
Using cv api.
I install a prepared statement, but it cannot allow the table identifiers
to be replaced with sqlite3_bind. If the table in the statements is a view,
then I suppode it is an error to redefine the vie?
Bottom line, it is an error to change any table definition in a prepared
SQL needs a create schema, then the statement can be prepared against a
know schema, and swap out the table pointer at run time. The problem of
one great sql procedure that works on many different table of the same
format.
I have a work around.
___
I have table1, I make a view view one of that table. I then delete the
table, the view does not work.
I then recreate the table, and alter its name to the one viewed.
and view suddenly works.
Am I dreaming? Does SQLite3 maintain a schema in views an allow us to
alter table names?
Matt
I am still learning its behavior.
But, my experiment still works, even in embedded. I want lots of
procedures working on the same table format, with different table names.
So far, I write the procedures using table view. As of right now, I can
change the table names using alter table rename and
OK,I found the gotcha. I can swap out the target table in a view, but I
cannot read the rowids from a view.
So, do I have t, are rowids unavailable in a view?
On Mon, Nov 14, 2011 at 10:25 AM, Nico Williams n...@cryptonector.comwrote:
I thought nowadays SQLite3 was smart enough to
You saved the day!
On Mon, Nov 14, 2011 at 2:25 PM, Igor Tandetnik itandet...@mvps.org wrote:
On 11/14/2011 5:03 PM, Matt Young wrote:
OK,I found the gotcha. I can swap out the target table in a view, but I
cannot read the rowids from a view.
You can, if you make them part of the view
Embedded Sqlite3 questions:
I want to load and prepare multiple statements, keep them prepared and when
I want to use one of them, I will reset, bind and step.
Can pre-prepare multiple independent statements, then run them one at a
time at random?
Thanks, this may be a newbie question for
LinkedIn
Matt Young requested to add you as a connection on LinkedIn:
--
Zarko,
I'd like to add you to my professional network on LinkedIn.
- Matt
Accept invitation from Matt Young
http://www.linkedin.com/e/-62mihx-gnwac06i-14
How about a text editor with search and replace. There must exist a list of
the files in text form, hence search and replace gets a batch function that
uses .import
On Mon, Apr 4, 2011 at 2:41 PM, Simon Slavin slav...@bigfraud.org wrote:
On 4 Apr 2011, at 9:04pm, Gert Van Assche wrote:
We
sqlite select 1 as type union select 2;
type
1
2
sqlite select 'tr' as type union select 2;
type
2
tr
sqlite
The order of the rows change when text replaces a numeric.
___
sqlite-users mailing list
sqlite-users@sqlite.org
Right, ORDER by, oherwise the row order is undefined.
Why the urge to grab the mailing list, then look at the references?
Dunno, sloppy hobbyist..
On Sat, Apr 2, 2011 at 5:14 PM, Jay A. Kreibich j...@kreibi.ch wrote:
On Sat, Apr 02, 2011 at 05:01:34PM -0700, Matt Young scratched on the wall
A Web Sql widget really, here is a screen shot link
http://bettereconomics.blogspot.com/2011/03/xml-commander.html
It is all XML htp get, web sql and xml in javascript, working on opera
browsers. The idea is to get the publisher simple access to the combination
of SQL in his document and ad hoc
Here is my Javascript code, it works. Except I have to know the table field
names within the javascript code itself: This little phrase:
results.rows[i].f1
f1 is a field name, I have to know this in the call.
Yes I know indexDB is coming, but is there a workaround for this? I want to
scoop up
Yes, that one did it. Iterating on arrays by their factors.
Thanks.
On Fri, Mar 18, 2011 at 11:05 AM, H. Phil Duby phild...@phriendly.netwrote:
Nothing to do with SQLite, but ...
___
sqlite-users mailing list
sqlite-users@sqlite.org
I thought is just about matches everything I need for managing my databases.
I gave it a thumbs up.
That is all from a small researcher with gobs of data.
___
sqlite-users mailing list
sqlite-users@sqlite.org
I looked up Noah Hart and found a very nice C# inerface to the SQLIite
system. That sound's ideal, under Chrome OS so with other vendor support I
hear. So specialized blog readers can use widgets built with c#/ and get it
all, in the bowser
On Mon, Mar 7, 2011 at 5:03 AM, Richard Hipp
Trying to understand it. How do I specifically open sqlite from a jquery
widget.
Or best simple example.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
http://www.w3.org/TR/2010/NOTE-webdatabase-20101118/
//I can open a database
// write to it, read from it.
// But I would like access to the hidden database it creates.
// I look everywhere, cannot find it!
var databaseOptions = {
fileName: file://localhost/C:/R/work/test.db,
version: 1.0,
I am a regular user of sqite at the office, but I want to progress to sqlite
web access via the web. Who has the best widgets for that? Web space not a
problem. Widgets that work in blogger pages would be nice, but I can start
fresh also.
___
Bingo, I live and learn
On 5/28/10, Igor Tandetnik itandet...@mvps.org wrote:
Igor Tandetnik wrote:
Matt Young youngsan...@gmail.com wrote:
I second that documentation confusion. There is no truncate to
integer, though I wish it would.
Somewhat off-topic, but if you want truncation
I second that documentation confusion. There is no truncate to
integer, though I wish it would.
On 5/27/10, Wilson, Ronald rwils...@harris.com wrote:
From http://www.sqlite.org/lang_corefunc.html
The round(X,Y) function returns a string representation of the
floating-point value X rounded to
, Igor Tandetnik itandet...@mvps.org wrote:
Matt Young youngsan...@gmail.com wrote:
I second that documentation confusion. There is no truncate to
integer, though I wish it would.
Somewhat off-topic, but if you want truncation, this would do it: round(x -
0.5) . Well, it's more like floor
OK, got it. I was referring to the number of decimal points, but yes
round(x,0) does do something
On 5/27/10, Igor Tandetnik itandet...@mvps.org wrote:
Matt Young wrote:
Round(x,0) really doesn't exist, it simply does round(x,1)
select round(4.1, 0), round(4.1, 1);
4.04.1
--
Igor
Don't forget to mention Python
On 5/21/10, Gilles Ganault gilles.gana...@free.fr wrote:
On Fri, 21 May 2010 15:23:13 +0200, Jean-Christophe Deschamps
j...@q-e-d.org wrote:
AutoIt, while a scripting language can be seen and used as a RAD
platform. It enjoys good support, up to date SQLite
I have that problem. A solution is an ultra lite SQLite window to
play along side existing spread sheet packages. Then just get read and
write to the spreadsheet happening.
I did that simply with R; I reasoned Windows was smart enough to
handle files, so I just read and write files netween
I mentioned a while back that .import can be made to work with
flexible number columns by setting a mode that says 'ignore column
error on import'. The idea is that SQLite can import from csv files
where the number of columns is not known.
I looked that the code for import. If there was a
C:\R\SQLitesql ap.data.3.Food.db
SQLite version 3.6.23.1
Enter .help for instructions
Enter SQL statements terminated with a ;
sqlite .tables
Col2U seriesdata seriesid
sqlite .q
C:\R\SQLitesql
SQLite version 3.6.23.1
Enter .help for instructions
Enter SQL statements terminated
Thanks. A novice sometimes posts prior to a complete search of documentation.
On 5/11/10, P Kishor punk.k...@gmail.com wrote:
On Tue, May 11, 2010 at 1:50 PM, Matt Young youngsan...@gmail.com wrote:
sqlite create virtual table if not exists words using fts3 (f1 );
Error: near not: syntax
sqlite create virtual table if not exists words using fts3 (f1 );
Error: near not: syntax error
sqlite create table if not exists U (w1 );
sqlite
Different syntax? virtual tables don't persist?
___
sqlite-users mailing list
sqlite-users@sqlite.org
# series data looks like:
create table seriesdata (
data_index INTEGER PRIMARY KEY autoincrement,
series_id text,
year numeric,
value numeric);
# and is filled
insert into seriesid
select
s.series_id as id, min(data_index),max(data_index)
, it is not clear to me where you want to put that aggregated set. Do
you have another *table* called SERIESID with those three columns in it?
Regards
Tim Romano
Swarthmore PA
On Mon, May 10, 2010 at 2:43 AM, Matt Young youngsan...@gmail.com wrote:
# series data looks like:
create table seriesdata
In the following code I try select by group on one column. I am
assuming the query optimizer will figure to stop gathering column 1s
right away because there are no other selection constraints. Yet in
the example, sql still looks through the entire table for additional
column ones as one can see
. In general if you use
group by clause then only columns from group by clause can be
mentioned in select list, all other columns MUST be inside some sort
of aggregate function (http://www.sqlite.org/lang_aggfunc.html).
Pavel
On Fri, May 7, 2010 at 2:02 PM, Matt Young youngsan...@gmail.com wrote
without the min picks the last of the c2, not the first.
On 5/7/10, Matt Young youngsan...@gmail.com wrote:
On 5/7/10, Pavel Ivanov paiva...@gmail.com wrote:
Sorry, I can hardly understand what you are trying to say but want to
point out one error:
sqlite select 'Start';select * from T0 group by c2
Can I create a virtual table mapped to an existing table in my
database? Does this let me alias a whole table? Thinking out loud,
does this give me ability to write a query on the virtual table, then
remap the virtual table to a current table and execute the query?
# I am doing a simulation of distinct
insert into seriesid (series_id,pointer)
select series_id,ROWID from seriesdata as s
where s.series_id not in(
select
series_id
from
seriesid
, limit to extract just the
date series I want.
Starting to get it.
On 5/6/10, Simon Davies simon.james.dav...@googlemail.com wrote:
On 6 May 2010 12:03, Matt Young youngsan...@gmail.com wrote:
# I am doing a simulation of distinct
insert into seriesid (series_id,pointer)
select
Got it, thinks Jay.
On 5/6/10, Jay A. Kreibich j...@kreibi.ch wrote:
On Thu, May 06, 2010 at 05:10:31AM -0700, Matt Young scratched on the wall:
OK, I got it.
insert into seriesid
select series_id,min(ROWID) from
seriesdata group by series_id;
This gets me a table
Got that one two, thanks, this mail list saves time.
On 5/6/10, Jay A. Kreibich j...@kreibi.ch wrote:
On Thu, May 06, 2010 at 12:31:26AM -0700, Matt Young scratched on the wall:
Can I create a virtual table mapped to an existing table in my
database?
You'll need to write a fair amount
I need a version of import that reads what it can, filling in defaults
when too few columns, discarding data when too many.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
, Matt Young wrote:
I need a version of import that reads what it can, filling in defaults
when too few columns, discarding data when too many.
Great. Go ahead and write one. You have our permission.
Simon.
___
sqlite-users mailing list
sqlite
Righto yes, a simple macro somewhere in the path to correct for row size
On 5/6/10, Jim Jed Dodgen j...@dodgen.us wrote:
On Thu, May 6, 2010 at 3:56 PM, Simon Slavin slav...@bigfraud.org wrote:
On 6 May 2010, at 11:19pm, Matt Young wrote:
I need a version of import that reads what it can
I can work SQLite from by R stat package, but I am having hard time
mixing special sqlite command intermixed with SQL statements when I
send a text sequence to swqlite (even from the dos consol)
sqlite3 test.db .mode csv select * from selected limit 4
Makes sqlite choke because I do not know
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 can work SQLite from by R stat package, but I am having hard time
mixing special sqlite command intermixed with SQL statements when I
send a text sequence
corresponds to a_format, you can supply an alias for
that column in the inner select, like this:
select a_format
from
(
select table_id as a_format
from table_id_list
where prefix_code = 'MyPrefix_code'
);
Regards
Tim Romano
Swarthmore PA
On Sun, May 2, 2010 at 10:22 AM, Matt
I am a bit of a novice. I am dealing with meta data, descriptions of
the Bureau of Labor Statistics database. BLS data is identified by a
series code (16 chars long) but the series format is different for
each data group)
I need to extract from an SQL table the names of other SQL tables and
I want to see SQLite integrated into the R statistical package. R Project
http://www.gardenersown.co.uk/Education/Lectures/R/regression.htm#multiple_regression
for example.
R statistical is very and becoming more popular, has great plotting,
and wrestles data in frames that look awfully like sql
can
communicate to the maintainers of those packages.
On Sun, May 2, 2010 at 8:38 PM, Matt Young youngsan...@gmail.com wrote:
I want to see SQLite integrated into the R statistical package. R Project
http://www.gardenersown.co.uk/Education/Lectures/R/regression.htm#multiple_regression
64 matches
Mail list logo