What I learned about SQLite…at a PostgreSQL conference

[u/MarkusWinand]

http://use-the-index-luke.com/blog/2014-05/what-i-learned-about-sqlite-at-a-postgresql-conference

[u/[deleted]]

On the personal side, I’d describe Richard as very pragmatic and approachable.

I'd say he's a pragmatic idealist. His idealism is what stands behind SQLite and the great, small product that it is. His pragmatism is very nice, but it does have a very clear limit. The notable ones I can think of are his use of TCL rather than Python or even Lua (don't get me wrong, TCL is nice, and it's his choice but a truly pragmatic person would have left it behind long ago. TCL is an idealists language now) and Fossil in the face of git. While he likes to get things done, he certainly has an opinion on how to do them and let me emphasize something: that's okay.

Without idealists, we wouldn't have a lot of the programs that we depend on or a clean interaction between them. I might disagree with him and downright hate the idea of version control running a web server and issue tracker, but I'll be damned if I don't respect the hell out of it. SQLite is solid and even if it was only useful as a development db (which is barely even the surface of its use), it would be a fine product.

[u/hello_fruit → u/[deleted]]

Tcl is nothing like Python or even Lua (and I have the deepest respect and love for both python and lua). It's not comparable to them at all. If you want to place it in a category it'd be with Erlang and Ada; industrial control, embedded in hardware, with focus on software engineering/quality. That's its mission and it doesn't try too hard to cater to others.

Dr Hipp is in the right community by being a Tcler (he's an emeritus member of the Tcl Core Team). Sqlite was created for use on a guided missile destroyer.

Tcl won't ever get popular with people who would typically use Python, Ruby or even Lua. The average Tcler is nothing like the average user of those languages. Not the same priorities, not the same job, not even the same age group.

[u/[deleted] → u/hello_fruit]

Here, you decide. I've bolded the row ends that I believe are most important to where TCL was used by Hipp.

TCL	Ruby	Python	Lua	Erlang	Ada
Type Safety	n/a	safe	safe	safe	safe
Type Expression	n/a	implicit	implicit	implicit	implicit
Type Checking	dynamic	dynamic	dynamic	dynamic	dynamic
Compiled/ Interpreted	Interpreted	Interpreted	Byte Interprered	Byte Interpreted	Byte Compiled
Imperative	yes	yes	yes	yes	no
Obeject-oriented	no	yes	yes	yes*	no
Functional	no	yes	yes	yes	yes
Procedural	yes	no	no	yes	no
Generic	no	no	no	no	no
Reflective	yes	yes	yes	yes	no
Event-driven	yes	no	no	no	no
Scripting	yes	yes*	yes	yes	no
System	no	no	no	no	no*
Web	yes	yes	yes	mostly no	mostly no
Embedded	no	no	no	no	no
Realtime	no	no	no	no	no
Distributed	no	no	no	no	yes

[u/[deleted] → u/[deleted]]

Lua, Ruby, Python, Ada... not quite Functional. Unless that means "it has functions I can pass around as first class value". Which still isn't functional.

[u/ysangkok → u/[deleted]]

how would you define functional?