Menu

Home

Russell

Welcome to the Wiki for pyDaSSQLiteMan. This is a project designed to run on the Python programming language.

Unless you are downlaoding the prebuilt Windows exectable, you will need the following knowledge/tools before you start...
1. Go to http://www.python.org/ and download a version of Python. I prefer to work with a version greater or equal to Python 3, but you will at least need 2.6 or greater.

  1. Download the files from the download button below, and unzip them somewhere.

  2. Having installed Python, you run the file called pyDaSSQLiteMan.pyw, that you just unzipped. Hopefully it will work fine and the rest should be easy to understand. On Linux the pyw file may not be associated with python and you might need to do some extra work to get it to run in Python. Also I'd recommend Python 3 as the language to run it on.

  3. It uses a database system called SQLite that is included as part of python. You can check out SQLite from it's homepage http://www.sqlite.org/. Different versions of Python, and Python on different OS's are compiled with different options. Not all features may work on all installations. You can only try. I know that on Windows Python's SQLite install doesn't contain the RTree indexing options.

  4. A CSV (Comma Separated Values) file is a text file that contains data separated usually by commas (though can be any character really). Exporting a spreadsheet to CSV format is an easy way to make one. CSV files don't always end in the .csv extension, they can be .txt, and I've even seen .psv (Pipe Delimited
    Values).

Please note that currently CSV files with Unicode encoding are not supported. According to the official documentation located at http://docs.python.org/2/library/csv.html the csv module doesn't provide good support for any other coding than UTF-8 and it is recommended that only this is used. Attempting to import a CSV file with Unicode causes an error in the import.

Please use the "Browse Pages" button to look at the release notes.

Project Admins:

Current Release Notes [Release 2.2 Notes]
Current Help Page [General Help]


Related

Wiki: General Help
Wiki: Release 2.2 Notes