SQL Anywhere vs SQLite

[Former Member]

Dear Experts,

What are the advantages of using SQL Anywhere or Ultralite when compared to SQLite.

[Vlad]

SQL Anywhere is the DB server;
Ultralite is the file-based DB (not server);
Ultralite can be synchronized with other DB servers (see Mobilink);
SQLite has a different purpose.

[Former Member]

Can you please explain a little. And what is the purpose of SQLite because I have read it is widely used as a DB for mobile applications.

[Vlad]

This is the biggest help that I can give you here for SQLite, because your question is not related to SAP products.
Here is my advice: https://www.sqlite.org/about.html

[Breck_Carter]

I have to (begrudgingly!) say, if half of what's said on the SQLite about page is true then it is a fine product... many of the points made are hot-button points with me, like "ACID after power loss" and "aircraft-grade testing" and "long-term support"... if SQL Anywhere becomes any more stealthy than it is now (and that trajectory seems clear), SQLite could be [cough] worth a look [choke].

signed, Breck Forever The SQL Anywhere Fanboy 🙂

[VolkerBarth]

Note however those SQL restrictions (additionally, I'm not sure about derived tables and OLAP support):

https://www.sqlite.org/omitted.html

Volker belongs to that fan group, too.

[Breck_Carter]

As Tom implied, a more useful comparison might be SQLite versus UltraLite, with reference to the "UltraLite" column in this table as well as some of the links on the same page.

[Vlad]

I can add that I like to read something interesting about in-memory and NoSql DBs, and I have read that people have taken the SQL engine+parser+whatever from SQLite and embed it into the own NoSql DB (no names, just a fact 🙂 ). So the time will show, whether this was wise or not.