From: Kees Nuyt k.n...@zonnet.nl
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
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 powerful, fast,
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 ...g
I usually prefer keeping the business logic in the application
layer and leaving the DB
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 ...g
I usually prefer keeping the business logic in the
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 k.n...@zonnet.nl
Thursday, November 11, 2010 10:34:51 AM
Stored procedures don't enforce business rules by
themselves. Constraints and triggers do.
To enforce
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
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
From: Olaf Schmidt s...@online.de
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
On Thu, 11 Nov 2010 06:26:31 -0800 (PST), jeff archer
jarch...@yahoo.com wrote:
From: Olaf Schmidt s...@online.de
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
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 SQLite and therefor
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 closer to
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 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 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
On Thu, Nov 11, 2010 at 5:36 PM, Petite Abeille
petite.abei...@gmail.com 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.
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... ;-)
Nah,
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 anymore.
Nonsense
-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 anything,
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, then it
Tran Van Hoc tv...@vn.isb.co.jp 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,
Hey Andy Gibbs. Why your code isn't added into sqlite?
- Andy Gibbs andyg1...@hotmail.co.uk 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.
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
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
23 matches
Mail list logo