3 ms·
On the top of my head, another list of features worth looking at: - ARRAY support: makes your life easier, especially the array_agg aggregation function - HSTOR
by rdunklau 15y ago
On the top of my head, another list of features worth looking at:
- ARRAY support: makes your life easier, especially the array_agg aggregation function
- HSTORE extension: use postgresql like a key/value store
- SQL/MED implementation, foreign data wrappers: allows you to define external data sources as an extension.
Things that I miss in postgresql:
- materialized views !!
- a better graphical management tool.
- omarqureshi 15y agoYou can most certainly use matviews http://tech.jonathangardner.net/wiki/PostgreSQL/Materialized_Views http://tech.jonathangardner.net/wiki/PostgreSQL/Materialized... it's not part of pg - but, it is something that you can write yourself due to the awesomeness of plpgsql.
- einhverfr 15y agoI mentioned ARRAY support in the context of complex types, but it could definitely get its own entry. I haven't played much with hstore, but there are a few places LedgerSMB might be able to use it in the future. SQL/MED is also worthy of mention, but again kind of fell outside my focus.