-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 05/06/2010 04:55 PM, Matt Young wrote: > It could be done and only adds a few bytes to the binary since the > code would simply check the 'ignore on import setting of .mode' before > taking error action for missing or too many columns.
The issue isn't binary size but code size and complexity. Every path through the code needs to be understood and ideally tested in isolation as well as combination. And once there you can't remove it if it turns out to be a mistake as it will turn out to break compatibility for everyone else. ie this isn't about adding 20 lines of code, 2 paragraphs of documentation and 200 lines of test code, but also about maintaining those in perpetuity including long after you no longer need it. The reality is that CSV is a well known reasonable standard and that is what the SQLite shell and many other programs operate on mostly successfully. You would find it far more useful to use something to convert whatever you have into the correct format since that can then be used by all sorts of other programs too (eg other databases, spreadsheets, libraries such as csv module in Python)[*] > I will look at the source That is also another approach and a huge benefit of free (as in freedom) software. You have the right to adapt it, modify it, redistribute it, sell it, ask others to do these things for you etc as you see fit. About the only thing you can't do is call the result SQLite as that violates the trademark (and is also unethical). [*] There has been a lot of debate over the decades as to how lenient you should be in accepting input that isn't 100% conformant. The consensus has always been that what is produced should be strictly correct. See Postel's Law which argues in favour of leniency for what is accepted, and numerous counterclaims that this allows for and spreads systems that do not implement the standards correctly. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkvjhykACgkQmOOfHg372QS/sgCggxY5aOufE2tkt9ubDT+DdIy3 0zcAoJSq7QK3BV8Armoj0tmTDrHf0Pua =y5bv -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
