4 ms·

Is it the unix version of MS Access? It's sort of interesting to compare the two.

stjohnswarts 6y ago
Well the database part maybe, but it's not going to help you generate forms and reports or build small guis around it. You'll have to find those tools for yourself or build a web app around your sqlite db. I haven't done a lot with Access though, mostly help build small database interfaces/reports for their inventory systems (whether a lab or comic book collection).
- buescher 6y ago
  You can do all that with tcl/tk. Sqlite was in fact originally a tcl extension so the tcl interface for sqlite is first-rate. With tcl/tk it's sort of a Unix analog to VB6. I keep thinking it would be sort of fun to do a tk app again; is there a good model CRUD app for tcl/tk/sqlite out there? Something like the Northwind thing for Access?
II2II 6y ago
SQLite is a database that is intended to be embedded in applications rather than run as a separate server. You could make an Access-like application from it, but it cannot replace Access on its own. It's commonly used in applications that use it as a convenient container to store data (the "file format" scenario) or as a domain specific database. One of the better examples of the latter is Calibre, an e-book library manager, since it exposes some of the database functionality to the end user. For example: the end user can add columns to store custom data for each book.
SigmundA 6y ago
No it would be closer to the Jet db engine that Access uses, they are both file based in process relational db engines. Back in the day for a Windows app if you wanted a in process file based db you would use Jet since the engine was included with windows even though Access was a separate product.
- happyweasel 6y ago
  Yeah, and I think sqlite is really comparable to this setup. Use Access to design the database (optional), and access (no pun intended) the jet database engine via ODBC,OLE-DB or DAO ..Jay! Code like it's 1999 :-) ... I remember the jet db engine offered at least transaction level READ_COMMITTED (in comparison to mysql's MyISAM) and "it was quite fast" until reaching about 1mio rows or so (of course, db design, index etc determines "fast", that was just a basic rule of thumb I remember)...
yawaramin 6y ago
SQLite is cross-platform and actually ships inside all major operating systems.

Well the database part maybe, but it's not going to help you generate forms and reports or build small guis around it. You'll have to find those tools for yourself or build a web app around your sqlite db. I haven't done a lot with Access though, mostly help build small database interfaces/reports for their inventory systems (whether a lab or comic book collection).

buescher 6y ago
You can do all that with tcl/tk. Sqlite was in fact originally a tcl extension so the tcl interface for sqlite is first-rate. With tcl/tk it's sort of a Unix analog to VB6. I keep thinking it would be sort of fun to do a tk app again; is there a good model CRUD app for tcl/tk/sqlite out there? Something like the Northwind thing for Access?

II2II 6y ago

SQLite is a database that is intended to be embedded in applications rather than run as a separate server. You could make an Access-like application from it, but it cannot replace Access on its own. It's commonly used in applications that use it as a convenient container to store data (the "file format" scenario) or as a domain specific database. One of the better examples of the latter is Calibre, an e-book library manager, since it exposes some of the database functionality to the end user. For example: the end user can add columns to store custom data for each book.

SigmundA 6y ago

No it would be closer to the Jet db engine that Access uses, they are both file based in process relational db engines. Back in the day for a Windows app if you wanted a in process file based db you would use Jet since the engine was included with windows even though Access was a separate product.

happyweasel 6y ago
Yeah, and I think sqlite is really comparable to this setup. Use Access to design the database (optional), and access (no pun intended) the jet database engine via ODBC,OLE-DB or DAO ..Jay! Code like it's 1999 :-) ... I remember the jet db engine offered at least transaction level READ_COMMITTED (in comparison to mysql's MyISAM) and "it was quite fast" until reaching about 1mio rows or so (of course, db design, index etc determines "fast", that was just a basic rule of thumb I remember)...

yawaramin 6y ago

SQLite is cross-platform and actually ships inside all major operating systems.