On 7/24/06, sandhya <[EMAIL PROTECTED]> wrote:
Hi, Can anybody help me. Is there any possibility to import files from the local file system and storing in sqlite DB.And Is there any export option just to check whether
The file system is designed to manipulate files. A database is designed to search through data. Most people that ask this question aren't using the tools for what they were designed for. They usually find it's harder and doesn't work very well. Unless there's a good reason to put files in the database it's best not to. Are you actually going to search the contents of the file using select? Instead store the path to the file in the database. Then you can use all the tools that already exist for dealing with files instead of having to write a bunch of file/blob handling code. -- SqliteImporter and SqliteReplicator: Command line utilities for Sqlite http://www.reddawn.net/~jsprenkl/Sqlite Cthulhu Bucks! http://www.cthulhubucks.com