{"id":9649,"date":"2022-09-22T21:00:00","date_gmt":"2022-09-22T19:00:00","guid":{"rendered":"https:\/\/monodes.com\/predaelli\/?p=9649"},"modified":"2022-09-22T09:06:30","modified_gmt":"2022-09-22T07:06:30","slug":"sqlite-code-of-ethics-is-a-masterpiece","status":"publish","type":"post","link":"https:\/\/monodes.com\/predaelli\/2022\/09\/22\/sqlite-code-of-ethics-is-a-masterpiece\/","title":{"rendered":"SQLite Code of Ethics is a masterpiece"},"content":{"rendered":"\n

Everyone love SQLite the small, efficient, embeddable SQL server that has been used everywhere.<\/p>\n\n\n\n

It is truly a masterpiece.<\/p>\n\n\n\n

Yet the real gem is its Code of Ethics<\/a><\/p>\n\n\n\n\n\n\n\n

Here I confirm what I wrote in 2018<\/a> and in 2021<\/a>: I still think it is a code I can try to follow.<\/p>\n\n\n\n

I’m copying it at page 2, in the unlucky case it goes offline. Luckily it has been around for quite a longer time than the life of SQLite so you will keep finding it elsewhere under the name of “The Rule of St. Benedict<\/a>“<\/p>\n\n\n\n\n\n\n

\n
\n
\n
Code Of Ethics<\/div>\n<\/div>\n

1. History<\/h1>\n

This document was originally called a “Code of Conduct” and was created for the purpose of filling in a box on “supplier registration” forms submitted to the SQLite developers by some clients. However, we subsequently learned that “Code of Conduct” has a very specific and almost sacred meaning to some readers, a meaning to which this document does not conform [1]<\/a>[2]<\/a>[3]<\/a>. Therefore this document was renamed to “Code of Ethics”, as we are encouraged to do by rule 71 in particular and also rules 2, 8, 9, 18, 19, 30, 66, and in the spirit of all the rest.<\/p>\n

This document continues to be used for its original purpose – providing a reference to fill in the “code of conduct” box on supplier registration forms.<\/p>\n

2. Purpose<\/h1>\n

The founder of SQLite, and all of the current developers at the time when this document was composed, have pledged to govern their interactions with each other, with their clients, and with the larger SQLite user community in accordance with the “instruments of good works” from chapter 4 of The Rule of St. Benedict<\/a> (hereafter: “The Rule”). This code of ethics has proven its mettle in thousands of diverse communities for over 1,500 years, and has served as a baseline for many civil law codes since the time of Charlemagne.<\/p>\n

2.1. Scope of Application<\/h2>\n

No one is required to follow The Rule, to know The Rule, or even to think that The Rule is a good idea. The Founder of SQLite believes that anyone who follows The Rule will live a happier and more productive life, but individuals are free to dispute or ignore that advice if they wish.<\/p>\n

The founder of SQLite and all current developers have pledged to follow the spirit of The Rule to the best of their ability. They view The Rule as their promise to all SQLite users of how the developers are expected to behave. This is a one-way promise, or covenant. In other words, the developers are saying: “We will treat you this way regardless of how you treat us.”<\/p>\n

3. The Rule<\/h1>\n<\/a>\n
    \n
  1. First of all, love the Lord God with your whole heart, your whole soul, and your whole strength. <\/a><\/li>\n
  2. Then, love your neighbor as yourself. <\/a><\/li>\n
  3. Do not murder. <\/a><\/li>\n
  4. Do not commit adultery. <\/a><\/li>\n
  5. Do not steal. <\/a><\/li>\n
  6. Do not covet. <\/a><\/li>\n
  7. Do not bear false witness. <\/a><\/li>\n
  8. Honor all people. <\/a><\/li>\n
  9. Do not do to another what you would not have done to yourself. <\/a><\/li>\n
  10. Deny oneself in order to follow Christ. <\/a><\/li>\n
  11. Chastise the body. <\/a><\/li>\n
  12. Do not become attached to pleasures. <\/a><\/li>\n
  13. Love fasting. <\/a><\/li>\n
  14. Relieve the poor. <\/a><\/li>\n
  15. Clothe the naked. <\/a><\/li>\n
  16. Visit the sick. <\/a><\/li>\n
  17. Bury the dead. <\/a><\/li>\n
  18. Be a help in times of trouble. <\/a><\/li>\n
  19. Console the sorrowing. <\/a><\/li>\n
  20. Be a stranger to the world’s ways. <\/a><\/li>\n
  21. Prefer nothing more than the love of Christ. <\/a><\/li>\n
  22. Do not give way to anger. <\/a><\/li>\n
  23. Do not nurse a grudge. <\/a><\/li>\n
  24. Do not entertain deceit in your heart. <\/a><\/li>\n
  25. Do not give a false peace. <\/a><\/li>\n
  26. Do not forsake charity. <\/a><\/li>\n
  27. Do not swear, for fear of perjuring yourself. <\/a><\/li>\n
  28. Utter only truth from heart and mouth. <\/a><\/li>\n
  29. Do not return evil for evil. <\/a><\/li>\n
  30. Do no wrong to anyone, and bear patiently wrongs done to yourself. <\/a><\/li>\n
  31. Love your enemies. <\/a><\/li>\n
  32. Do not curse those who curse you, but rather bless them. <\/a><\/li>\n
  33. Bear persecution for justice’s sake. <\/a><\/li>\n
  34. Be not proud. <\/a><\/li>\n
  35. Be not addicted to wine. <\/a><\/li>\n
  36. Be not a great eater. <\/a><\/li>\n
  37. Be not drowsy. <\/a><\/li>\n
  38. Be not lazy. <\/a><\/li>\n
  39. Be not a grumbler. <\/a><\/li>\n
  40. Be not a detractor. <\/a><\/li>\n
  41. Put your hope in God. <\/a><\/li>\n
  42. Attribute to God, and not to self, whatever good you see in yourself. <\/a><\/li>\n
  43. Recognize always that evil is your own doing, and to impute it to yourself. <\/a><\/li>\n
  44. Fear the Day of Judgment. <\/a><\/li>\n
  45. Be in dread of hell. <\/a><\/li>\n
  46. Desire eternal life with all the passion of the spirit. <\/a><\/li>\n
  47. Keep death daily before your eyes. <\/a><\/li>\n
  48. Keep constant guard over the actions of your life. <\/a><\/li>\n
  49. Know for certain that God sees you everywhere. <\/a><\/li>\n
  50. When wrongful thoughts come into your heart, dash them against Christ immediately. <\/a><\/li>\n
  51. Disclose wrongful thoughts to your spiritual mentor. <\/a><\/li>\n
  52. Guard your tongue against evil and depraved speech. <\/a><\/li>\n
  53. Do not love much talking. <\/a><\/li>\n
  54. Speak no useless words or words that move to laughter. <\/a><\/li>\n
  55. Do not love much or boisterous laughter. <\/a><\/li>\n
  56. Listen willingly to holy reading. <\/a><\/li>\n
  57. Devote yourself frequently to prayer. <\/a><\/li>\n
  58. Daily in your prayers, with tears and sighs, confess your past sins to God, and amend them for the future. <\/a><\/li>\n
  59. Fulfill not the desires of the flesh; hate your own will. <\/a><\/li>\n
  60. Obey in all things the commands of those whom God has placed in authority over you even though they (which God forbid) should act otherwise, mindful of the Lord’s precept, “Do what they say, but not what they do.” <\/a><\/li>\n
  61. Do not wish to be called holy before one is holy; but first to be holy, that you may be truly so called. <\/a><\/li>\n
  62. Fulfill God’s commandments daily in your deeds. <\/a><\/li>\n
  63. Love chastity. <\/a><\/li>\n
  64. Hate no one. <\/a><\/li>\n
  65. Be not jealous, nor harbor envy. <\/a><\/li>\n
  66. Do not love quarreling. <\/a><\/li>\n
  67. Shun arrogance. <\/a><\/li>\n
  68. Respect your seniors. <\/a><\/li>\n
  69. Love your juniors. <\/a><\/li>\n
  70. Pray for your enemies in the love of Christ. <\/a><\/li>\n
  71. Make peace with your adversary before the sun sets. <\/a><\/li>\n
  72. Never despair of God’s mercy.<\/li>\n<\/ol>\n<\/div>\n<\/blockquote>","protected":false},"excerpt":{"rendered":"

    Everyone love SQLite the small, efficient, embeddable SQL server that has been used everywhere. It is truly a masterpiece. Yet the real gem is its Code of Ethics<\/p>\n

    Read more →<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"activitypub_content_warning":"","activitypub_content_visibility":"","activitypub_max_image_attachments":4,"activitypub_interaction_policy_quote":"anyone","activitypub_status":"","footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[171],"tags":[],"class_list":["post-9649","post","type-post","status-publish","format-standard","hentry","category-ethics"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p6daft-2vD","jetpack-related-posts":[{"id":4760,"url":"https:\/\/monodes.com\/predaelli\/2018\/10\/23\/a-masterpiece\/","url_meta":{"origin":9649,"position":0},"title":"A masterpiece","author":"Paolo Redaelli","date":"2018-10-23","format":false,"excerpt":"SQLIte new Code Of Conduct is a masterpiece. Code Of Conduct 1. Overview Having been encouraged by clients to adopt a written code of conduct, the SQLite developers elected to govern their interactions with each other, with their clients, and with the larger SQLite user community in accordance with the\u2026","rel":"","context":"In "Ethics"","block_context":{"text":"Ethics","link":"https:\/\/monodes.com\/predaelli\/category\/ethics\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":8332,"url":"https:\/\/monodes.com\/predaelli\/2021\/04\/06\/its-still-a-masterpiece\/","url_meta":{"origin":9649,"position":1},"title":"It’s still a masterpiece","author":"Paolo Redaelli","date":"2021-04-06","format":false,"excerpt":"I confirm what I wrote in 2018: I still think that the document once known as SQLIte Code Of Conduct is a masterpiece. These days at the original address you can read this notice: Code of Conduct Due to concerns raised by readers, this document has been removed. The separate\u2026","rel":"","context":"In "Senza categoria"","block_context":{"text":"Senza categoria","link":"https:\/\/monodes.com\/predaelli\/category\/senza-categoria\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1165,"url":"https:\/\/monodes.com\/predaelli\/2016\/03\/15\/ise-eiffel-sqlite\/","url_meta":{"origin":9649,"position":2},"title":"(ISE) Eiffel SQLite","author":"Paolo Redaelli","date":"2016-03-15","format":false,"excerpt":"According to eiffelroom ISE has SQLite wrappers. Ok, the linked website (http:\/\/esqlite.origo.ethz.ch\/) is down but it must be noted that Jocelyn Fiat wrote it almost seven years ago. Meanwhile Eiffel Studio got some SQLite wrappers: https:\/\/svn.eiffel.com\/eiffelstudio\/trunk\/Src\/unstable\/library\/persistency\/database\/sqlite3\/sqlite_statement.e I do like those copyright notes at the end: they released under GPLv2! And\u2026","rel":"","context":"In "Eiffel"","block_context":{"text":"Eiffel","link":"https:\/\/monodes.com\/predaelli\/category\/eiffel\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":10679,"url":"https:\/\/monodes.com\/predaelli\/2023\/08\/09\/sqledge\/","url_meta":{"origin":9649,"position":3},"title":"SQLedge","author":"Paolo Redaelli","date":"2023-08-09","format":"link","excerpt":"SQLedge: Replicate Postgres to SQLite on the Edge - https:\/\/github.com\/zknill\/sqledge","rel":"","context":"In "Software"","block_context":{"text":"Software","link":"https:\/\/monodes.com\/predaelli\/category\/software\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1057,"url":"https:\/\/monodes.com\/predaelli\/2016\/03\/01\/1057\/","url_meta":{"origin":9649,"position":4},"title":"I can't believe I started\u2026","author":"Paolo Redaelli","date":"2016-03-01","format":"status","excerpt":"I can't believe I started Sqlite wrappers TEN years ago.... Tempus fugit","rel":"","context":"In "Eiffel"","block_context":{"text":"Eiffel","link":"https:\/\/monodes.com\/predaelli\/category\/eiffel\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":11513,"url":"https:\/\/monodes.com\/predaelli\/2024\/03\/24\/duckdb-as-the-new-jq\/","url_meta":{"origin":9649,"position":5},"title":"DuckDB as the New jq","author":"Paolo Redaelli","date":"2024-03-24","format":"quote","excerpt":"Recently, I\u2019ve been interested in the DuckDB project (like a SQLite geared towards data applications). And one of the amazing features is that it has many data importers included without requiring extra dependencies. This means it can natively read and parse JSON as a database table, among many other formats.\u2026","rel":"","context":"In "Software Libero"","block_context":{"text":"Software Libero","link":"https:\/\/monodes.com\/predaelli\/category\/software\/software-libero\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/posts\/9649","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/comments?post=9649"}],"version-history":[{"count":0,"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/posts\/9649\/revisions"}],"wp:attachment":[{"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/media?parent=9649"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/categories?post=9649"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/tags?post=9649"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}