News for hackers. Stuff that matters.
Re:The Makefile I use with JavaScript projects by enriquto on Wednesday February 28, 2018 @04:06PM (#16486903)
you could mount the database as a filesystem
Re:The Makefile I use with JavaScript projects by Jtsummers on Wednesday February 28, 2018 @04:14PM (#16487007)
With respect to Make, does the database (mounted as a filesystem) retain accurate information that Make needs to operate as designed (primarily the timestamps). To what level of granularity is this data present within the database, and what is the performance of the database accessed in this way? Will it tell you that the table was updated at 08:40:33.7777, or will it tell you only that the whole database was altered at a specific time?
Re:The Makefile I use with JavaScript projects by Spivak on Thursday March 01, 2018 @12:33AM (#16489906)
You're talking about a theoretical implementation of a filesystem with a back-end in a relational database. The question is only whether the information is available.

Say directories map to databases and files map to tables and views. You can create new tables and views by either writing data or an appropriate query. Views and result files would be read-only while data files would be writable. Writing to a data file would be done with a query which modifies the table and the result could be retrieved by then reading the file -- the modification time would be the time of the last update which is known.

Views and queries could be cached results from the last time they were ran which could be updated/rerun by touching them or they could be dynamic and update whenever a table they reference is updated.