gilberto5757 + postgresql   224

GitHub - knex/knex: A query builder for PostgreSQL, MySQL and SQLite3, designed to be flexible, portable, and fun to use.
A query builder for PostgreSQL, MySQL and SQLite3, designed to be flexible, portable, and fun to use. - knex/knex
query  editor  rdbms  sqlite  postgresql  mysql  mariadb  opensource  floss 
yesterday by gilberto5757
PostgresqlCO.NF: PostgreSQL configuration for humans
PostgresqlCO.NF is a configuration manager for all PostgreSQL related configuration files. It provides multilanguage documentation for postgresql.conf parameters, lets the user upload his configurations and gives him recommendations on them
postgresql  doc  parameter  configuration  community 
4 days ago by gilberto5757
Faster Ruby APIs with Postgres - Goiabada
Leveraging Postgres’ JSON json_agg and json_build_object functions to build a 10x faster Ruby API.
json  api  postgresql  ruby 
14 days ago by gilberto5757
Building a scalable PostgreSQL solution  | Packt Hub
In this article, we will look at different scaling scenarios and their implementation in PostgreSQL.
postgresql  scalability  howto  tool  data  sharding  rdbms  vldb 
october 2019 by gilberto5757
PostgreSQL subtransactions, savepoints, and exception blocks
I posted a tricky Quiz on Twitter (unfortunately forgot to mention explicitely that I have a unique constraint on DEMO1.N): The trick is that I didn’t precise on which database I run that. And I…
postgresql  transaction  exception  management 
october 2019 by gilberto5757
Objection.js + PostgreSQL: by the power of JSON queries – Vincit
Introducing the JSONB Query API of Objection.js
As you all know PostgreSQL have had a good support for JSON datatype already since 9.4. I love it.

