Jump to content

SQLite: Difference between revisions

No edit summary
 
(58 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{short description|Serverless relational database management system (RDBMS)}}{{Infobox software
{{short description|Serverless relational database management system (RDBMS)}}
{{Infobox software
| logo                  = SQLite370.svg
| logo                  = SQLite370.svg
| logo size              = 220px
| logo size              = 220px
Line 47: Line 48:
'''SQLite''' ({{IPAc-en|ˌ|ɛ|s|ˌ|k|juː|ˌ|ɛ|l|ˈ|aɪ|t}},<ref>{{cite episode |series=The Changelog |number=201 |title=Why SQLite succeeded as a database — Richard Hipp, creator of SQLite |time=00:17:25 |url=https://changelog.com/podcast/201 |quote=How do I pronounce the name of the product? I say S-Q-L-ite, like a mineral.}}</ref><ref>{{cite video | people = [[wikipedia:D. Richard Hipp|D. Richard Hipp]] (presenter) | date = May 31, 2006 | title = An Introduction to SQLite | url = https://www.youtube.com/watch?v=f428dSRkTs4#t=1m14s | format = video<!-- HTML5 WebM video is available --> | publisher = Google Inc. | access-date =March 23, 2010 | time = 00:01:14 | quote = [...] ess-kju-ellite [...] }}</ref> {{IPAc-en|ˈ|s|iː|k|w|ə|,|l|aɪ|t}}<ref>{{cite video | people = [[wikipedia:D. Richard Hipp|D. Richard Hipp]] (presenter) | date = May 31, 2006 | title = An Introduction to SQLite | url = https://www.youtube.com/watch?v=f428dSRkTs4#t=48m15s | format = <!-- HTML5 WebM video is available --> | publisher = Google Inc. | access-date =March 23, 2010 | time = 00:48:15 | quote = [...] sequelite [...] }}</ref>) is a [[wikipedia:relational database management system|relational database management system]] (RDBMS) contained in a [[wikipedia:C (programming language)|C]] [[wikipedia:library (computer science)|library]]. In contrast to many other database management systems, SQLite is not a [[wikipedia:client–server|client–server]] database engine. Rather, it is embedded into the end program.
'''SQLite''' ({{IPAc-en|ˌ|ɛ|s|ˌ|k|juː|ˌ|ɛ|l|ˈ|aɪ|t}},<ref>{{cite episode |series=The Changelog |number=201 |title=Why SQLite succeeded as a database — Richard Hipp, creator of SQLite |time=00:17:25 |url=https://changelog.com/podcast/201 |quote=How do I pronounce the name of the product? I say S-Q-L-ite, like a mineral.}}</ref><ref>{{cite video | people = [[wikipedia:D. Richard Hipp|D. Richard Hipp]] (presenter) | date = May 31, 2006 | title = An Introduction to SQLite | url = https://www.youtube.com/watch?v=f428dSRkTs4#t=1m14s | format = video<!-- HTML5 WebM video is available --> | publisher = Google Inc. | access-date =March 23, 2010 | time = 00:01:14 | quote = [...] ess-kju-ellite [...] }}</ref> {{IPAc-en|ˈ|s|iː|k|w|ə|,|l|aɪ|t}}<ref>{{cite video | people = [[wikipedia:D. Richard Hipp|D. Richard Hipp]] (presenter) | date = May 31, 2006 | title = An Introduction to SQLite | url = https://www.youtube.com/watch?v=f428dSRkTs4#t=48m15s | format = <!-- HTML5 WebM video is available --> | publisher = Google Inc. | access-date =March 23, 2010 | time = 00:48:15 | quote = [...] sequelite [...] }}</ref>) is a [[wikipedia:relational database management system|relational database management system]] (RDBMS) contained in a [[wikipedia:C (programming language)|C]] [[wikipedia:library (computer science)|library]]. In contrast to many other database management systems, SQLite is not a [[wikipedia:client–server|client–server]] database engine. Rather, it is embedded into the end program.


== Code of Ethics ==
The SQLite team published a document [https://sqlite.org/codeofethics.html 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 [[wikipedia:Rule of Saint Benedict|Rule of Saint Benedict]].
The SQLite team published a document [https://sqlite.org/codeofethics.html 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 [[wikipedia:Rule of Saint Benedict|Rule of Saint Benedict]].


Line 128: Line 130:
# Never despair of God's mercy.
# 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.<ref>https://www.theregister.com/2018/10/22/sqlite_code_of_conduct/</ref><ref>https://pjmedia.com/news-and-politics/paula-bolyard/2018/10/24/tech-community-outraged-after-sqlite-founder-adopts-christian-code-of-conduct-n61746</ref><ref>https://archive.fo/qivKH</ref>
== Source code ==
Each of the files that comprise the source code of the SQLite project, together with the free software copyright, contains a blessing:
{{Quote|text=<syntaxhighlight lang="C">
/*
** 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.
</syntaxhighlight>|author=SQLite source code|title=|source=https://sqlite.org/src/dir?name=src&ci=trunk}}
== Biblical references ==
The Rule of St. Benedict is based on a number of Scripture texts, the first of which are the [[wikipedia:Ten Commandments|Ten Commandments]] and the [[wikipedia:Great Commandment|Great Commandment]].
=== The Greatest Commandment (rules 1-2) ===
{{Bible quote|ref=Matthew 22:37-39|inline=false}}
See also the other two synoptic gospels, {{Bible quote|ref=Mark 12:28-31}} and {{Bible quote|ref=Luke 10:25-28}}.
Jesus is quoting these two Old Testament passages:
==== The Greatest Commandment part 1: Love of God (rule 1) ====
{{Bible quote|ref=Dt 6:5|inline=false}}
==== The Greatest Commandment part 2: Love of neighbour (rule 2) ====
{{Bible quote|ref=Leviticus 19:18|inline=false}}
=== The Ten Commandments (rules 3-7) ===
{{Bible quote|ref=Exodus 20:2-17|inline=false}}
See also {{Bible quote|ref=Deuteronomy 5:6–21}}.
=== Honor all people (rule 8) ===
{{Bible quote|ref=1 Peter 2:17|inline=false}}
=== The Golden rule (rule 9) ===
[[wikipedia:Hillel the Elder|Hillel the Elder]] (c. 110 BCE – 10 CE),<ref>[http://www.jewishencyclopedia.com/view.jsp?artid=730&letter=H Jewish Encyclopedia: Hillel]: "His activity of forty years is perhaps historical; and since it began, according to a trustworthy tradition (Shab. 15a), one hundred years before the destruction of Jerusalem, it must have covered the period 30 BCE–10 CE<!--B.C. in the original-->"</ref> used the aforementioned verse of '''Leviticus 19:18''' as a most important message of the [[wikipedia:Torah|Torah]] for his teachings. Once, he was challenged by a gentile who asked to be converted under the condition that the Torah be explained to him while he stood on one foot. Hillel accepted him as a candidate for [[wikipedia:conversion to Judaism|conversion to Judaism]] but, drawing on Leviticus 19:18, briefed the man:
{{quote|What is hateful to you, do not do to your fellow: this is the whole Torah; the rest is the explanation; go and learn.|[[wikipedia:Babylonian Talmud|Babylonian Talmud]]<ref>{{sourcetext|source=Babylonian Talmud|book=Shabbath|chapter=folio|verse=31a}}</ref>}}
Hillel recognized brotherly love as the fundamental principle of Jewish ethics. [[wikipedia:Rabbi Akiva|Rabbi Akiva]] agreed, while [[wikipedia:Simeon ben Azzai|Simeon ben Azzai]] suggested that the principle of love must have its foundation in Genesis chapter 1, which teaches that all men are the offspring of Adam, who was made in the image of God.<ref> ([[wikipedia:Sifra|Sifra]], Ḳedoshim, iv.; Yer. Ned. ix. 41c; [[wikipedia:Genesis Rabba|Genesis Rabba]] 24</ref><ref name="a" /> According to [[wikipedia:Adam in rabbinic literature|Jewish rabbinic literature]], the first man [[wikipedia:Adam|Adam]] represents the ''unity of mankind''. This is echoed in the modern preamble of the [[wikipedia:Universal Declaration of Human Rights#Preamble|Universal Declaration of Human Rights]].<ref>{{cite web|url=http://www.sefaria.org/Mishnah_Sanhedrin.4?lang=en|title=Mishnah Seder Nezikin Sanhedrin 4.5|publisher=sefaria.org|access-date=17 July 2016}}</ref><ref>{{cite web|url=http://www.toseftaonline.org/Tractate-Sanhedrin-chapter-8-tosefta-4|title=Tosefta on Mishnah Seder Nezikin Sanhedrin 8.4–9 (Erfurt Manuscript)|publisher=toseftaonline.org|date=2012-08-21}}</ref> And it is also taught, that Adam is last in order according to the evolutionary character of God's creation:<ref name="a">{{cite web|url=http://jewishencyclopedia.com/view.jsp?artid=758&letter=A&search=adam#1 |title=ADAM |publisher=JewishEncyclopedia.com |access-date=12 September 2013}}</ref><blockquote>Why was only a single specimen of man created first? To teach us that he who destroys a single soul destroys a whole world and that he who saves a single soul saves a whole world; furthermore, so no race or class may claim a nobler ancestry, saying, 'Our father was born first'; and, finally, to give testimony to the greatness of the Lord, who caused the wonderful diversity of mankind to emanate from one type. And why was Adam created last of all beings? To teach him humility; for if he be overbearing, let him remember that the little fly preceded him in the order of creation.<ref name="a" /></blockquote>
{{Bible quote|inline=false|ref=Luke 6:31}}
=== Deny oneself to follow Christ (rule 10) ===
{{Bible quote|inline=false|ref=Matthew 16:24–26}}
=== Mortification of the flesh (rule 11) ===
{{Bible quote|ref=Proverbs 20:30}}; {{Bible quote|ref=Romans 8:13}}; {{Bible quote|ref=Colossians 3:5}}; {{Bible quote|ref=Galatians 5:24}}
=== Detachment from worldly pleasures (rule 12) ===
{{Bible quote|ref=1 Peter 2:10-11}}; {{Bible quote|ref=Titus 2:11-13}}; {{Bible quote|ref=1 John 2:15-16}}; {{Bible quote|ref=1 Peter 1:13-14}}; {{Bible quote|ref=Matthew 6:19}}; {{Bible quote|ref=1 Timothy 6:9}}
=== Fasting (rule 13) ===
{{Bible quote|ref=Matthew 4:1-11}}; {{Bible quote|ref=Matthew 6:16}}
=== Almsgiving (rule 14) ===
{{Bible quote|ref=Deuteronomy 14:28}}; {{Bible quote|ref=Deuteronomy 15:7-8}}; {{Bible quote|ref=Psalm 112:5}}; {{Bible quote|ref=Proverbs 19:17}}; {{Bible quote|ref=Isaiah 58:7,10}}; {{Bible quote|ref=Matthew 5:42}}; {{Bible quote|ref=Matthew 6:1-4}}; {{Bible quote|ref=Matthew 25:35}}; {{Bible quote|ref=Luke 10:35}}; {{Bible quote|ref=Luke 11:41}}; {{Bible quote|ref=Luke 12:33}}; {{Bible quote|ref=Luke 18:22}}; {{Bible quote|ref=Luke 19:8}}; {{Bible quote|ref=Acts 10:4,31}}; {{Bible quote|ref=Acts 24:17}}; {{Bible quote|ref=1 Corinthians 16:1-3}}; {{Bible quote|ref=2 Corinthians 9:6-7}}; {{Bible quote|ref=1 John 3:17}}
=== Corporal works of mercy (rules 15-17) ===
{{Bible quote|ref=Isaiah 58:6-7,10}}; {{Bible quote|ref=Matthew 25:31-46}}
=== Spiritual works of mercy (rules 18-19) ===
The Lord is a help in time of distress, and gives comfort to the afflicted:
{{Bible quote|ref=Psalms 9:8-11}}; {{Bible quote|ref=Psalms 22:23-27}}; {{Bible quote|ref=Psalms 27:4-5}}; {{Bible quote|ref=Psalms 30:2-4}}; {{Bible quote|ref=Psalms 46:2}}; {{Bible quote|ref=Psalms 55:22}}; {{Bible quote|ref=Psalms 56}}; {{Bible quote|ref=Psalms 71:20-22}}; {{Bible quote|ref=Psalms 116}}; {{Bible quote|ref=Psalms 119:49-50}}; {{Bible quote|ref=Jeremiah 29:11-14}}; {{Bible quote|ref=Lamentations 3:21-24,31-33}}; {{Bible quote|ref=Nahum 1:7-8}}; {{Bible quote|ref=Matthew 11:28-30}}; {{Bible quote|ref=John 14:15-18,27}}; {{Bible quote|ref=John 16:22-23}}; {{Bible quote|ref=2 Corinthians 5:17}}; {{Bible quote|ref=1 Peter 5:5-11}}; {{Bible quote|ref=Revelation 21:4}}
Being a help to others in times of trouble, and comforting the afflicted:
{{Bible quote|ref=Deuteronomy 22:4}}; {{Bible quote|ref=Proverbs 3:27}}; {{Bible quote|ref=Proverbs 11:25}}; {{Bible quote|ref=Proverbs 22:9}}; {{Bible quote|ref=Matthew 5:16}}; {{Bible quote|ref=Matthew 10:8}}; {{Bible quote|ref=Luke 3:10-11}}; {{Bible quote|ref=Luke 6:38}}; {{Bible quote|ref=John 15:12}}; {{Bible quote|ref=Acts 20:35}}; {{Bible quote|ref=Romans 12:13}}; {{Bible quote|ref=Ephesians 4:32}}; {{Bible quote|ref=Galatians 6:2}}; {{Bible quote|ref=Philippians 2:4}}; {{Bible quote|ref=1 Thessalonians 5:11}}; {{Bible quote|ref=Hebrews 6:10}}; {{Bible quote|ref=Hebrews 13:16}}; {{Bible quote|ref=James 2:14-17}}
=== Be a stranger to the ways of the world (rule 20) ===
{{Bible quote|ref=John 15:19;17:14-16}}; {{Bible quote|ref=Romans 12:2}}; {{Bible quote|ref=Ephesians 4:20-24}}; {{Bible quote|ref=1 Thessalonians 4:1}}; {{Bible quote|ref=1 Peter 2:11}}; {{Bible quote|ref=Hebrews 11:13-16}}
=== Prefer nothing more than the love of Christ (rule 21) ===
{{Bible quote|ref=Matthew 10:37}}; {{Bible quote|ref=Luke 9:62}}; {{Bible quote|ref=Luke 10:38-42}}; {{Bible quote|ref=Luke 14:25-33}}; {{Bible quote|ref=1 John 2:15}}; {{Bible quote|ref=1 John 2:15-17}}; {{Bible quote|ref=2 Timothy 3:2-5}}
=== Give not way to anger (rule 22) ===
{{Bible quote|ref=Psalm 37:8}}; {{Bible quote|ref=Proverbs 14:29}}; {{Bible quote|ref=Proverbs 15:18}}; {{Bible quote|ref=Proverbs 22:24}}; {{Bible quote|ref=Proverbs 29:22}}; {{Bible quote|ref=Ecclesiastes 7:9}}; {{Bible quote|ref=Ephesians 4:26,31}}; {{Bible quote|ref=Colossians 3:8}}; {{Bible quote|ref=1 Timothy 2:8}}; {{Bible quote|ref=James 1:19-20}}
=== Nurse not a grudge, bear no vengeance (rules 23, 29, 30) ===
{{Bible quote|ref=Leviticus 19:18}}; {{Bible quote|ref=Proverbs 19:11;20:22;24:29}}; {{Bible quote|ref=Matthew 5:23-24}}; {{Bible quote|ref=Matthew 6:14-15}}; {{Bible quote|ref=Mark 11:25}}; {{Bible quote|ref=Luke 17:3-4}}; {{Bible quote|ref=Romans 12:17-21}}; {{Bible quote|ref=Ephesians 4:31-32}}; {{Bible quote|ref=1 Corinthians 13:4-8}}; {{Bible quote|ref=Titus 3:3}}
=== Sincerity and truthfulness (rules 24, 27 and 28) ===
{{Bible quote|ref=Jeremiah 17:9}}; {{Bible quote|ref=Job 15:35}}; {{Bible quote|ref=Psalm 5:6;10:7;36:3;43:1;101:7;120:2}}; {{Bible quote|ref=Proverbs 6:16-19;12:5,17;14:8;19:9;24:28;26:24-26}}; {{Bible quote|ref=Matthew 5:37}}; {{Bible quote|ref=Mark 7:20-23}}; {{Bible quote|ref=Romans 3:13;16:18}}; {{Bible quote|ref=Colossians 3:9-10}}; {{Bible quote|ref=1 Peter 2:1,22;3:10}}; {{Bible quote|ref=2 Timothy 3:12-15}}; {{Bible quote|ref=Matthew 5:33-35}}
=== Give true peace (rule 25) ===
{{Bible quote|ref=Jeremiah 6:14}}; {{Bible quote|ref=Ezekiel 13:10}}; {{Bible quote|ref=John 14:27}}
=== Do not forsake charity (rule 26) ===
{{Bible quote|ref=1 Cor 13}}
=== Love your enemy (rule 31) ===
{{Bible quote|ref=Proverbs 24:17;25:21}}; {{Bible quote|ref=Matthew 5:43-48;Luke 6:27-29}}
=== Bless those who curse you (rule 32) ===
{{Bible quote|ref=Matthew 5:44}}; {{Bible quote|ref=Luke 6:28}}; {{Bible quote|ref=Romans 12:14}}; {{Bible quote|ref=1 Corinthians 4:12}}; {{Bible quote|ref=1 Peter 3:9}}
=== Bear persecution for the sake of righteousness (rule 33) ===
{{Bible quote|ref=Isaiah 51:7}}; {{Bible quote|ref=Matthew 5:10-12}}; {{Bible quote|ref=Luke 6:22-23}}; {{Bible quote|ref=John 15:20-21}}; {{Bible quote|ref=Acts 5:41}}; {{Bible quote|ref=Acts 21:13}}; {{Bible quote|ref=1 Peter 4:14-16}}
=== Be not proud (rule 34) ===
{{Bible quote|ref=1 Samuel 2:3}}; {{Bible quote|ref=2 Chronicles 26:16}}; {{Bible quote|ref=Psalm 10:2-4;31:18;36:11;75:4-5;94:4}}; {{Bible quote|ref=Proverbs 8:13;11:2;13:10;16:18;18:12;21:4,24;29:23;30:13}}; {{Bible quote|ref=Ecclesiastes 7:8}}; {{Bible quote|ref=Isaiah 2:17;5:15;13:11;16:6}}; {{Bible quote|ref=Jeremiah 13:9;48:29;50:32}}; {{Bible quote|ref=Ezekiel 16:49}}; {{Bible quote|ref=Daniel 5:20}}; {{Bible quote|ref=Hosea 5:5}}; {{Bible quote|ref=Acts 12:20-23}}; {{Bible quote|ref=Romans 12:16}}; {{Bible quote|ref=1 Corinthians 4:18;13:4}}; {{Bible quote|ref=James 4:16}}
=== Do not be addicted to wine (rule 35) ===
{{Bible quote|ref=Proverbs 20:1;23:29-35}}; {{Bible quote|ref=Isaiah 5:11;5:22;28:1-3,7-8}}; {{Bible quote|ref=Romans 13:13}}; {{Bible quote|ref=Ephesians 5:18}}; {{Bible quote|ref=1 Timothy 3:2-3,8}}; {{Bible quote|ref=Titus 1:7;2:3}}; {{Bible quote|ref=1 Peter 5:8}}
=== Be not a great eater (rule 36) ===
{{Bible quote|ref=Proverbs 23:2,20-21}}; {{Bible quote|ref=Philippians 3:19}}


This choice of Christian ethics as a basis for the SQLite community brought public scrutiny upon the SQLite founder and the SQLite community.<ref>https://www.theregister.com/2018/10/22/sqlite_code_of_conduct/</ref><ref>https://pjmedia.com/news-and-politics/paula-bolyard/2018/10/24/tech-community-outraged-after-sqlite-founder-adopts-christian-code-of-conduct-n61746</ref>
[[Category:Computer science]]
[[Category:Computer science]]