[sqlite] How to build sqlite4? Which branches are expected to build?
See subject. Thanks! ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] 3rd Call For Papers, 19th Annual Tcl/Tk Conference 2012
[[ Get your papers, WIPs and posters in. (We have an exhibition hall with 25 gesture-controlled screens to show the latter two on). The deadline for abstracts and proposals is three weeks away. ]] [[ Notes: Colin Walker of F5 is confirmed as our Keynote speaker. http://www.f5.com ]] 19th Annual Tcl/Tk Conference (Tcl'2012) http://www.tcl.tk/community/tcl2012/ November 12 - 16, 2012 Sessions: National Museum of Health and Medicine Chicago 175 W. Washington Chicago, IL 60602 Rooms: Holiday Inn Chicago Mart Plaza 350 West Mart Center Drive Chicago, Illinois, USA Map: https://maps.google.com/maps/ms?msid=204739899073144451536.0004c144222a9036c99f6&msa=0&ll=41.885266,-87.633734&spn=0.008443,0.018818 Important Dates: Abstracts and proposals due August27, 2012 Notification to authors September 10, 2012 WIP and BOF reservations open August 6, 2012 Author materials due October 29, 2012 Tutorials Start November 12, 2012 Conference starts November 14, 2012 Email Contact:tclconfere...@googlegroups.com Submission of Summaries Tcl/Tk 2012 will be held in Chicago, Illinois, USA from November 12 - 16, 2012. The program committee is asking for papers and presentation proposals from anyone using or developing with Tcl/Tk (and extensions). Past conferences have seen submissions covering a wide variety of topics including: * Scientific and engineering applications * Industrial controls * Distributed applications and Network Managment * Object oriented extensions to Tcl/Tk * New widgets for Tk * Simulation and application steering with Tcl/Tk * Tcl/Tk-centric operating environments * Tcl/Tk on small and embedded devices * Medical applications and visualization * Use of different programming paradigms in Tcl/Tk and proposals for new directions. * New areas of exploration for the Tcl/Tk language Submissions should consist of an abstract of about 100 words and a summary of not more than two pages, and should be sent as plain text to no later than August 27, 2012. Authors of accepted abstracts will have until October 29, 2012 to submit their final paper for the inclusion in the conference proceedings. The proceedings will be made available on digital media, so extra materials such as presentation slides, code examples, code for extensions etc. are encouraged. Printed proceedings will be produced as an on-demand book at lulu.com The authors will have 25 minutes to present their paper at the conference. The program committee will review and evaluate papers according to the following criteria: * Quantity and quality of novel content * Relevance and interest to the Tcl/Tk community * Suitability of content for presentation at the conference Proposals may report on commercial or non-commercial systems, but those with only blatant marketing content will not be accepted. Application and experience papers need to strike a balance between background on the application domain and the relevance of Tcl/Tk to the application. Application and experience papers should clearly explain how the application or experience illustrates a novel use of Tcl/Tk, and what lessons the Tcl/Tk community can derive from the application or experience to apply to their own development efforts. Papers accompanied by non-disclosure agreements will be returned to the author(s) unread. All submissions are held in the highest confidentiality prior to publication in the Proceedings, both as a matter of policy and in accord with the U. S. Copyright Act of 1976. The primary author for each accepted paper will receive registration to the Technical Sessions portion of the conference at a reduced rate. Other Forms of Participation The program committee also welcomes proposals for panel discussions of up to 90 minutes. Proposals should include a list of confirmed panelists, a title and format, and a panel description with position statements from each panelist. Panels should have no more than four speakers, including the panel moderator, and should allow time for substantial interaction with attendees. Panels are not presentations of related research papers. Slots for Works-in-Progress (WIP) presentations and Birds-of-a-Feather sessions (BOFs) are available on a first-come, first-served basis starting in August 6, 2012. Specific instructions for reserving WIP and BOF time slots will be provided in the registration information available in June 2012. Some WIP and BOF time slots will be held open for on-site reservation. All attendees with an interesting work in progress should consider reserving a WIP slot. Registration Information More information on the conference is available the conference Web site (http://www.tcl.tk/community/tcl2012/) and will be published on various Tcl/Tk-related information channels. To keep in touch with news regarding the conference and Tcl events in general, subscribe to the tcl-announce li
Re: [sqlite] C# Dynamic data type
You can use sscanf to determine data type...I've done it before using a method that's not obvious... You parse from most restrictive to least restrictive format like this...this will accept any valid float format including scientific notation. #include enum {UNKNOWN, FLOAT, INT, STRING}; int datatype(char *s) { long i; double f; char buf[4096]; int n; n = sscanf(s,"%d%s",&i,buf); if (n == 1) { printf("INT\n"); return INT; } n = sscanf(s,"%lg%s",&f,buf); if (n == 1) { printf("FLOAT\n"); return FLOAT; } n = sscanf(s,"%s",buf); if (n == 1) { printf("STRING\n"); return STRING; } else { printf("UNKNOWN\n"); return UNKNOWN; // should never get here } } main() { char *line1="1234"; char *line2="1234.5"; char *line3="x1234.5"; datatype(line1); datatype(line2); datatype(line3); } ~ Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Adam DeVita [adev...@verifeye.com] Sent: Tuesday, August 07, 2012 10:26 AM To: General Discussion of SQLite Database Subject: EXT :[sqlite] C# Dynamic data type Good day, I've been reading a bit of conflicted stuff online in terms of data type. The most basic question, in C#, is can you easily determine the data type of the Nth entry in a column. {Ex: Create table A( x TEXT, y ) ... a few inserts, binding a float, then a string, then an int into y.. select x,y from A check the type of y before retrieving a value from it. } The docs for SQLiteDataReader.GetFieldType() seems to read as if it will return the column affinity. regards, Adam ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] C# Dynamic data type
Good day, I've been reading a bit of conflicted stuff online in terms of data type. The most basic question, in C#, is can you easily determine the data type of the Nth entry in a column. {Ex: Create table A( x TEXT, y ) ... a few inserts, binding a float, then a string, then an int into y.. select x,y from A check the type of y before retrieving a value from it. } The docs for SQLiteDataReader.GetFieldType() seems to read as if it will return the column affinity. regards, Adam ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Suggestions for approximate date
I'd vote for the date-range as that can be indexed and result in fast retrieval. The separate column for accuracy would be a computed range and not indexable. Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Oliver Schneider [sqlite-mailingl...@f-prot.com] Sent: Tuesday, August 07, 2012 9:46 AM To: sqlite-users@sqlite.org Subject: EXT :[sqlite] Suggestions for approximate date Hello, I have a decision to make about how to store dates that may not be entirely accurate inside an SQLite DB. There are two options I came up with: 1. store "exact" date plus (in separate column) value for accuracy 2. store date range corresponding to original accuracy The accuracy can be exact date, only month and year, +/- 1 year, +/- 10 years, +/- 50 years. I reckon for searching the second option could be better. Does anyone here have any better ideas? I'd go for the Julian Day stored as REAL in either case. Thanks, // Oliver ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Suggestions for approximate date
Hello, I have a decision to make about how to store dates that may not be entirely accurate inside an SQLite DB. There are two options I came up with: 1. store "exact" date plus (in separate column) value for accuracy 2. store date range corresponding to original accuracy The accuracy can be exact date, only month and year, +/- 1 year, +/- 10 years, +/- 50 years. I reckon for searching the second option could be better. Does anyone here have any better ideas? I'd go for the Julian Day stored as REAL in either case. Thanks, // Oliver ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Fw: Fw: Fw: A question on sqlite processing
Dear sirs, My group is working with SQLITE Version 3.7 . .and the project has to do with transformation of applications to run on a Bare PC. On a CREATE TABLE, our traversal, in terms of opcodes, inside sqlite3VdbeExec() is something like 1, 22, 25, 1, 23, 1a, 7, 24, 7, 24, 62, 27, 36, a, 37, 2b, 2b, a, 27, 15, 4a, etc. A parallel session on Visual Studios gives the same sequence but has opcode 34 instead of the highlighted 4a. Can you, out of your expertise with SQLITE tell us what could cause this difference,? Any clue would help. In going from one opcode to another, what is there to watch for, that may alter the opcode value, p1 value, p2 value or p3 value? If at all possible, I would like to speak offline with some developer in your group so I can describe a few more of our observations - my cell is (973) 332 0997, Best Regards, RKKUZO - Forwarded Message - From: "Black, Michael (IS)" To: u okafor ; "sqlite-users@sqlite.org" Sent: Tuesday, January 3, 2012 10:22 AM Subject: RE:Fw: [sqlite] Fw: A question on sqlite processing Why don't you try the split yourself and see if it solves the problem and then let us all know? It sure sounds like file size could be the cause. Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: u okafor [uo07...@yahoo.com] Sent: Monday, January 02, 2012 4:41 PM To: sqlite-users@sqlite.org Cc: Black, Michael (IS); d...@sqlite.org Subject: EXT :Fw: [sqlite] Fw: A question on sqlite processing Is that to say that the 'split on the source file' that is yet to be made is the reason for the branching described below (see highlighted below) - can you, please, explain further, I am still lost? That question still remains a question, please help . . . And now, another . . if you don't mind . . when I tried to set a breakpoint at the definition (in sqlite3.c file) of the function,SQLITE_API u8 state = 0; intsqlite3_complete(constchar*zSql){/* Current state, using numbers defined in header comment */u8 token; not currently be hit. No executable code is associated with this line. Possible causes include: preprocessir directives or compiler/linker optimizations. I would really like dislodge/remove as many of the preprocessor directives and options for compiler/linker optimization as possible. Mine is a search project; I need to strip off the sophistication used all over to have just the bare application. Can you help me? - Forwarded Message - From: "Black, Michael (IS)" To: u okafor ; General Discussion of SQLite Database Sent: Friday, December 30, 2011 8:17 AM Subject: RE:[sqlite] Fw: A question on sqlite processing This was just answered in another chain. Visual Studio has a 64k limit on source code files for the debugger (thanks Microsoft...a 16-bit limit?...really!). If you need to step into it use WinDbg http://msdn.microsoft.com/en-us/windows/hardware/gg463009 Nobody has done a split on the source file yet to make it < 64k. Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of u okafor [uo07...@yahoo.com] Sent: Thursday, December 29, 2011 3:24 PM To: sqlite-users@sqlite.org Subject: EXT :[sqlite] Fw: A question on sqlite processing Dear sir, I have built a project solution in Visual Studio environment (version 10) using a free amalgamation source down from SQLite website and I am debugging. My first question is - when I invoke sqlite3_complete() out of the shell.c source file, control passes into the body of sqlite3PagerSetPageSize(Pager *pPager, ..) function, a method defined in sqlite3.c file (rather than going to a function defined in sqlite3.c file as sqlite3_complete()). please explain this phenomenon and the reason behind it . . . it's a similar occurrence also with sqlite3_config. It is consistent and obviously with a reason - only I don't know what that reason is, please help Yours truly, uzo okafor - Forwarded Message - From: Richard Hipp To: u okafor Sent: Wednesday, December 28, 2011 8:45 PM Subject: Re: A question on sqlite processing On Wed, Dec 28, 2011 at 7:26 PM, u okafor wrote: Dear sir, >I am a research student who is currently using freely downloaded software from >SQLite. >I have a few questions and would appreciate if you can call me back @ (973) >332 0997 >My questions are so simple, I promise . . >uzo okafor > > I am on travel. Questions to sqlite-users@sqlite.org will get answered quickly. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users /* Value of the next token *
Re: [sqlite] How to build a new sqlite3.dylib?
Tobias, Heres how you can make your own shared library under Mac OS X. Download http://www.sqlite.org/download.html/sqlite-amalgamation-3071300.zip # In the terminal export LD_LIBRARY_PATH=. # Make the library call it libsqlite3_mybuild.dylib gcc -o libsqlite3_mybuild.dylib sqlite3.c -dynamiclib # Build the shell using the new libsqlite3_mybuild.dylib shared library. gcc -o shell shell.c -lsqlite3_mybuild -L$LD_LIBRARY_PATH ./shell SQLite version 3.7.13 2012-06-11 02:05:22 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .exit # Display the names and version numbers of the shared libraries that the object file uses. otool -L ./shell ./shell: libsqlite3_mybuild.dylib (compatibility version 0.0.0, current version 0.0.0) /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 159.1.0) Best of Luck, Clive Hayward On Mon, Aug 6, 2012 at 3:48 PM, Tobias Giesen wrote: >> Do you absolutely need to use a dynamic library ? > > I have spent a full day trying to compile & link the c and h file with > my Pascal code and I have given up. The DB library I have expects a > dylib so I will have to feed it what it can eat. > > Trouble is, I don't know how to build the dylib either so I need some > mercy from somebody who has a recent build. > > Thanks! > > Cheers, > Tobias -- Clive Hayward ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users