>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 modification of table
"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 DBEngine-ind
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
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-user
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 enforce business rules
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 busines
"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
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 powerf
-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 anythin
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" any
"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 course...
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 license. Something like that
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 lic
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
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
__
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 clos
"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 SQLi
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 own...
>
>I disagree. The overall de
>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
therefor SQLite itse
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 features.
> >
> > That's I
"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 sockets,
with their "Clie
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, the
> 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 wrote:
> De
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
sqlite-users
23 matches
Mail list logo