sql   75488

« earlier    

Queries: PostgreSQL Simplified — Queries 2.0.0 documentation
Queries is a BSD licensed opinionated wrapper of the psycopg2 library for interacting with PostgreSQL.
postgresql  python  sql  documentation  reference  guide  tutorial  example  api  links  tornado.python  concurrency  github  opensource 
4 hours ago by ezequiel
PostgreSQL + Python | Psycopg
Psycopg is the most popular PostgreSQL adapter for the Python programming language. At its core it fully implements the Python DB API 2.0 specifications. Several extensions allow access to many of the features offered by PostgreSQL.
Psycopg is released under the terms of the GNU Lesser General Public License, allowing use from both free and proprietary software.
postgresql  python  sql  freesoftware  license.lgpl  links  downloads 
4 hours ago by ezequiel
Psycopg – PostgreSQL database adapter for Python — Psycopg 2.8.dev0 documentation
Psycopg is the most popular PostgreSQL database adapter for the Python programming language. Its main features are the complete implementation of the Python DB API 2.0 specification and the thread safety (several threads can share the same connection). It was designed for heavily multi-threaded applications that create and destroy lots of cursors and make a large number of concurrent INSERTs or UPDATEs.
documentation  reference  tutorial  postgresql  python  sql 
4 hours ago by ezequiel
Spanning The Database World With Google
If relational databases had just worked at scale to begin with, the IT sector would be a whole lot more boring and we wouldn’t be having conversation a conversation with Andrew Fikes, the vice president and Engineering Fellow at search engine, application, and cloud computing giant Google who has been instrumental in the creation of many of its databases and datastores since joining the company in 2001.

Luckily for us, then, the database sector is just as interesting as it has always been because the applications that drive them keep changing, getting more complex and more demanding over time. Google’s Spanner is one of the most sophisticated, flexible, and scalable databases ever created, and it has spawned a clone called CockroachDB, which is also getting traction among enterprises and which is competing against Google’s Cloud Spanner service on its public cloud. There is also a certain amount of competition with the SQL database layers atop the Hadoop stack, various NoSQL datastores, and the ever-improving, enterprise-grade relational databases with columnar stores and in-memory processing.

It is an exciting time – still – in the database world.
Database  Google  spanner  bigtable  transactions  eventualConsistency  SQL 
6 hours ago by euler
Open source PostgreSQL GUI client for macOS and Linux
postgresql  sql  data  apps 
12 hours ago by davidgasperoni
_Amazon Aurora: On Avoiding Distributed Consensus for I/Os, Commits, and Membership Changes_, SIGMOD '18
One of the more novel differences between Aurora and other relational databases is how it pushes redo processing to a multi-tenant scale-out storage service, purpose-built for Aurora. Doing so reduces networking traffic, avoids checkpoints and crash recovery, enables failovers to replicas without loss of data, and enables fault-tolerant storage that heals without database involvement. Traditional implementations that leverage distributed storage would use distributed consensus algorithms for commits, reads, replication, and membership changes and amplify cost of underlying storage. In this paper, we describe how Aurora avoids distributed consensus under most circumstances by establishing invariants and leveraging local transient state. Doing so improves performance, reduces variability, and lowers costs.
papers  toread  aurora  amazon  aws  pdf  scalability  distcomp  state  sql  mysql  postgresql  distributed-consensus 
12 hours ago by jm
Creating a date dimension or calendar table in SQL Server
Read this tip to learn how to build and use a calendar table in SQL Server.
sql  calendar  datetable  datetime 
yesterday by cothrun
SQL Server running under a domain account cannot register its SPN
I am trying to configure a fresh install of SQL Server to run under a domain account. However, I get intermittent errors when trying to connect to the server using another domain account, and I st...
sql  kerberos  spn 
yesterday by egwillim
What should my SPN entries look like for each SQL instance?
I'm finding contradictory information for how exactly to format SPNs (Service Principle Names) to get the proper Kerberos connections, and how many I need for each SQL instance. This 2017 MS docu...
sql  kerberos  spn 
yesterday by egwillim
Questions About Kerberos and SQL Server That You Were Too Shy to Ask
Kerberos authentication is a topic that many database administrators avoid. It’s really not that difficult to understand, but it’s also easy to get wrong. In this article, Kathi Kellenberger talks about what you need to know about configuring Kerberos for SSRS and SQL Server databases but were too shy to ask.
sql  kerberos  spn 
yesterday by egwillim

« earlier    

related tags

12  3d  active_record  activerecord  alasql  alternativas  amazon  analytics  android  api  app  apps  arel  aurora  automation  aws  best-practices  bestpractices  bi  bigtable  browser  c++  calculus  calendar  cassandra  charts  cli  client  clojure  cloud  code  command  concurrency  contenedores  csv  dashboard  dashboards  data  dataanalysis  database  databases  dataquality  datascience  datascientists  datawarehouse  datetable  datetime  db  dev  devops  diagram  discovery  discussion  distcomp  distributed-consensus  distributed  docker  documentation  downloads  drill  editor  ejemplos  er  etl  eventualconsistency  example  excel  export  flatfile  floss  flutter  formacion  freesoftware  full-outer-join  full  generator  github  google  guide  hacks  hadoop  howto  interesting  javascript  jins  join  joins  js  json  kerberos  kotlin  learn  libraries  library  license.lgpl  links  localstorage  logic  mac  mongodb  mysql  node.js  nodejs  nosql  opensource  optimization  oracle  orm  outer  papers  pdf  performance  php  postgis  postgres  postgresql  presto  profdev  programming  pulsar  python  rails  rails5  ref  reference  relational  rest  ruby  rust  rustlang  scalability  schema  simplicity  software  spanner  spn  sql_server  sqlite  state  streaming  styleguide  tableau  tips  toolkit  tools  toread  tornado.python  transactions  tutorial  typescript  vertica  visualisation  visualization  web  webdesign  wikientry 

Copy this bookmark: