[sqlite] Stored Procedures
Has there been any thought of implementing some kind of stored procedure feature for SQLite? Or does this feature exist in some other form, with another name? -- Mike Clark Twitter: @Cyberherbalist Blog: Cyberherbalist's Blog <http://www.cyberherbalist.co> - "Free will, though it makes evil possible, is also the only thing that makes possible any love or goodness or joy worth having." *- C. S. Lewis* ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] About storage of large amounts of image data
Hi List! I'm developing a project that deals with image files and am considering storing all the images in the SQLite database itself, rather than (or in addition to) the file system. Since the prospective users will probably be dealing with hundreds of gigabytes in their use of the project, I am wondering if this is an effective or efficient use of SQLite -- or safe, because of the risk of data corruption. I know the documentation says that SQLite can handle up to 140 TB (do we know of anyone who is doing this?), so hundreds of gigs is clearly doable. Is it advisable, however? (Sent this about 2 wks ago, but it never posted to the list and no moderator response either). -- Mike Clark Twitter: @Cyberherbalist Blog: Cyberherbalist's Blog <http://www.cyberherbalist.co> - "Free will, though it makes evil possible, is also the only thing that makes possible any love or goodness or joy worth having." *- C. S. Lewis* ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Resetting autoincrement
I found this on Stackoverflow: DELETE FROM your_table;DELETE FROM sqlite_sequence WHERE name = 'your_table'; But when I try to run it I get "table not found". Has this been superseded? ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Connection open to nonexistent database succeeds! WTF?
I've written the following code for the ADO.NET client for SQLite, and the
odd thing I've noticed is that even when the connection string passed to it
does not refer to a file that exists, the code returns true! Does SQLite
not actually check for a valid connection until you try to perform a data
operation? The result I get when trying to insert a row to a table in a
nonexistent database is "Sql logic error" "table doesn't exist" -- no
kidding, because there's no such database file!
Is this expected behavior?
public bool ConnectionOK(string ConnString)
{
bool result = true;
SQLiteConnection sqlConnection;
if (DbPath.Length > 0)
{
try
{
sqlConnection = new SQLiteConnection(ConnString);
sqlConnection.Open();
if (sqlConnection.State == ConnectionState.Open)
{
sqlConnection.Close();
}
}
catch (Exception ex)
{
result = false;
}
}
return result;
}
--
Mike Clark <http://www.mikeclark.co>
Twitter: @Cyberherbalist
Blog: Cyberherbalist's Blog <http://www.cyberherbalist.co>
-
"Free will, though it makes evil possible, is also the only thing that
makes possible any love or goodness or joy worth having."
*- C. S. Lewis*
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Resources for learning SQLite
I suspect there are already threads on this, so apologies for the potential duplicate... I'm a long-time C# developer who has used Sql Server for decades, but I'm just getting started with SQLite. Does anyone have any recommendations for books or online resources? I'm particularly interested in resources that use C#. I've been working with "Using SQLite" by Jay A. Kreibich, and it's very useful, but if there's something more advanced I'd love to know about it. Thanks! -- Mike Clark <http://www.mikeclark.co> Twitter: @Cyberherbalist Blog: Cyberherbalist's Blog <http://www.cyberherbalist.co> - "Free will, though it makes evil possible, is also the only thing that makes possible any love or goodness or joy worth having." *- C. S. Lewis* ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
