SQLite

From Seeds of the Word, the encyclopedia of the influence of the Gospel on culture
Revision as of 17:14, September 13, 2021 by Johnrdorazio (talk | contribs)
SQLite
Developer(s)D. Richard Hipp
Initial release17 August 2000;
23 years ago
 (2000-08-17)
Written inC
Operating systemCross-platform
Size699 KiB
TypeRDBMS (embedded)
LicensePublic domain[1]
SQLite Database File Format
Filename extension
.sqlite3, .sqlite, .db
Internet media typeapplication/vnd.sqlite3[2]
Magic number53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 (zero-terminated ASCII "SQLite format 3")
Initial release2004-06-18
Open format?yes (Public Domain)
Websitesqlite.org/fileformat2.html

SQLite (/ˌɛsˌkjuːˌɛlˈt/,[3][4] /ˈskwəˌlt/[5]) is a relational database management system (RDBMS) contained in a C library. In contrast to many other database management systems, SQLite is not a client–server database engine. Rather, it is embedded into the end program.

Code of Ethics

The SQLite team published a document Code of Ethics, also known as "Code of Conduct", as a reference for developers, in which the founder and the developers participating in the project pledged to govern their interactions with each other, with their clients, and with the larger SQLite community, taking inspiration from chapter 4 of the Rule of Saint Benedict.

The spirit of Saint Benedict's Rule is summed up in the motto of the Benedictine Confederation: pax ("peace") and the traditional ora et labora ("pray and work"). Compared to other precepts, the Rule provides a moderate path between individual zeal and formulaic institutionalism; because of this middle ground it has been widely popular. Benedict's concerns were the needs of monks in a community environment: namely, to establish due order, to foster an understanding of the relational nature of human beings, and to provide a spiritual father to support and strengthen the individual's ascetic effort and the spiritual growth that is required for the fulfillment of the human vocation, theosis.

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.

— SQLite Code of Ethics, Purpose, https://sqlite.org/codeofethics.html

Number 3 of the SQLite Code of Ethics states the "instruments of good works" in foresaid chapter of the Rule of Saint Benedict:

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

This choice of Christian ethics as a basis for the SQLite community brought some public scrutiny upon the SQLite founder and the SQLite community.[6][7][8]

Source code

Each of the files that comprise the source code of the SQLite project, together with the free software copyright, contains a blessing:

** The author disclaims copyright to this source code.  In place of
** a legal notice, here is a blessing:
**
**    May you do good and not evil.
**    May you find forgiveness for yourself and forgive others.
**    May you share freely, never taking more than you give.
  1. "SQLite Copyright". sqlite.org. Retrieved May 17, 2010.
  2. "SQLite database file format media type at IANA". Internet Assigned Numbers Authority. IANA. Retrieved 2019-03-08.
  3. "Why SQLite succeeded as a database — Richard Hipp, creator of SQLite". The Changelog. Episode 201. Event occurs at 00:17:25. How do I pronounce the name of the product? I say S-Q-L-ite, like a mineral.
  4. D. Richard Hipp (presenter) (May 31, 2006). An Introduction to SQLite (video). Google Inc. Event occurs at 00:01:14. Retrieved March 23, 2010. [...] ess-kju-ellite [...]
  5. D. Richard Hipp (presenter) (May 31, 2006). An Introduction to SQLite. Google Inc. Event occurs at 00:48:15. Retrieved March 23, 2010. [...] sequelite [...]
  6. https://www.theregister.com/2018/10/22/sqlite_code_of_conduct/
  7. https://pjmedia.com/news-and-politics/paula-bolyard/2018/10/24/tech-community-outraged-after-sqlite-founder-adopts-christian-code-of-conduct-n61746
  8. https://archive.fo/qivKH