sql   75154

« earlier    

jOOQ: The easiest way to write SQL in Java
jOOQ generates Java code from your database and lets you build type safe SQL queries through its fluent API.
database  sql  java  library  object-oriented  hibernate  alternative  oo 
yesterday by rsewan
Git Your SQL Together (with a Query Library) – Haystacks

1. You will *always* need that query again
2. Queries are living artifacts that change over time
3. If it’s useful to you, it’s useful to others (and vice versa)
git  sql  data.science  curation 
yesterday by po
Add a date to a SQL*Plus spool file name
sqlplus user/password
col spoolname new_value spoolname

select 'invoice_'||to_char(sysdate, 'yymmdd') spoolname from dual

spool '&spoolname'

select stuff . . . .
spool off
oracle  database  sql  spool  date  time 
yesterday by iteruel
Git Your SQL Together (with a Query Library) – Haystacks
Focusing on these points has led to my continuous adoption of a query library -- a git repository for saving and sharing commonly (and uncommonly) used queries, all while tracking any changes made to these queries over time. 
datascience  sql  git 
2 days ago by carlosviansi
SQL Indexing and Tuning e-Book for developers: Use The Index, Luke covers Oracle, MySQL, PostgreSQL, SQL Server, ...
SQL indexing and tuning tutorial for developers. No unnecessary database details—just what developers need to know. Covers all major SQL databases.
database  learning  mysql  sql  programming_improvement_plan 
3 days ago by jonny
SQLite Administrator - International Milestone Beta
SQLite Administrator is a powerful tool if you easily want to create, design or administrate SQLite database files. The SQL code editor helps you to quickly write sql queries with features such as code completion and highlighting. Both major versions of SQLite database files are supported by SQLite Administrator.
SQL  Calibre  ebooks 
3 days ago by brysmi

« earlier    

related tags

2016  2017  510  ai  alternative  analytics  anthro  apache  app  article  authorisation  azure  bash  bestpractices  blockchain  book  browser  calibre  ccl  cerner  cheatsheet  cheatsheets  checker  client  clojure  comparison  costs  curation  cve  d365fo  data.science  data  data_mining  data_visualisation  dataanalysis  database  databases  dataframe  datascience  date  db  dba  diagram  distinct  distributed  diy  drupal  drupal7  dwh  ebooks  editor  environment  file  floss  foreach  games  generator  git  go  golang  graph  hacking  hibernate  howto  htap  hybrid  injection  inner  insert_into  interactive  intro  java  javascript  jira  join  js  learn  learning  left  library  lint  malware  microsoft  migration  mongodb  ms  mssql  mysql  n:m  nested  node-js  normalization  nosql  object-oriented  oltp  oo  opensource  oracle  orm  outer  pad  papers  performance  permissions  plan  postgres  postgresql  procedure  programming  programming_improvement_plan  pull  python  query  rails  rdbms  realtime  reference  relational  reporting  right  rlang  rtz  ruby  scala  security  server  so  software  sp_msforeach_worker  spool  spreadsheet  sqlite  stackoverflow  stored  struct  syntax  theory  thoughtbot  tidb  time  timeseries  tips  tool  toolbox  tools  trainer  transactional  tutorial  type:course  utility  verifier  views  visualization  walk  window  wts  zeppelin  zstandard  zstd 

Copy this bookmark: