Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
postgres_sql [2018/07/13 08:52]
root [Using Views with Json]
postgres_sql [2019/02/13 07:56] (current)
root [Xml]
Line 387: Line 387:
 </​code> ​ </​code> ​
  
 +selecting more .. 
 +
 +<code sql>
 +select name from sap_name ​
 +where (xpath('//​ADRNR/​text()',​ name))[1]::​text::​int ​ = 1   
 +
 +select (xpath('//​ADRNR/​text()',​ name))[1]::​text::​int ​ from sap_name ​
 +</​code>​
 +
 +merging the results of multiple values ​
 +
 +<code sql>
 +SELECT xmlconcat(
 +( select address from sap_address
 +  where  (xpath('//​CLIENT/​text()',​ address))[1]::​text::​int ​ = 1 ) ,   
 +(select name from sap_name ​
 +where (xpath('//​ADRNR/​text()',​ name))[1]::​text::​int ​ = 1) ) as merge    ​
 +</​code>​
 == Indexing ==  == Indexing == 
  
Line 507: Line 525:
 * Asynchronous Notifications * Asynchronous Notifications
  
 +See also [[https://​github.com/​share/​sharedb | ShareDb]] for Websocket PostgreSQL sync 
 +
 +== Posgres Queue == 
 +
 +PGQ is a Postgres-based queue implementation,​ and Skytools Londiste (developed at Skype) uses it to provide trigger-based replication.
 +
 +https://​wiki.postgresql.org/​wiki/​PGQ_Tutorial
 +
 +== Foreign Data Wrapper == 
 +
 +Postgres has a range of foreign data wrappers that wraps external databases including Sql (Oracle and more), NoSql (mongo and more) as well as flat files 
 +
 +https://​wiki.postgresql.org/​wiki/​Foreign_data_wrappers
 == Links and References ==  == Links and References == 
 * https://​github.com/​begriffs/​postgrest PostgREST serves a fully RESTful API from any existing PostgreSQL database. It provides a cleaner, more standards-compliant,​ faster API than you are likely to write from scratch. * https://​github.com/​begriffs/​postgrest PostgREST serves a fully RESTful API from any existing PostgreSQL database. It provides a cleaner, more standards-compliant,​ faster API than you are likely to write from scratch.
 
postgres_sql.1531497121.txt.gz · Last modified: 2018/07/13 08:52 by root
 
RSS - 200 © CrosswireDigitialMedia Ltd