SQLite provides a great system which uses a binary data file (B-Tree) to store it's data while not requiring any running database server. I would like to be able to use the SQLite engine on other flat file binary data.
It would seem that there will need to be a few adjustments in column separator definitions, as well as other definitions, but most things should not need to be changed, such as this:
/* Input "x" is a sequence of unsigned characters that represent a
** big-endian integer. Return the equivalent native integer
#define ONE_BYTE_INT(x) ((i8)(x))
#define TWO_BYTE_INT(x) (256*(i8)((x))|(x))
#define THREE_BYTE_INT(x) (65536*(i8)((x))|((x)<<8)|(x))
#define FOUR_BYTE_UINT(x) (((u32)(x)<<24)|((x)<<16)|((x)<<8)|(x))
#define FOUR_BYTE_INT(x) (16777216*(i8)((x))|((x)<<16)|((x)<<8)|(x))
We may need to define what represents the delimiters on either side, but the calculations should all be the same.
Since we are supporting foreign data, we would need to be able to set some configuration differences such as whether to use big or little endian, external column headers and the data field delimiter, potentially offset and record length on a per file / table basis. These alterations should be abstracted from the existing code into one or two configuration files rather than needing to hunt through multiple locations that are simply labeled as places to update.
Anyone applying for this job should be prepared to show previous experience working in C and experience with parsing data files. Sample data files will be provided.
Final product should compile to be used within .NET application
20 freelancers están ofertando el promedio de $1283 para este trabajo
Hi there, I have checked the details I have rich experienced with C Programming, Database Development, Database Programming. Please initiate chat so we can discuss this job.
Hello, Dear Nice to meet you. I've read your post carefully. I'm DBMS expert. For example, MSSQL, MySQL, PostgreSQL, SQLite, MongoDB. Please discuss more details on chatting room. Regards. Gao M.
I have an experience of more than 17years in the field of technology. I have all the expertise that is required to complete this particular project. Look forward to discussing the projects in detail. Cheers.