RitmarkFS: FileSystem Storage Engine for MySQL  
 

  		• Main
  		• Project News
  		• Documentation
  		• Mailing Lists
  		• ChangeLogs
  		• Report a Bug
  		• Downloads
  		• Contacts



    Other projects

       Query Optimization Tool


    See also

       Ritmark Remote File Tool


    site last updated: November 21, 2006
       Ritmark Remote File Tool
    Description

    This tool is a client for MySQL server with RitmarkFS installed. It is an alternative to FTP access. The main advantage of this tool over FTP is SQL-based content filtering on the server side.

    Typcally you might want to use this tool in the following cases:

    1. You want to perform content-based file filtering before you really download files. For example you have a large file set and need to download only files that contain certain words.

    2. You want to associate some custom attributes with you files, and perform attribute-based filtering. E.g. by author or by project.

    Installation

    Go to the RitmarkFS download page and get the latest ritmark-rft-x.x.zip or ritmark-rft-x.x.tar.gz package. Unpack it somewhere.

    Startup

    The tool is archived in a jar file so to start it you usually do: 
    shell> java -jar ritmark-rft-0.2.jar
    this should work on at least Windows, Linux and Mac.

    Usage

    Tool usage is very simple. There's one main window. First you fill connection data such as server host, port, user name and password. Next you enter filtering information which is used to make up a SELECT query to the server. When you press "QUERY" button the query is executed and file list is returned. This works very fast as there's no data download is performed. When you see the list you can visually check it and possibly tune-up your filter and re-execute the query. Finally you press "DOWNLOAD THE LIST" button and the files from the list are being downloaded to the local directory specified by "LOCAL STORAGE PATH". The directory will be autocreated if needed.

    Platforms

    The tool is written in Java and requires J2SE runtime 1.4.x or higher, which should not be a problem for most systems. The tool was tested on WinXP SP2, SuSE Linux 10.0, Mac OS X 10.4.8.

    Building from sources

    You can build the tool from sources using Apache Ant. MySQL Java connector library will be required.

    Limitations of the tool

    1. You need to install a custom version of the MySQL server (compiled with RitmarkFS support - download here).

    2. If tool operation is interrupted you have to restart as you do for any SQL query. So transferring large files over an unstable connection could be a problem.