4 ms·

What if the tables your API queried were actually views? You could do the same faking of data during migrations of the underlying data (structure) and the clien

by tyre 7y ago

What if the tables your API queried were actually views? You could do the same faking of data during migrations of the underlying data (structure) and the client should not be effected.

zozbot234 7y ago
What if the "views" your API queries didn't have to be tables? You could just keep "tables" as a backend implementation detail, and 'fake' a different model on top of them that's closer to what the client needs.
- andy_ppp 7y ago
  Amazing you mean some sort of intermediate data transfer language that could resolve requests into SQL in the server side! Genius!
- enobrev 7y ago
  I think what's becoming clear in this discussion is that there are some developers (myself definitely included) who would like to use SQL as an interface to plain programming structures outside of actual databases. I understand postgres provides something like this, but it would be interesting as a library rather than a separate application. I'd love to be able to query hashmaps or arrays of data using SQL. Maybe this already exists somewhere? My web-search-fu is failing me but I recall reading somewhere that facebook had something like this for querying systems, so maybe such a library exists extracted from that usecase? Edit: Here's one. https://github.com/mozilla/moz-sql-parser https://github.com/mozilla/moz-sql-parser
  - enhray 7y ago
    SQLite has “virtual tables” feature [0] which was designed exactly for this use-case. Edit: and that Facebook project is called OsQuery [1]. It was built on top of SQLite virtual tables and is listed in their implementations list. [0] https://www.sqlite.org/vtab.html https://www.sqlite.org/vtab.html [1] https://osquery.readthedocs.io/en/stable/ https://osquery.readthedocs.io/en/stable/
  - elcritch 7y ago
    Always LINQ: https://docs.microsoft.com/en-us/dotnet/csharp/programming-guide/concepts/linq/data-transformations-with-linq https://docs.microsoft.com/en-us/dotnet/csharp/programming-g...
  - TeMPOraL 7y ago
    > I think what's becoming clear in this discussion is that there are some developers (myself definitely included) who would like to use SQL as an interface to plain programming structures outside of actual databases. Myself included too. As a side project, I'm currently writing a game (roguelike), where all the game state that would ordinarily be put into an ECS or an object tree is instead stored in in-memory SQLite instance; the game's state management consists of (currently hand-written) SQL queries. The reason for that is because, in trying to implement yet another version of an ECS-like architecture, I realize I'm essentially reinventing database queries and database indices, so I might as well use the real thing.
  - deleted 7y ago
    [deleted]
  - deleted 7y ago
    [deleted]
  - touisteur 7y ago
    For Postgres you mean foreign data wrappers ? Or storing plain (mmappable?) binary data in bytea and creating a pg extension to serialize/deserialize? I'm working on both...

by tyre 7y ago

What if the tables your API queried were actually views? You could do the same faking of data during migrations of the underlying data (structure) and the client should not be effected.

zozbot234 7y ago

What if the "views" your API queries didn't have to be tables? You could just keep "tables" as a backend implementation detail, and 'fake' a different model on top of them that's closer to what the client needs.

andy_ppp 7y ago
Amazing you mean some sort of intermediate data transfer language that could resolve requests into SQL in the server side! Genius!
enobrev 7y ago
I think what's becoming clear in this discussion is that there are some developers (myself definitely included) who would like to use SQL as an interface to plain programming structures outside of actual databases. I understand postgres provides something like this, but it would be interesting as a library rather than a separate application. I'd love to be able to query hashmaps or arrays of data using SQL. Maybe this already exists somewhere? My web-search-fu is failing me but I recall reading somewhere that facebook had something like this for querying systems, so maybe such a library exists extracted from that usecase? Edit: Here's one. https://github.com/mozilla/moz-sql-parser https://github.com/mozilla/moz-sql-parser
- enhray 7y ago
  SQLite has “virtual tables” feature [0] which was designed exactly for this use-case. Edit: and that Facebook project is called OsQuery [1]. It was built on top of SQLite virtual tables and is listed in their implementations list. [0] https://www.sqlite.org/vtab.html https://www.sqlite.org/vtab.html [1] https://osquery.readthedocs.io/en/stable/ https://osquery.readthedocs.io/en/stable/
- elcritch 7y ago
  Always LINQ: https://docs.microsoft.com/en-us/dotnet/csharp/programming-guide/concepts/linq/data-transformations-with-linq https://docs.microsoft.com/en-us/dotnet/csharp/programming-g...
- TeMPOraL 7y ago
  > I think what's becoming clear in this discussion is that there are some developers (myself definitely included) who would like to use SQL as an interface to plain programming structures outside of actual databases. Myself included too. As a side project, I'm currently writing a game (roguelike), where all the game state that would ordinarily be put into an ECS or an object tree is instead stored in in-memory SQLite instance; the game's state management consists of (currently hand-written) SQL queries. The reason for that is because, in trying to implement yet another version of an ECS-like architecture, I realize I'm essentially reinventing database queries and database indices, so I might as well use the real thing.
- deleted 7y ago
  [deleted]
- deleted 7y ago
  [deleted]
- touisteur 7y ago
  For Postgres you mean foreign data wrappers ? Or storing plain (mmappable?) binary data in bytea and creating a pg extension to serialize/deserialize? I'm working on both...