It is...
json  postgresql  orm  nodejs  javascript  js 
october 2019 by gilberto5757
GitHub - opentable/otj-pg-embedded: Java embedded PostgreSQL component for testing
Java embedded PostgreSQL component for testing. Contribute to opentable/otj-pg-embedded development by creating an account on GitHub.
postgresql  embedded  java  library  opensource  floss 
october 2019 by gilberto5757
Database tools for MySQL, SQL Server, PostgreSQL, SQLite, Oracle, DB2, Firebird by SQL Maestro Group
SQL Maestro Group vendors powerful database management and web development tools for MySQL, Oracle, SQL Server, DB2, SQL Anywhere, PostgreSQL, SQLite, Firebird and MaxDB.
rdbms  tool  mssql  oracle  postgresql  mysql  firebird  rad  php  database  application  generator 
september 2019 by gilberto5757
Hi, I'm Helen | Helen Anderson
Helen Anderson | BI Consultant | Technical Writer | passionate about data and delivering user-focused Business Intelligence solutions.
bi  sql  postgresql  rdbms  blog  spreadsheet 
september 2019 by gilberto5757
GitHub - wasmerio/postgres-ext-wasm: 💽🕸 Postgres library to run WebAssembly binaries.
💽🕸 Postgres library to run WebAssembly binaries. Contribute to wasmerio/postgres-ext-wasm development by creating an account on GitHub.
postgresql  webassembly  extension  runtime  opensource  floss 
august 2019 by gilberto5757
Dealing with significant Postgres database bloat — what are your options?
There are many scenarios that can lead to an unhealthy Postgres database — some of which cannot be cleaned up by the built-in Postgres autovacuum daemon. This articles assumes you have some…
postgresql  vacuum  maintenance  bestpractice 
august 2019 by gilberto5757
Postgres Professional · GitHub
Postgres Professional has 61 repositories available. Follow their code on GitHub.
postgresql  extension  plugin  addon  opensource  floss 
august 2019 by gilberto5757
Converts any Databases to API
Build APIs instantly from MySQL, PostgreSQL, Google BigQuery and more
database  rdbms  nosql  postgresql  mysql  rest  api  mongodb  converter  online  service 
july 2019 by gilberto5757
PostgreSQL Incremental Backup and Point-In-Time Recovery - pgDash
pgDash is an in-depth monitoring solution designed specifically for PostgreSQL deployments. pgDash shows you information and metrics about every aspect of your PostgreSQL database server, collected using the open-source tool pgmetrics.
postgresql  backup  recovery  incremental  howto 
june 2019 by gilberto5757
How to update objects inside JSONB arrays with PostgreSQL
Let’s say you decided to store data in the database as json or jsonb and discovered that you just created new problems for yourself that you didn’t have before. You’re not alone. JSONB is a powerful…
json  update  array  postgresql  article 
april 2019 by gilberto5757
Simple Tips for PostgreSQL Query Optimization | Cube.js Blog
A single query optimization tip can boost your database performance by 100x. At one point, we advised one of our customers that had a 10TB database to use a date-based multi-column index. As a result, their date range query sped up by 112x. In this post, we share five powerful tips for PostgreSQL query optimization.
postgresql  sql  query  optimization  tip  performance 
april 2019 by gilberto5757
A health check playbook for your Postgres database
You database is a living breathing thing. As data comes in and queries are executing the composition of it has changed. This regular checkup playbook will help ensure things are working and in a good place for the long term health of your databse.
postgresql  tuning  tip  suggestion  bestpractice  dba 
march 2019 by gilberto5757
Sum Types In SQL
Algebraic datatypes are a powerful feature of functional programming languages.By combining the expressive power of “and” and “or,” we can solve all kinds of...
adt  algebraic  datatype  sql  postgresql  database  haskell 
march 2019 by gilberto5757
PostgreSQL Tools for the Visually Inclined – Rob Conery
I started my career on the Microsoft stack building forms and websites using drag and drop tools. Over time that became a punchline, which is unfortunate because honestly, the productivity was insane. In 2008 I made the jump to the Linux world and I was completely disoriented. Everything was a damn text file. Yes, you […]
postgresql  client  cli  intro 
march 2019 by gilberto5757
Index-only scans in Postgres – pgMustard – Medium
Index-only scans — how they can make your database faster, when they’re useful, why they’re not a perfect solution — and what to do about it
postgresql  performance  index  indexonly  read 
march 2019 by gilberto5757
GitHub - sastraxi/pgsh: Branch your PostgreSQL Database like Git
Branch your PostgreSQL Database like Git. Contribute to sastraxi/pgsh development by creating an account on GitHub.
postgresql  branch  version  management  database  opensource  floss 
february 2019 by gilberto5757
Enterprise PostgreSQL Support & Solutions | Crunchy Data
The trusted open source enterprise PostgreSQL leader providing certified PostgreSQL, support, and cloud-native, Kubernetes-based solutions.
postgresql  commercial  distro  enterprise  certified  kubernetes  docker  blog 
february 2019 by gilberto5757
How To Setup A Project With Ruby On Rails, PostgreSQL And GraphQL
GraphQL is an open source query language created by Facebook. It is a powerful tool that you can use for building your API. It is not a silver bullet but it can definitely help you solve some challenges like getting many resources in a single request.
rubyonrails  postgresql  graphql  setup  deployment  howto 
february 2019 by gilberto5757
Craig Kerstiens
I’ve learned a lot of skills over the course of my career, but no technical skill more useful than SQL. SQL stands out to me as the most …
postgresql  blog  database 
february 2019 by gilberto5757
Life of a SQL query
What happens when you run a SQL statement? We follow a Postgres query transformation by transformation as a query is processed and results are returned.
postgresql  sql  innerworking  query 
february 2019 by gilberto5757
Lessons learned scaling PostgreSQL database to 1.2bn records/ month
This isn’t my first rodeo with large datasets. The authentication and product management database that I have designed for the largest UK public Wi-Fi provider had impressive volumes too. We were…
postgresql  largscale  deployment  cloud  aws 
january 2019 by gilberto5757
Serverless Function to Sync Data from a Database to Google Spreadsheet
Build a Lambda function that pulls data from Postgres DB to Google SpreadsheetMost business users are adept at analyzing facts on spreadsheets. Give them data points in an Excel sheet or Google…
googlespreadsheet  postgresql  interoperability  serverless  awslambda  howto 
january 2019 by gilberto5757
HeidiSQL - MariaDB, MySQL, MSSQL and PostgreSQL made easy
HeidiSQL is a powerful and easy client for MariaDB, MySQL, Microsoft SQL Server and PostgreSQL. Open source and entirely free to use.
sql  rdbms  client  programming  mysql  mssql  postgresql  opensource  floss 
january 2019 by gilberto5757
GitHub - hasura/graphql-engine: Blazing fast, instant realtime GraphQL APIs on Postgres with fine grained access control, also trigger webhooks on database events.
Blazing fast, instant realtime GraphQL APIs on Postgres with fine grained access control, also trigger webhooks on database events. - hasura/graphql-engine
grpahql  postgresql  engine  opensource  floss 
january 2019 by gilberto5757
TiCodeX SQL Schema Compare
SQL Schema Compare supports Database schema compare for MS-SQL, mySQL and Postgress and runs on Windows, Linux and MacOS
sql  rdbms  schema  compare  tool  mysql  mssql  postgresql 
january 2019 by gilberto5757
DBCLI
Commandline Clients for Databases.
rdbms  sql  commandline  cli  client  opensource  floss  postgresql  mysql 
january 2019 by gilberto5757
Ship-hold | Introduction
documentation website for ship-hold project, a postgres data layer access library for nodejs
nodejs  postgresql  query  builder  library  linq  opensource  floss 
january 2019 by gilberto5757
Sharding Your Data With PostgreSQL 11 - pgDash
pgDash is an in-depth monitoring solution designed specifically for PostgreSQL deployments. pgDash shows you information and metrics about every aspect of your PostgreSQL database server, collected using the open-source tool pgmetrics.
postgresql  table  sharding  partitioning  multiple  server  distributed 
january 2019 by gilberto5757
How We Solved a Storage Problem in PostgreSQL Without Adding a Single Bytes of Storage | Haki Benita
A while back we started getting alerts in the middle of the night on low disk space. A quick investigation led us to one of our ETL tasks. Every night the task was fired to eliminate duplicate dumps, and free up some space. This is a short story about how we found our silver bullet and solved the issue without adding a single byte of storage.
postgresql  hash  data  compare  tip 
january 2019 by gilberto5757
At 22 years old, Postgres might just be the most advanced database yet
From Pub-Sub messaging to Foreign Data Wrappers - five extraordinary features that made Postgres our backend of choice for Arcentry
postgresql  feature  advocacy  opinion 
december 2018 by gilberto5757
GitHub - markdrago/pgsanity: Check syntax of postgresql sql files
Check syntax of postgresql sql files. Contribute to markdrago/pgsanity development by creating an account on GitHub.
sql  postgresql  lint  verifier  syntax  checker  tool  opensource  floss 
december 2018 by gilberto5757
PGXN: PostgreSQL Extension Network
Search all indexed extensions, distributions, users, and tags on the PostgreSQL Extension Network.
postgresql  extension  list  directory 
november 2018 by gilberto5757
Materialized views vs. Rollup tables in Postgres
Materialized views are often used to make reporting faster, however another approach (rollup tables) can have some advantages while delivering the same benefits.
materializedview  postgresql  rolluptable 
november 2018 by gilberto5757
The Hidden Costs of PostgreSQL's JSONB Datatype › Nick Drane
Nick Drane's blog about programming and modern web development, particularly Node.js and React.
jsonb  field  type  postgresql  issue 
october 2018 by gilberto5757
pgDash - Comprehensive PostgreSQL Monitoring
pgDash is a comprehensive monitoring solution designed specifically for PostgreSQL deployments. pgDash shows you information and metrics about every aspect of your PostgreSQL database server, collected using the open-source tool pgmetrics.
postgresql  metric  dashboard  monitoring  backend  client  opensource  floss 
august 2018 by gilberto5757
Datazenit: MySQL and PostgreSQL GUI – Database Administration Tool
Datazenit is a cross-platform MySQL and PostgreSQL GUI. Web-based database administration tool with
data grid, schema editor, query builder, charts.
mysql  postgresql  database  gui  client  webapplication  administration  sql  tool 
july 2018 by gilberto5757
GraphQL on Postgres | Hasura
Instant, high performance GraphQL on any Postgres application, existing or new
postgresql  graphql  query  engine  opensource  floss  api 
july 2018 by gilberto5757
Uniting SQL and NoSQL for Monitoring: Why PostgreSQL is the ultimate data store for Prometheus
How to use Prometheus, PostgreSQL TimescaleDB, and Grafana for storing, analyzing, and visualizing metrics.
postgresql  timeseries  extension  prometheus  timescaledb 
july 2018 by gilberto5757
Distributing Data With PostgreSQL - pgDash
pgDash is an in-depth monitoring solution designed specifically for PostgreSQL deployments. pgDash shows you information and metrics about every aspect of your PostgreSQL database server, collected using the open-source tool pgmetrics.
postgresql  foreign  data  access  tablespace  replication 
july 2018 by gilberto5757
GitHub - robconery/dox: A Document Database API extension for Postgres
GitHub is where people build software. More than 28 million people use GitHub to discover, fork, and contribute to over 85 million projects.
postgresql  extension  json  document  database  opensource  floss 
july 2018 by gilberto5757
GitHub - wal-e/wal-e: Continuous Archiving for Postgres
GitHub is where people build software. More than 28 million people use GitHub to discover, fork, and contribute to over 85 million projects.
postgresql  database  backup  tool  python  opensource  floss 
june 2018 by gilberto5757
GitHub - wal-g/wal-g: Archival and Restoration for Postgres
GitHub is where people build software. More than 28 million people use GitHub to discover, fork, and contribute to over 85 million projects.
postgresql  database  backup  tool  golang  opensource  floss 
june 2018 by gilberto5757
« earlier      
per page:    204080120160

