json-api VS tinybase

Why reinvent the wheel poorly when you have a hundred of solutions like https://jsonapi.org/?

For context, the subject-predicate-object pattern is known as a semantic triple or Resource Description Framework (RDF) triple:

https://en.wikipedia.org/wiki/Semantic_triple

They're useful for storing social network graph data, for example, and can be expressed using standards like Open Graph and JSONAPI:

https://ogp.me

https://jsonapi.org

I've stored RDF triples in database tables and experimented with query concepts from neo4j:

https://neo4j.com/docs/getting-started/data-modeling/tutoria...

These are straightforward to translate to SQL but the syntax can get messy due to not always having foreign keys available and hitting limitations with polymorphic relationships. Some object-relational mapping (ORM) frameworks help with this:

https://laravel.com/docs/12.x/eloquent-relationships#polymor...

I feel that document-oriented databases like MongoDB jumped the gun a bit, and would have preferred to have had graph-oriented or key-value-oriented databases providing row/column/document oriented queries and views. Going the other way feels a bit kludgy to me:

https://www.mongodb.com/resources/basics/databases/mongodb-g...

Basically Set Theory internally with multiple query languages externally and indexed by default.

Oh and have all writes generate an event stream like Firebase does so we can easily build reactive apps.

Built on JSON API standards, the OSF API is intuitive for anyone familiar with REST conventions. Once you learn its core patterns, you can quickly expand into project creation, user collaboration, and more—without constantly referencing documentation. The official OSF API docs provide everything needed to get started.

Following established patterns reduces the learning curve for your API. Adopt conventions from JSON:API or Microsoft API Guidelines to provide consistent experiences.

I’ve used both GraphQL and REST in the past. From json:api to Relay, each approach for building APIs has its pros and cons. However, a constant challenge is choosing between code-first and schema-first approaches.

Features: REST-like CQRS HTTP-API, Faceted Search, Full-text Search Interface: OpenAPI, JSON, JSON API, JSON Schema Query Languages: SQL dialect, Cypher, Gremlin, MQL, GraphQL Ingest Protocols: OAI-PMH, S3 Ingest Encoding: XML Ingest Formats: DataCite, DublinCore, MARC, MODS Deployment: Compose, Docker-Compose, Podman-Compose, K8s (via Kompose) Components: ArcadeDB, Connect, Lowdefy License: MIT

There is a group of people who set out to standardize JSON responses into a single response style, either for returning single or multiple resources. You can take their style as a reference when designing their API to ensure uniformity of responses.

The server seems to be using the popular JSON:API standard which is a great way to build APIs. But should we really use these data structures in the frontend?

Note: You think the response data structure with the data field and the included field with mixed data types looks weird? You might not have encountered the popular JSON:API standard yet.

- https://dgl.cx/2020/06/sqlite-json-support (An article about SQLite as a document database, using the relatively new 'genrated columns' feature of sqlite 3.31.0, which you seem to be using)

- https://www.npmjs.com/package/best.db (easy and quick storage)

- https://tinybase.org (This project seems to be an even more similar idea to Doculite) https://github.com/tinyplex/tinybase (The reactive data store for local-first apps.)

Good luck with your project!

And was recently looking through this codebase https://github.com/tinyplex/tinybase and realized there is not a single class keyword used.

Cool! Please take a look and see if it works out. I should point out that the ui-react library (that provides React bindings) does _not_ depend on ReactDOM, so you can use it just as easily in React Native.

At least, once I got the bundler to be happy about the export format! Please see https://github.com/tinyplex/tinybase/issues/17#issuecomment-...

It looks good. You could expand more on the motivation and use cases. In the meantime take a look to tinybase. It’s a new library as well, very similar to what you are trying to do.

I think they were probably referring to https://github.com/tinyplex/tinybase/blob/main/src/common/ar... and the like for wrapper array.map and array.forEach and array.sort.

I don't think there's dozens, but there's a fair few. Most of the stuff in the common directory seems to be standard patterns they use, so it's doing more than just wrapping a function.