Name: Anonymous 2011-07-11 2:19
I seek your advice, fellow /prog/riders.
I've decided to create my own database software out of boredom. Before coding, I wrote this file describing how the information would be stored to disk:
http://pastebin.com/JHwvG0hK
The concern resides in the section of the file Titled "Allowed Data Lengths, Something Special about STRINGS and DOUBLES." The core of the problem is this: Each cell in the table is allowed a certain number of characters for storage as defined by each column label, and the cell must be that many characters long. When the data put into the table doesn't take up all of the room allowed to it, as many pipes ('|') as free space that exists are placed before the data. If the user has a pipe in an input string, then the database software simply escapes it.
So, when the user creates a new column, they specify a certain column size; however, as I plan now, the database software that I have yet to write will increase their size by a factor of 1.5 to allow for escape characters. Is there a better solution than this, /prog/?
I've decided to create my own database software out of boredom. Before coding, I wrote this file describing how the information would be stored to disk:
http://pastebin.com/JHwvG0hK
The concern resides in the section of the file Titled "Allowed Data Lengths, Something Special about STRINGS and DOUBLES." The core of the problem is this: Each cell in the table is allowed a certain number of characters for storage as defined by each column label, and the cell must be that many characters long. When the data put into the table doesn't take up all of the room allowed to it, as many pipes ('|') as free space that exists are placed before the data. If the user has a pipe in an input string, then the database software simply escapes it.
So, when the user creates a new column, they specify a certain column size; however, as I plan now, the database software that I have yet to write will increase their size by a factor of 1.5 to allow for escape characters. Is there a better solution than this, /prog/?