Wednesday, 28 July 2021

Getting SELECT to return a constant value even if zero rows match - Postgresql

 SELECT COALESCE(status,'not a valid token') AS status,last_sync_data_time FROM

 (

SELECT 

CASE WHEN CURRENT_TIMESTAMP <= license_end_date THEN 'valid' ELSE 'expired' END AS status, last_sync_data_time

FROM adempiere.license_tomato_app

WHERE key = '7EF3D9B8183D9C7AB90242AF5D011ABE'

union all 

select  null, '1900-01-01 00:00:00' last_sync_data_time where not exists (select 1 from adempiere.license_tomato_app WHERE key = '7EF3D9B8183D9C7AB90242AF5D011ABE')

) t

Wednesday, 7 July 2021

Backup a table in postgresql

 SELECT * INTO abc_bk FROM abc;

Tuesday, 6 July 2021

Open Source Big Data Databases

  • Cassandra
  • CouchDB
  • FlockDB
  • HBase
  • Hibari
  • MongoDB
  • Neo4j
  • OrientDB
  • Riak
  • Terrstore

DBT - Models

Models are where your developers spend most of their time within a dbt environment. Models are primarily written as a select statement and ...