Re: [sqlite] ANN: SQLite 3.6.16.C#

Hi Noah, A name suggestion: "SharpLightSQL" - SLSQL or just SLS. Sunday, August 2, 2009, 10:57:56 PM, you wrote: NH> Richard sent me a gentle reminder that read in part: NH> NH> Please also note that the SQLite source code is in the public domain,

Re: [sqlite] CREATE TABLE AS SELECT * FROM changes columndefinition --bug or feature?

P Kishor wrote: > On Sun, Aug 2, 2009 at 10:39 PM, Igor > Tandetnik wrote: >> You don't make a copy of a table - you make a copy of the resultset >> of a SELECT statement. Columns in said resultset don't carry >> attributes like DEFAULT, even though columns in the underlying

Re: [sqlite] CREATE TABLE AS SELECT * FROM changes column definition --bug or feature?

On Sun, Aug 2, 2009 at 10:39 PM, Igor Tandetnik wrote: > P Kishor wrote: >> SQLite version 3.6.11 >> Enter ".help" for instructions >> Enter SQL statements terminated with a ";" >> sqlite> CREATE TABLE foo (id INTEGER PRIMARY KEY, desc TEXT, num >> INTEGER DEFAULT 0); >>

Re: [sqlite] CREATE TABLE AS SELECT * FROM changes column definition --bug or feature?

P Kishor wrote: > SQLite version 3.6.11 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> CREATE TABLE foo (id INTEGER PRIMARY KEY, desc TEXT, num > INTEGER DEFAULT 0); > sqlite> INSERT INTO foo (desc) VALUES ('foo'); > sqlite> INSERT INTO foo (desc) VALUES

Re: [sqlite] ANN: SQLite 3.6.16.C#

P Kishor wrote: > On Sun, Aug 2, 2009 at 7:57 AM, Noah Hart wrote: >> Richard sent me a gentle reminder that read in part: >> >> >> Please also note that the SQLite source code is in the public domain, but >> the "SQLite" name is

[sqlite] CREATE TABLE AS SELECT * FROM changes column definition -- bug or feature?

SQLite version 3.6.11 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> CREATE TABLE foo (id INTEGER PRIMARY KEY, desc TEXT, num INTEGER DEFAULT 0); sqlite> INSERT INTO foo (desc) VALUES ('foo'); sqlite> INSERT INTO foo (desc) VALUES ('bar'); sqlite> INSERT INTO foo

Re: [sqlite] ANN: SQLite 3.6.16.C#

John Stanton-3 wrote: > > Maybe the author could explain the reason for C# translation. Surely a > better approach if the JIT is required would be to use something like > gcc and change the code generator to the C# metacode. Such a product > may already exist. > > A translated program is

Re: [sqlite] ANN: SQLite 3.6.16.C#

Maybe the author could explain the reason for C# translation. Surely a better approach if the JIT is required would be to use something like gcc and change the code generator to the C# metacode. Such a product may already exist. A translated program is rev locked. Kosenko Max wrote: > Seems

Re: [sqlite] ANN: SQLite 3.6.16.C#

Noah Hart wrote: > The license is the same as SQLite, I'm waiting on google to change the > project to PD since that is not one of the canned choices. Thank you very much. Can't disagree with Miguel that this is "A godsend gift to developers". Keep us informed about name change (in case Dr.

Re: [sqlite] ANN: SQLite 3.6.16.C#

And in the Window's there are ... For example: System.Data.SQLite An open source ADO.NET provider for the SQLite database engine http://sqlite.phxsoftware.com/ http://code.google.com/p/sqlite-ng/ sqlite-ng A fork of SQLite with more community involvement SQLite-ng is a fork of SQLite with the

Re: [sqlite] ANN: SQLite 3.6.16.C#

The license is the same as SQLite, I'm waiting on google to change the project to PD since that is not one of the canned choices. Noah It's a pity news. I hoped Dr. can think about even somehow supporting your project. I don't know why he insists on that (he actually can answer for himself

Re: [sqlite] ANN: SQLite 3.6.16.C#

Thanks Jim ! -- kjh Jim Showalter wrote: > Yes, C# supports native calls. You just call pinvoke. > > But a pure C# implementation allows it to run in Silverlight and other > C# applications where native calls are not allowed. > > http://sqlite.phxsoftware.com/forums/t/1642.aspx > > -

Re: [sqlite] ANN: SQLite 3.6.16.C#

Yes, C# supports native calls. You just call pinvoke. But a pure C# implementation allows it to run in Silverlight and other C# applications where native calls are not allowed. http://sqlite.phxsoftware.com/forums/t/1642.aspx - Original Message - From: "Konrad J Hambrick"

Re: [sqlite] ANN: SQLite 3.6.16.C#

Noah -- This is a wonderful accomplishment ! However, I have a question ... Doesn't C# support native function calls ? If so, other than scratching an itch, what does a native port to C# do ? Thanks. -- kjh Noah Hart wrote: > Richard sent me a gentle reminder that read in part: > >

Re: [sqlite] ANN: SQLite 3.6.16.C#

Seems like I've missed something... Well, if there would be a team dedicated to supporting managed implementation of SQLite which can be at any time quickly updated to reflect all changes of SQLite native - anyone can always transfer such requests to that team. Same happens i.e. with SQLite.NET

Re: [sqlite] ANN: SQLite 3.6.16.C#

> -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Kosenko Max > Sent: 02 August 2009 19:40 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] ANN: SQLite 3.6.16.C# > I don't know why he insists on that (he actually can

