3 ms·
We are using Ingres Databases from the early 90s or late 80s. We have tens of billions of rows. List of missing things: EVERYTHING. Primary/Foreign key relatio
by ambiate 13y ago
We are using Ingres Databases from the early 90s or late 80s. We have tens of billions of rows.
List of missing things: EVERYTHING. Primary/Foreign key relationships are buggy, therefore, not used. Views are somewhat available. Joins are buggy. Have to build all indices by hand choosing the relational columns and data structure/allocation. Cannot subtract sets without huge where clauses with very odd syntax. Rely mostly on WHERE EXISTS/NOT EXISTS or WHERE IN. Can only perform single column queries in a where clause, no WHERE (a, b) IN. Its free and it works. IT is a cost center. No new databases anytime in the near future.