Re: [sqlite] Question about SQLite features.

>From: "Kees Nuyt" >Thursday, November 11, 2010 10:34:51 AM >  >Stored procedures don't enforce business rules by >themselves. Constraints and triggers do. >To enforce business rules stored as procedures in the >database, one would need an access system which prevents >direct

Re: [sqlite] Question about SQLite features.

"Chris Wolf" schrieb [Nested Recordsets/Resultsets as an alternative to Joins, to "shape-off" redundancy in "hierarchical requests"... as a native DB-Feature usable over Sybase StoredProcs... ...and the ADO-ShapeProvider as an example for an alternative to use "these things" in a

Re: [sqlite] Question about SQLite features.

On Nov 11, 2010, at 9:38 PM, Ian Hardingham wrote: > Haha! Sqlite is embedded by others. It NEVER embeds. SQLite's tagline of the week :P ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Question about SQLite features.

I hope this doesn't get posted twice.  I don't think it will since I sent form wrong account first time.  Sorry. >From: "Kees Nuyt" >Thursday, November 11, 2010 10:34:51 AM >  >Stored procedures don't enforce business rules by >themselves. Constraints and triggers do. >To

Re: [sqlite] Question about SQLite features.

Olaf Schmidt wrote: > "Chris Wolf" schrieb > > >> I can't resist adding my little opinion to yet another >> "business logic in stored procs vs. app layer" holy war... >> > > ... yeah, seems this thread is evolving nicely in this > regard ... > > >> I usually prefer keeping the

Re: [sqlite] Question about SQLite features.

"Chris Wolf" schrieb > I can't resist adding my little opinion to yet another > "business logic in stored procs vs. app layer" holy war... ... yeah, seems this thread is evolving nicely in this regard ... > I usually prefer keeping the business logic in the application > layer and leaving the

Re: [sqlite] Question about SQLite features.

Haha! Sqlite is embedded by others. It NEVER embeds. - Original message - > > On Nov 10, 2010, at 11:05 AM, Andy Gibbs wrote: > > > > That's I don't know SQLite have stored procedure support? > > > > > > > How're your C skills? > > Or perhaps SQLite should embed Lua [1] as its

Re: [sqlite] Question about SQLite features.

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 11/11/2010 06:26 AM, jeff archer wrote: > The overall design and structure of applications using SQLite and > therefor SQLite itself would benefit from SQLite supporting stored > procedures. SQLite includes mechanisms to implement almost

Re: [sqlite] Question about SQLite features.

Olaf Schmidt wrote: > "Petite Abeille" schrieb > >> On Nov 11, 2010, at 8:30 PM, Olaf Schmidt wrote: >> >> >>> If such an "encapsulation of business-rules" is sitting in the >>> DB itself - written in a proprietary "DB-dialect", then you >>> cannot call such a thing a "business-layer"

Re: [sqlite] Question about SQLite features.

"Petite Abeille" schrieb > > On Nov 11, 2010, at 8:30 PM, Olaf Schmidt wrote: > > > If such an "encapsulation of business-rules" is sitting in the > > DB itself - written in a proprietary "DB-dialect", then you > > cannot call such a thing a "business-layer" anymore. > > Nonsense :)) Of

Re: [sqlite] Question about SQLite features.

On Thu, Nov 11, 2010 at 5:36 PM, Petite Abeille wrote: > > On Nov 12, 2010, at 12:31 AM, Jay A. Kreibich wrote: > >>  There have been many proposals to do just this, and in specific, >>  with Lua.  Outside of some moderate technical issues, the >>  big problem is the

Re: [sqlite] Question about SQLite features.

On Nov 12, 2010, at 12:31 AM, Jay A. Kreibich wrote: > There have been many proposals to do just this, and in specific, > with Lua. Outside of some moderate technical issues, the > big problem is the license. Something like that would *never* > be part of the SQLite core because the Lua

Re: [sqlite] Question about SQLite features.

On Thu, Nov 11, 2010 at 09:05:15PM +0100, Petite Abeille scratched on the wall: > Or perhaps SQLite should embed Lua [1] as its powerful, fast, > lightweight, scripting language and be done with it :) There have been many proposals to do just this, and in specific, with Lua. Outside of some

Re: [sqlite] Question about SQLite features.

On Nov 10, 2010, at 11:05 AM, Andy Gibbs wrote: >> That's I don't know SQLite have stored procedure support? >> > > How're your C skills? Or perhaps SQLite should embed Lua [1] as its powerful, fast, lightweight, scripting language and be done with it :) [1] http://www.lua.org/about.html

Re: [sqlite] Question about SQLite features.

On Nov 11, 2010, at 8:30 PM, Olaf Schmidt wrote: > If such an "encapsulation of business-rules" is sitting in the > DB itself - written in a proprietary "DB-dialect", then you > cannot call such a thing a "business-layer" anymore. Nonsense :)) In any case, for these of us who do want to be

Re: [sqlite] Question about SQLite features.

"jeff archer" schrieb >From: "Olaf Schmidt" >Wednesday, November 10, 2010 9:07:19 AM > >>[Stored procedures in SQLite] >> >>IMO stored procedure-support only makes sense in >> "Server-Instances" which run on their own... > I disagree. The overall design and structure of > applications using

Re: [sqlite] Question about SQLite features.

On Thu, 11 Nov 2010 06:26:31 -0800 (PST), jeff archer wrote: >>From: "Olaf Schmidt" >>Wednesday, November 10, 2010 9:07:19 AM >> >>[Stored procedures in SQLite] >> >>IMO stored procedure-support only makes sense in "Server-Instances" which run >>on >>their

Re: [sqlite] Question about SQLite features.

>From: "Olaf Schmidt" >Wednesday, November 10, 2010 9:07:19 AM > >[Stored procedures in SQLite] > >IMO stored procedure-support only makes sense in "Server-Instances" which run >on >their own... I disagree.  The overall design and structure of applications using SQLite and

Re: [sqlite] Question about SQLite features.

Hey "Andy Gibbs". Why your code isn't added into sqlite? - "Andy Gibbs" escreveu: > On Tuesday, November 09, 2010 8:29 AM, Tran Van Hoc wrote: > > > Dear all. > > > > I'm using SQLite and many thanks for your supports. > > > > I have problem about SQLite

Re: [sqlite] Question about SQLite features.

"Tran Van Hoc" schrieb im Newsbeitrag news:43a0ef604a674b3fb80d1447b41f8...@isbvietnam.com... [Stored procedures in SQLite] IMO stored procedure-support only makes sense in "Server-Instances" which run on their own (and communicate over different IPC-mechanisms, mainly

Re: [sqlite] Question about SQLite features.

On Tuesday, November 09, 2010 8:29 AM, Tran Van Hoc wrote: > Dear all. > > I'm using SQLite and many thanks for your supports. > > I have problem about SQLite features. > > That's I don't know SQLite have stored procedure support? > How're your C skills? If you are comfortable with the idea,

Re: [sqlite] Question about SQLite features.

> That's I don't know SQLite have stored procedure support? No. There's only limited support of triggers, i.e. triggers don't have some full-featured programming language, they are just a set of selects, updates, deletes or inserts Pavel On Tue, Nov 9, 2010 at 2:29 AM, Tran Van Hoc

[sqlite] Question about SQLite features.

Dear all. I'm using SQLite and many thanks for your supports. I have problem about SQLite features. That's I don't know SQLite have stored procedure support? Expect your respond. Thanks you very much. ___ sqlite-users mailing list