Re: [sqlite] ANN: SQLite 3.6.16.C#

Max's point is that JITs automatically compile down to native code, thus a screwdriver is turned into a monkey wrench, therefore you only need the screwdriver. There are other reasons besides native vs. VM why C#/Java would be slower than C. For example, C doesn't have the overhead of virtual

Re: [sqlite] ANN: SQLite 3.6.16.C#

It's a pity news. I hoped Dr. can think about even somehow supporting your project. I don't know why he insists on that (he actually can answer for himself here) while there are a lot of SQLite based projects with that name usage. May be that's because of your license? Max. Noah Hart wrote: >

Re: [sqlite] ANN: SQLite 3.6.16.C#

Thank you for your understanding. And best of luck with XXLite? I know you have a large captive audience out there. It is the only reason I swallow my pride and admit knowledge of the most pervasive OS currently on the planet. Not the "best" technically, but best "marketed." Fred

Re: [sqlite] ANN: SQLite 3.6.16.C#

I have at least a screwdriver and monkey wrench to go with my hammer in my computer software tool bag. Observing the fastener at hand allows me to pick the proper tool. Then if that doesn't work, there's always the hammer. -Original Message- From: sqlite-users-boun...@sqlite.org

[sqlite] Java Code to Generate Foreign Key Constraint Trigger

This is a Java method that will create a SQLite foreign key constraint for inserts or updates. You pass in the action (Insert, Update), the table name, the foreign key field name, the foreign table name, and the foreign table key field name. public String

Re: [sqlite] ANN: SQLite 3.6.16.C#

On Sun, Aug 2, 2009 at 7:57 AM, Noah Hart wrote: > > Richard sent me a gentle reminder that read in part: > > > Please also note that the SQLite source code is in the public domain, but > the "SQLite" name is not.  SQLite is a

Re: [sqlite] ANN: SQLite 3.6.16.C#

What about SqlSharp? Tim > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Noah Hart > Sent: 02 August 2009 13:58 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] ANN: SQLite 3.6.16.C# > > Also, if anyone has an

Re: [sqlite] ANN: SQLite 3.6.16.C#

Richard sent me a gentle reminder that read in part: Please also note that the SQLite source code is in the public domain, but the "SQLite" name is not. SQLite is a registered trade mark. If I don't defend the trademark, then I could lose it. So, I

Re: [sqlite] ANN: SQLite 3.6.16.C#

9/30054 means 99.97% tests are working. That's a great achievement anyway. Performance problems can be profiled and optimized simpler than with native version. That isn't a nature of managed code to be slow. i.e. Perst DB which is managed from scratch is same speed or faster than SQLite

Re: [sqlite] ANN: SQLite 3.6.16.C#

I don't know why you have decided that C# or Java isn't competitive to native compiled code. After JIT there is no VM between Java/.NET and OS. While C has better compiler than C# it still don't have JIT engine that can optimize your code for specific hardware you're running on right now. Or it

Re: [sqlite] Use VDBE in extension

Okay, I have givven up implementing direct VDBE access in a loadable extension. Last thing I tried was to link the extension against all needed objects. Read: > cd sqlite/src > for f in *.c; do gcc -c "$f"; done > cd ../.. > gcc -shared sqlite/src/*.o ext.o -o ext.so ...or something like that.

Re: [sqlite] A memvfs for loading/saving database from buffer

http://sphivedb.googlecode.com/files/spmemvfs-0.2.src.tar.gz The demo code: typedef struct spmembuffer_t { char * data; int used; int total; } spmembuffer_t; typedef struct spmemvfs_db_t { sqlite3 * handle; spmembuffer_t * mem; } spmemvfs_db_t; void test( spmemvfs_db_t * db

Re: [sqlite] ANN: SQLite 3.6.16.C#

* Noah Hart: > I am pleased to announce that the C# port is done to the point where others > can look at it. Congratulations! (Is there something similar for Java, not using JNI nor NestedVM? 8-) ___ sqlite-users mailing list sqlite-users@sqlite.org