> Hi > I would like some help to use SQLite as a general information resource > on my pc's. > I would like to use open source software but will consider proprietary > software. > Even better would be portable software, I could take all my photos and > the means of searching them on a disk drive.
> In fact I would like my first project to be a database of all my photos. > I think I need: > dbadmin tool, > db front end, > image viewer from BLOB to screen view. > Means of storing image in db. > To get me started could anyone suggest software tools please. > Intend to learn ADO, ColdFusion, > I program a little in DBA with msAccess, html, CSS, basic. > Have used C. Hello Scriptham, I think MyJSQLView can do this for you. Download and extract the folder contents to your hard drive. Install the Xerail SQLite JDBC to your Java Runtime lib/ext directory. Use default settings for SQLite login, specifying the database file. You can use the test sqliteType.sql file to create your own table with a id key, and blob type. Import the table to create the table in the database. Though MyJSQLView does not have a image viewer for the blob, pictures, I have seen some. You could modify the Java source to view them or make a plugin. If you need additional help let me know I may have some other projects that do have a image viewer that I could steer you to. danap MyJSQLView - myjsqlview.org SQLiteJDBC - xerial.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users