[sqlite] jquery sqlite3

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

[sqlite] I have a database working directly from

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",

Re: [sqlite] jquery sqlite3

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

[sqlite] Yes, I checked out SqLite Maestro

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

[sqlite] WebSql question

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

Re: [sqlite] WebSql question

Yes, that one did it. Iterating on arrays by their factors. Thanks. On Fri, Mar 18, 2011 at 11:05 AM, H. Phil Duby wrote: > Nothing to do with SQLite, but ... > > ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] I made a sqlite widget

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

[sqlite] Is this normal?

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

Re: [sqlite] Is this normal?

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

Re: [sqlite] import thousands of documents in SQLite

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 wrote: > > On 4 Apr 2011, at 9:04pm, Gert Van Assche wrote: >

[sqlite] General question on sqlite3_prepare, the bind and resets of prepared statements

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

[sqlite] I have a stumper

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

Re: [sqlite] I have a stumper

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. ___

[sqlite] OK,OK I have an experiment

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

Re: [sqlite] I have a stumper

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

Re: [sqlite] I have a stumper

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 wrote: > >> I thought nowadays SQLite3 was smart enough to

Re: [sqlite] I have a stumper

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. >> >

[sqlite] 200 lines of fun sqlite3 code

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

[sqlite] Simple one

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

Re: [sqlite] Simple one

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; > > sq

[sqlite] begin with or without semicolon?

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] Free c code for embedded sqlite3

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

Re: [sqlite] Free c code for embedded sqlite3

Good idea, as soon as I figure out how it works! On Wed, Nov 23, 2011 at 2:41 PM, Nico Williams wrote: > Docs would help people understand what you're up to... > > Nico > -- > ___ > sqlite-users mailing list >

Re: [sqlite] command line to get number of tables in sqlite

select count() from sqlite_master; No?? On Wed, Dec 21, 2011 at 10:32 AM, smallboat 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

Re: [sqlite] sqlite3_column_text() returning partial results

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

Re: [sqlite] what languages

Don't forget to mention Python On 5/21/10, Gilles Ganault wrote: > On Fri, 21 May 2010 15:23:13 +0200, Jean-Christophe Deschamps > wrote: >>AutoIt, while a scripting language can be seen and used as a RAD >>platform. It enjoys good support, up to date

Re: [sqlite] round documentation

I second that documentation confusion. There is no truncate to integer, though I wish it would. On 5/27/10, Wilson, Ronald wrote: > From http://www.sqlite.org/lang_corefunc.html > > "The round(X,Y) function returns a string representation of the > floating-point value X

Re: [sqlite] round documentation

y does round(x,1) On 5/27/10, 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 tr

Re: [sqlite] round documentation

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(

Re: [sqlite] round documentation

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. &g

[sqlite] Best practices fo web interface

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. ___

[sqlite] Can I throw a query out to the group?

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

Re: [sqlite] [server] HTTP + SQLite bundled as single EXE?

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

Re: [sqlite] [server] HTTP + SQLite bundled as single EXE?

certain other R packages (sqldf, RODBC, RJDBC, sqliteDF) then you 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 &g

Re: [sqlite] Can I throw a query out to the group?

ode = 'MyPrefix_code' > ); > > > Regards > Tim Romano > Swarthmore PA > > > > > > > > > > > > On Sun, May 2, 2010 at 10:22 AM, Matt Young <youngsan...@gmail.com> wrote: > >> I am a bit of a novice. I am dealing with meta data, descriptions of >> th

[sqlite] Doing fine with SQLite

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

Re: [sqlite] Doing fine with SQLite

gt; 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 can work SQLite from by R stat package, but I am having hard time >> mixing special sqlite command int

[sqlite] Virtual tables

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?

[sqlite] Should this work?

# 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

Re: [sqlite] Should this work?

, 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

Re: [sqlite] Should this work?

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

Re: [sqlite] Virtual tables

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? > >

[sqlite] One more on .import

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

Re: [sqlite] One more on .import

2010, at 11:19pm, 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. >

Re: [sqlite] One more on .import

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: >>

[sqlite] Group by optimizer

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

Re: [sqlite] Group by optimizer

c1), c2 from T0 group by c2; > > Other aggregate variants are possible too. 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 (ht

Re: [sqlite] Group by optimizer

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] Should this work?

# 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)

Re: [sqlite] Should this work?

(data_index) > > However, 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 <

[sqlite] create virtual table if not exists table_id???

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] Attach

C:\R\SQLite>sql 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\SQLite>sql SQLite version 3.6.23.1 Enter ".help" for instructions Enter SQL statements

Re: [sqlite] create virtual table if not exists table_id???

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 fts

[sqlite] .import, after a peek at the code

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

Re: [sqlite] [Windows] Application to let end-users handle records?

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

[sqlite] Open source projects using sqlite

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

Re: [sqlite] Open source projects using sqlite

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? > >

Re: [sqlite] Open source projects using sqlite

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,

Re: [sqlite] Wanted - a straightforward 'grid' data entry tool for sqlite

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 wrote: > I'm after an application which will allow me to

Re: [sqlite] Bin parameters by name - generic function

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

[sqlite] Open source Json/Sqlite adtaper

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

Re: [sqlite] I'm sure I'm missing something.

// The cmd string direct output to result // Execute the command, then open result and read #include #include #include void main() { FILE *f; char buff[100]; const char * query = "select 'hello Sqlite3';"; const char * cmd = "sqlite3 test.db < name > result"; f = fopen("name", "w+"); if(f==0)

Re: [sqlite] FTS simple tokenizer

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 wrote: > On 02/28/2012 12:09 AM, Jos Groot Lipman wrote: > >> It was reported before (and not solved) >>

[sqlite] Invitation to connect on LinkedIn

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