在Sqlite中保存存储过程? [英] Cresting Stored Procedures in Sqlite?

问题描述

hai朋友::

谁能说出我们是否能够在Sqlite中创建存储过程?如果是，则意味着我们如何创建该存储过程?举一个简单的例子吗?

hai Friends::

Can any body tell can we able to create Stored Procedures in Sqlite?if yes means how we create ?give one simple example?

推荐答案

不，我们不能(来自SQLite网站[ ^ ]):

Nope, we can''t (from SQLite web site [^]):

数据库引擎的简单性可能是强项，也可能是弱项，这取决于您要尝试执行的操作. 为了实现简单性，SQLite必须牺牲某些人认为有用的其他特征，例如高并发性，细粒度的访问控制，丰富的内置函数集，存储过程 ，深奥的SQL语言功能，XML和/或Java扩展，千兆字节或PB的可伸缩性等.如果您需要这些功能中的某些功能，而又不介意它们带来的复杂性，那么SQLite可能不是您的数据库. SQLite并非旨在成为企业数据库引擎.它并非旨在与Oracle或PostgreSQL竞争.

Simplicity in a database engine can be either a strength or a weakness, depending on what you are trying to do. In order to achieve simplicity, SQLite has had to sacrifice other characteristics that some people find useful, such as high concurrency, fine-grained access control, a rich set of built-in functions, stored procedures, esoteric SQL language features, XML and/or Java extensions, tera- or peta-byte scalability, and so forth. If you need some of these features and do not mind the added complexity that they bring, then SQLite is probably not the database for you. SQLite is not intended to be an enterprise database engine. It is not designed to compete with Oracle or PostgreSQL.

:)

这篇关于在Sqlite中保存存储过程?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！