postgresql   31284

« earlier    

You still need to care about locks with transactions - DockYard
My mental model of Postgres’s transactions was that it used MVCC (Multiversion Concurrency Control): it kept around multiple copies of rows and transactions automatically kept track of which version they used on their first read or write. When it was time to COMMIT the transaction, the server checked if that starting number matched the row’s current, outside-of-transactions number and if it did for all modified rows, then the transaction succeeded, if not, then it rolled back. There was no need for user supplied locks and the server internally didn’t use locks either.
postgresql  database 
2 days ago by mlednor
mauricio/postgresql-async: Async, Netty based, database drivers for PostgreSQL and MySQL written in Scala
GitHub is where people build software. More than 28 million people use GitHub to discover, fork, and contribute to over 85 million projects.
asynchronous  java  mysql  postgresql  scala  postgres  async  client  database  db 
3 days ago by markwatson
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 
3 days ago 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 
3 days ago by gilberto5757
xo/usql: universal command-line interface for SQL databases
A universal command-line interface for PostgreSQL, MySQL, Oracle Database, SQLite3, Microsoft SQL Server, and many other databases including NoSQL and non-relational databases!
go  programming  opnsource  sql  postgresql  mysql  sqlite 
4 days ago by masukomi

« earlier    

related tags

activerecord  analytics  api  article  async  asynchronous  autofield  autoincrement  aws  backup  bash  benchmark  bestpractices  book  cache  centos  ci  citus  cli  client  cloud  connection_pooling  cte  data  database  databases  datatype  date  datestyle  db  db2  devops  django  docker  documentation  elixir  events  field  floss  fosdem  free  freebsd  gis  go  golang  graph  graphql  grpc  gui  ha  heroku  highavailability  hook  howto  important  insert  intro  italian  java  javascript  jdbc  json  june  kubernetes  learning  linux  listener  mac  manual  mapping  mariadb  materialized  mem-buffer  memory  metrics  microservice  migration  mongodb  mysql  naming  nodejs  nosql  opensource  opnsource  oracle  osx  performance  perl  pgadmin  pgbouncer  pgloader  phoenix  pool  pooling  postgis  postgres  postgresql-database  postgresweekly  programming  python  rails  rc2  rdbms  rds  reference  replication  rest  return  scala  search  sequence  sphinx  sql  sqlite  ssh  style  tips  tool  tools  transaction  truncate  tuning  tutorial  ubuntu  upsert  utilities  value  view  views  volume  wiki  zfs 

Copy this bookmark:



description:


tags: