ebouchut + table   53

Export Postgres Query to CSV | Jon Saints
First, connect to the remote database server:


Then, export a query to CSV… \copy makes the file go to your local machine rather than the database server file system

\copy (select * from my_table) TO '~/Downloads/my_table.csv' CSV HEADER
postgres  CSV  export  select  data  extract  create  psql  sql  query  request  copy  table  row 
5 weeks ago by ebouchut
What's new in PostgreSQL 9.3 - PostgreSQL wiki
HINT: There is an entry for table "c", but it cannot be referenced from this part of the query.

Workaround: Use LATERAL instead of the join
postgres  psql  error  sub  query  subquery  SQL  join  table  from  outer  inner  reference  workaround  solution  problem  issue  use  closure  pg 
june 2018 by ebouchut
PostgreSQL 9.5: Insert IF not Exists, Update IF Exists (Insert ON CONFLICT option)
INSERT INTO tbl_Employee
VALUES (8,'Noor')
postgres  insert  if  not  present  SQL  table  row  entry  add 
february 2018 by ebouchut
Ascii Table - ASCII character codes and html, octal, hex and decimal chart conversion
Ascii character table - What is ascii - Complete tables including hex, octal, html, decimal conversions
ascii  table  code  key  character  list  char  HTML  entity  web  reference 
december 2017 by ebouchut
GitHub table of contents · Mottie/GitHub-userscripts Wiki
"A userscript that adds a table of contents to both readme and wiki pages".
Works on Firefox and requires the Greasemonkey plugin.
github  TOC  table  of  content  wiki  README  outline  greasemonkey  script  dynamic  javascript  automatic  generate 
march 2017 by ebouchut
github/gh-ost: GitHub's Online Schema Migrations for MySQL
"gh-ost is a triggerless online schema migration solution for MySQL. It is testable and provides pausability, dynamic control/reconfiguration, auditing, and many operational perks.

gh-ost produces a light workload on the master throughout the migration, decoupled from the existing workload on the migrated table.

It has been designed based on years of experience with existing solutions, and changes the paradigm of table migrations."
github  migration  mysql  local  schema  migrate  online  database  table 
january 2017 by ebouchut
List postgres databases, tables using psql.
\list or \l: list all databases

SELECT current_database();

\dt: list all tables in the current database
postgres  PG  database  command  psql  CLI  list  table  connect  connection  postgresql  current  from notes
november 2016 by ebouchut
Align the table around the pipe character each time you insert a '|'.
"call the :Tabularize command each time you insert a | character."
vim  plugin  tabular  dotfiles  config  vimrc  pipe  align  table  cucumber  mapping  keyboard  key 
april 2016 by ebouchut
soundcloud/lhm: Online MySQL schema migrations
"Rails style database migrations are a useful way to evolve your data schema in an agile manner. Most Rails projects start like this, and at first, making changes is fast and easy.

That is until your tables grow to millions of records. [...]"
rails  rubyonrails  migration  database  mysql  schema  change  update  large  table  big  huge  speed  performance  slow  improvement  online  rolling  continuous  interruption 
september 2015 by ebouchut
Rails 4 has_and_belongs_to_many migration file generator
# pluralized models in alphabetical order (without table at the end)
rails g migration create_posts_tags

# Edit db/migrate/*_create_posts_tags
create_join_table :posts, :tags do |t|
t.index :post_id
t.index :tag_id
rails  rubyonrails  migration  database  table  create  4  rails4  generate  generator 
february 2015 by ebouchut
Visual Representation of SQL Joins - CodeProject
"This article describes SQL Joins in a visual manner, and also the most efficient way to write the visualized Joins"

Source: http://stackoverflow.com/a/6188334/386517
SQL  join  left  outer  inner  right  visual  graphic  table  database  image 
december 2014 by ebouchut
SmartListing - data listing gem for Rails with built-in sorting, filtering and in-place editing | Sology Showcase
Easily create AJAX-enabled data lists
with out-of-the-box support for sorting, filtering and in-place editing.

Ruby on Rails gem with built-in Twitter Bootstrap 3 support.
gem  rails  list  rubyonrails  sort  filter  search  data  table  edit  inline  bootstrap  ajax 
june 2014 by ebouchut
ActiveModel Form Objects
"Submitting form data is a common feature of web applications – allowing users to submit their information and giving them feedback whether the information is valid or not.

ActiveRecord comes with a powerful set of validators for attributes on a persisted data model. When data is not persisted, or used for other non-active record purposes, Active Model Helper Modules reduce the complexity of validations on your plain old Ruby objects."
rails  rubyonrails  persist  not  non  database  model  active  record  ActiveModel  ActiveRecord  memory  less  table  form  object 
february 2014 by ebouchut
rufus-decision : Ruby decision tables
"rufus-decision is a small ruby gem for ‘running decision tables’. Decision tables are useful for mapping conditions to actions."
ruby  rails  feature  flag  decision  table  condition  gem  rubyonrails 
february 2014 by ebouchut
Gem rails_db_info: Rails Database Info
"Quickly check your database info while working with Rails in development"
rails  rubyonrails  gem  database  schema  information  info  table  field  data 
january 2014 by ebouchut
css - Does Firefox support position: relative on table elements? - Stack Overflow
Solution: "wrap the contents of the cell in a div and add position:relative to that div."
css  position  absolute  relative  td  tr  table  bug  firefox  workaround  problem  layout  issue  solution 
august 2013 by ebouchut
IE7 Table Width
"I had a problem with IE7 not respecting TD width.
Finally I found this property
table-layout: fixed;
Which made Internet Explorer behave as it should.
CSS  IE7  table  td  width  size  dimension  bug  workaround  issue  problem  fix  web  design  webdesign  layout 
january 2011 by ebouchut

related tags

absolute  active  ActiveControler::Live  activemodel  ActiveModel::Model  activerecord  add  ajax  align  apple  ascending  ascii  association  attribute  automate  automatic  automation  backup  bandwidth  big  binary  block  boilerplate  bookmarklet  bootstrap  border  border-spacing  browser  bug  C  C++  cache  calculator  carbonfive  cassandra  cell  cf  change  char  character  chrome  CLI  closure  code  codeschool  color  column  columnfamily  command  comparison  condition  config  connect  connection  console  content  continuous  conversion  convert  converter  copy  CQL  create  creation  cross  css  CSV  cucumber  current  dalli  data  database  date  debug  decimal  decision  default  dependency  descending  design  desktop  developer  device  difference  digest  dimension  directory  display  dotfiles  dump  duration  dynamic  edit  editable  element  entity  entry  error  etags  event  excel  executable  exist  export  extract  family  feature  field  file  filter  find  finder  firefox  fix  fixed  flag  flash  form  framework  free  french  from  gem  generate  generator  GFM  github  go  google  graphic  greasemonkey  hack  hash  header  hex  hexa  hexadecimal  hidden  hide  HTML  huge  id  identifier  ie  ie6  ie7  if  image  improvement  includes  index  info  information  inline  inner  innerouter  insert  inspect  inspector  interruption  introduction  iphone  issue  java  javascript  JIRA  join  jquery  kafka  kafkastreams  key  keyboard  kstream  kstreams  ktable  large  layout  ldd  ldmobile  learn  left  lengh  less  library  link  list  load  local  mac  macos  mapping  markdown  markup  materialized  math  maven  max  measure  memory  migrate  migration  mobile  model  modify  module  monitor  multiple  mysql  name  naming  new  no  node.js  non  none  not  null  number  object  octal  of  online  order  outer  outline  page  parameter  performance  persist  pg  phone  PHP  pipe  plugin  plural  position  postgres  postgresql  PR  preload  present  presentation  prevent  problem  process  processing  property  psql  pull  Python  query  rails  rails4  railsv  README  record  recursive  reference  references  relation  relative  remote  remove  request  resize  responsive  right  rolling  ror  route  row  ruby  rubyonrails  save  scala  schema  scope  screencast  script  scroll  scrolling  search  select  session  shared  sidebar  singular  size  slow  solution  sort  spacing  speed  spreadsheet  spring  sql  starred  stream  streaming  string  strong  sub  subquery  table  table-of-content  tablet  tabular  td  test  text  time  timer  tips  title  TOC  tool  top  tr  track  trigonometry  turbolinks  tutorial  unicode  unit  update  URL  use  variable  video  view  viewport  vim  vimrc  visual  web  webdesign  where  width  wiki  window  workaround 

Copy this bookmark: