Tips and Traps¶

1. Do NOT use SQLite3 on network filesystems (NFS, SAMBA, etc).

2. .schema show create statement of a table

3. You can force query to keep the original order of rows by applying order by rowid.

4. SQLite3 supports full-text search by the FTS5 extension (since 3.9.0). It is suggested that you use the porter

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

Version Handling¶

Comments¶

1. It is suggested that you use the requests module instead of urllib unless you want to have minimal 3rd-party dependencies.

2. Response.raise_for_status is a convenient method for raising an exception corresponding to the HTTP status code.

References¶

http://www.legendu.net/misc/blog/python-download-file/

https://stackabuse.com/download-files-with-python/

https://stackoverflow.com/questions/22676/how-do-i-download-a-file-over-http-using-python

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

Tips and Traps¶

1. There are at least 3 packages (packaing, python-semver and) in Python which can help you work with semantic versions.

packaging¶

Please refer to packaging for more details.

python-semver¶

python-semanticversion¶