related tags

accelerator  access  accounting  activity  addon  administration  adt  advanced  advocacy  algebraic  analysis  analytical  analytics  analyzer  andromeda  announcement  api  application  apply  architecture  arithmetic  array  article  assistance  asynchronous  audit  automatic  automation  autovacuum  aware  aws  awslambda  backend  backup  batch  bestpractice  bi  bigdata  bigquery  blog  book  branch  browser  builder  bulk  business  businessintelligence  businesslogic  c#  calculation  caqti  case  casehistory  cdc  certified  change  changedatacapture  checker  choice  cli  client  clojure  cloud  cluster  code  collect  collection  comeback  command  commandline  commercial  community  compare  comparison  compatible  configuration  connection  consultant  container  conversion  converter  couchbase  crash  criticism  cron  csv  cte  cuda  dao  dashboard  data  database  datamasking  datatype  date  db2  dba  dbms  ddl  debugging  declarative  deployment  designer  development  dictionary  directory  distinct  distrbuted  distributed  distro  django  dma  doc  docker  document  documentation  dotnet  drilldown  driven  dsl  dv2  editor  education  elixir  embedded  encryption  engine  engineered  enterprise  equivalent  erp  event  example  excel  exception  execution  export  expression  extension  external  f#  fake  feature  field  file  finance  firebird  firebirdsql  floss  forced  foreign  fractal  framework  frature  free  frontend  fsm  fulltext  function  functional  future  game  gdpr  generalledger  generation  generator  gnome  gnu  golang  googlespreadsheet  gpu  graphic  graphical  graphql  grpahql  gui  hash  haskell  hierarchical  hierarchy  hosted  howto  human  hybrid  hypersonic  ide  implementation  import  incremental  index  indexonly  inheritance  inner  innerworking  innovation  insert  integration  interactive  interest  interesting  interface  internal  internals  interoperability  interpolation  intro  issue  italian  java  javascript  jet  job  join  js  json  jsonb  kernel  killing  kubernetes  language  largscale  lateraljoin  library  license  limit  linq  lint  linux  lisp  list  loader  locking  log  logging  ltree  mac  maintenance  manageable  management  manual  mariadb  masking  mass  materialized  materializedview  maths  mdd  message  messaging  metadata  metric  migration  model  modification  module  mongodb  mongosql  monitoring  mortgage  mssql  msssql  multidatabase  multidb  multiengine  multiplatform  multiple  mvcc  mysql  natural  naturallanguage  neo4j  newsql  nlp  nodejs  nosql  notification  number  object  objectrelational  ocaml  office  olap  oltp  online  oop  opensouce  opensource  operation  opinion  optimization  oracle  oracleforms  ordbms  organization  orm  osx  pagination  paradox  parameter  parser  partition  partitioning  performance  periodic  persistence  php  plan  plsql  plugin  pooling  postgresql  postgresql10  prevalence  price  problem  procedure  processing  profiler  programming  prometheus  python  query  r  rad  rails  random  rdbms  read  readable  recovery  recursive  redshift  reference  relational  renderer  repl  replacement  replication  report  repository  representation  rest  rethinkdb  return  review  rlang  rolluptable  row  ruby  rubyonrails  runtime  scalability  scaling  scheduler  schema  schemaless  script  scripting  search  security  self  semantic  server  serverless  service  setup  sharding  sharepoint  shell  software  spreadsheet  sql  sqlite  sqljs  sqlplus  ssd  standard  state  statistics  storage  store  stored  storedprocedure  story  strategy  structure  style  suggestion  support  sync  syntax  system  table  tablespace  technique  temporary  teradata  termination  testing  text  time  timescaledb  timeseries  timestamp  timezone  tip  tool  transaction  transactional  transition  translator  tree  trigger  tuning  tutorial  txt  type  typeprovider  uber  unique  unstructured  update  upgrade  upsert  usage  usecase  utility  vacuum  value  vcs  verifier  version  versioning  vertica  view  violation  visualization  visualizer  vldb  web  webapi  webapplication  webassembly  webdev  window  with  withclause  working  write  writer  xml  xpath 

Copy this bookmark:



description:


tags: