- Introduction
- License
- History
- Compilation & Hosting
- Configuration File
- Modules:
- FAQ
- Links
- Credits
|
PSP - SDS File Format Description
In short, SDS file looks like this (on this scheme <sequence> means some sequence, // is a describing comment):
[ Simple Data Storage File ]
<number of fields>
<last insert id>
<number of rows>
// Empty line
<columns description>
<column name>
<column type>
</columns description>
//Empty line
<data>
<row0 cell0>
<row0 cell1>
<row0 cell2>
<...>
<row0 cellN>
<row1 cell0>
<row1 cell1>
<row1 cell2>
<...>
<row1 cellN>
<rowN cell0>
<rowN cell1>
<rowN cell2>
<...>
<rowN cellN>
</data>
Lines are separated with end-of-line characters. You can separate whole table into 3 parts: header, column info and data. Header data is stored as is. Column data contains several pairs of rows. First row of each pair is SDS-encoded field name, second is number standing for column data types. Numbers and types are:
1 = VARCHAR/TEXT/STRING (string data with unlimited length)
2 = INT/LONGINT (4-byte integer)
3 = FLOAT/REAL/DOUBLE (8-byte double precision float)
4 = DATE (date in YYYY-MM-DD format)
5 = TIME (time in HH:MM:SS format)
6 = DATETIME (date and time in YYYY-MM-DD HH:MM:SS format)
Data is SDS-encoded. The only difference from plain text is that CR (caret return) and LF (line finish) characters are replaced with #SDS_CHAR_CR# and #SDS_CHAR_LF#. If you want to learn more about SDS file format, just run a few queries and open table file with any text editor.
|