Search.setIndex({objects:{},terms:{all:[0,1,3],code:[1,3,2],partial:[0,1],consider:[1,4],perl:[1,4],queri:[1,3],lack:1,dollar:1,focus:4,month:1,prefix:1,follow:[1,3],faster:1,row:[1,3],compact:1,whose:[1,3],depend:[1,3],system:[1,3],otherplac:0,sensit:1,graph:[1,3],friendli:1,send:[1,3],easiest:1,senoraforwindow:1,init:1,program:1,those:[1,4,3],under:1,gimli:[1,3],thursdai:1,timon:3,dex:[1,3],datafil:1,sourc:[1,4,3,2],everi:[1,3],string:[1,3],far:[1,4,3],none:1,unfamiliar:1,spool:[1,3],rownumb:3,parti:[1,3],govern:4,veri:[0,1,4,3],join:1,ticket:4,dbname:4,scriptlibrari:[1,3],tri:1,administr:1,level:1,did:1,gui:1,cmd:4,list:[0,1,4,3],"try":1,item:3,bloblimit:3,localhost:1,readkei:1,small:1,refer:3,recov:0,dir:1,enjoy:1,enterpris:1,impli:1,cap:1,longop:[1,3],ten:[1,3],maxtselctrow:3,discover:1,focu:1,past:[1,3],second:[1,3],design:[1,5,2],pass:1,download:1,histori:[1,3,2],tempest:3,append:0,even:[1,3],lesser:1,what:[1,3],appear:1,compar:1,gqlplu:1,preserv:1,advanc:1,"while":[1,3],find:[0,1,3],access:[1,3],abbrevi:[1,3],version:[1,4,3],channel:1,"new":[1,4,3],net:1,method:[1,3],serveroutput:3,metadata:[1,5,2],canali:[1,4],ongo:1,full:[1,3],behavior:[1,3],displai:[1,3,2],urlopen:3,gener:[1,3],error:[1,3],here:[1,3],all_constraint:1,wild:[2,3],explicitli:3,let:1,ubuntu:3,path:[1,3],along:3,becom:[0,1],modifi:[1,3],sinc:1,valu:[1,3],wait:1,box:1,search:[1,4,3,2],traumat:1,cern:4,neater:1,host:1,credit:3,unnotic:0,aliv:1,permit:1,action:1,extrem:1,chang:[1,3],user_tab_column:3,counti:1,linewrap:3,shorthand:3,extra:[1,4,3,2],appli:1,modul:[1,4,2],prefer:1,readlin:[1,3],apt:1,filenam:[1,3],unix:[1,3,2],marker:[1,3],instal:[1,4,3,2],establish:1,"_dir_schema":3,select:[1,3],regex:[1,3],plot:[1,3],sqlpython:[0,1,2,3,4,5],from:[1,4,3],describ:[1,5],would:[1,4,3],memori:1,distinct:1,fill:[1,3],injuri:1,regist:1,two:[1,4],next:[1,5],websit:1,few:1,live:[1,2],call:[1,4,3],usr:1,sessinfo:[1,3],handl:1,care:3,type:[1,4,3],until:[0,1,3],more:[0,1,3],sort:3,desir:1,datadictionari:1,relat:[1,4],notic:[0,1],enhanc:[1,2],flag:[1,3],indic:[2,3],sens:1,known:1,postgresql:[1,4,3,2],destin:[1,3,2],cach:1,must:[1,3],psql:[1,4,3],principl:1,account:1,word:1,err:1,restor:1,dep:3,alia:1,setup:4,work:[0,1,4,3],uniqu:[1,3],dev:1,cat:[0,1,3],annoi:[0,1,3],column:[0,1,3],remain:1,itself:[1,3],del:0,thin:1,meet:1,purpos:1,root:1,scatter:3,object_nam:[1,3],control:[1,3],all_trigg:1,sqlite:[1,4],prompt:[1,4,3,2],tab:[1,3,2],tar:1,scan:3,process:3,lock:1,sudo:1,catherinedevlin:[1,4],backslash:[1,3],accept:[1,3],high:1,tarbal:1,abort:3,twiki:4,explor:[2,3],put_lin:[1,3],onlin:[1,3],newcom:1,yet:[0,1,3],occur:1,alwai:[1,3],gcc:[1,3],autoprint:0,multipl:[1,3],hoc:1,filepath:3,rather:1,anoth:1,yasqlrc:1,spreadsheet:[1,3],"_dir_tablespac":3,write:1,how:3,pure:1,sid:[1,4,3],answer:[1,3],instead:[1,4,3],csv:[1,3],simpl:1,updat:[1,4],rollback:1,product:1,likewis:4,recogn:[1,3],get_ddl:1,attempt:1,max:3,clone:4,after:[0,1,3],resultset:3,sql_id:1,constraint:[1,3],befor:[1,5,3],wrong:[5,3],attent:1,retain:3,mai:[1,4,5,3],end:[0,1,3],user_index:1,data:[1,3,2],grow:1,mous:1,alloc:3,"short":[0,1,3],essenti:1,practic:1,ani:[1,4,3],bind:[0,1,3,2],gqlpython:1,favorit:1,correspond:1,greet:1,processor:1,issu:[1,4,3],inform:[1,4,5,3],"switch":1,preced:0,combin:[1,3],commit_on_exit:3,allow:[1,3],enter:[0,1,3],exclus:3,first:[0,1,3],someplac:1,order:[1,3],talk:1,includ:[1,3],oper:[1,3],help:[1,4,3],softwar:[1,4],clapper:1,gradual:0,over:1,tselect:3,orang:1,soon:4,tupl:3,econom:[1,3],paper:1,through:[1,3],keyboard:1,still:1,vari:[1,3],dynam:[1,3],paramet:[1,3,2],style:[1,3],tora:1,thank:1,fit:[1,3],myreport:1,gerald:[4,5],fix:1,clickabl:3,platform:1,window:[1,2],html:[1,3],curli:1,mail:[1,4],hidden:1,truli:1,analyzeobject:1,easier:1,ideal:1,them:[0,1,3],good:[1,3],"return":[1,3],greater:1,thei:[1,5,3],python:[1,4,3,2],spell:1,handi:1,initi:5,number:[1,3],"break":0,promis:1,cst:1,now:[1,3],comparestat:1,discuss:1,introduct:[1,4,2],choic:1,subqueri:3,mytabl:1,somewher:1,name:[1,4,3],trac:1,anyth:[1,3],edit:[1,3],off:[0,1,3],revers:3,devcent:1,separ:1,easili:[1,4],quest:1,exampl:[1,3],mode:3,arrow:[1,3],each:[0,1,3],debug:5,found:[1,3],higher:1,bone:1,mean:1,compil:1,recommend:1,all_tab_com:1,replac:[1,3],balint:1,continu:3,procedur:1,group:[1,4],wrap:1,varibl:3,expect:[1,3],drautzburg:1,year:1,our:1,beyond:1,extract:1,special:[0,1,3,2],baselin:1,variabl:[0,1,3,2],"2ubuntu7":3,space:[1,4,3],goe:5,crucial:1,publish:1,content:[1,3,2],rewrit:1,fairli:1,unsupport:[0,2],user_t:3,reader:1,print:[1,3],ref:[1,3],correct:1,dbms_output:[1,3],stat:1,appinfo:0,postgr:4,picklefil:5,navig:1,watermark:1,upon:[1,3],manipul:1,given:[1,3],free:[0,1,4],standard:[1,4,3],xml:[1,3],base:[1,4],believ:1,dictionari:[1,3,2],tempt:1,ask:1,org:[1,4],bash:3,ora:[1,4],precompil:1,titl:3,wai:[1,3],current_season:3,argument:[1,3],steal:3,could:[1,3],omit:[1,3],put:1,keep:1,motion:1,ljubomir:1,place:1,due:1,do_hello:1,unwis:3,"_user":1,confus:[0,1],licens:[1,4,3,2],frequent:1,testschema:3,origin:[1,4,2],pleas:4,directli:1,upper:1,feel:1,onc:[1,4,3],qualiti:1,scene:3,cmd2:4,yourself:1,mybind:3,date:1,unlik:[1,3],alreadi:1,done:4,wrapper:1,mistakenli:1,shortcut:[1,3,2],open:[1,4,3],primari:3,"10grac":3,avail:[1,4,3,2],differ:1,convent:1,script:[1,4,3,2],profil:1,top:[1,3],sometim:[1,5],messag:1,mercuri:3,attach:1,assort:1,necessarili:[1,3],too:[1,3],statement:[0,1,3],similarli:1,termin:[1,3],conveni:[1,3],"final":[1,3],store:[1,5],schema:[1,3],shell:[1,3],option:[1,3],especi:1,tool:[1,3,2],copi:[0,1,3],setuptool:[1,4],took:1,specifi:[1,4,3],"10g":1,part:[1,4,3],pars:[0,1,2],def:1,store_tru:1,exactli:3,than:[0,1,3],serv:3,wide:3,liter:1,myscriptlibrari:1,grep:[1,3],target:[1,3],whenev:0,provid:[1,5],remov:1,crave:1,structur:[1,3],charact:[1,3],project:[0,1,4],matter:1,posix:1,frankli:1,were:[1,3],posit:1,elfi:1,make_opt:1,thu:[1,4,3],seri:3,pre:0,shakespear:3,comput:[0,1],rac:[1,3],sam:[1,3],mind:1,anywher:1,direct:1,packag:[1,4],width:3,complet:[1,5,3,2],have:1,tabl:[0,1,3,2],target_text:1,take:[1,5],built:1,lib:1,commmand:1,rout:1,"_connect_identifi":1,port:4,note:[1,5,2],also:[1,4,3],unawar:1,without:[0,1],read:[1,3],"_dir_view":3,which:[1,5,3],neaten:[1,3,2],environ:[1,3],librari:[1,4],maxf:3,mit:4,singl:[0,1,3],uppercas:1,compat:1,begin:[0,1,3],sure:1,distribut:[1,3],plenti:1,preliminari:5,buffer:[1,3],object:[1,3],oracl:[1,4,3,2],chart:[1,3],continuation_prompt:3,most:[1,4,3],plai:3,regular:[1,3],whether:[0,1,3],plan:[1,3],letter:1,insul:1,neatli:1,homepag:4,equival:[1,3],other:[1,4,3],give:1,bzr:3,filesystem:3,url:[1,4],doc:4,clear:[0,1],cover:1,face:1,pipe:[1,3],abbrev:1,bracket:[0,1],determin:[0,1,3],databas:[1,4,5,3],autobind:[1,3],enclos:[0,1],usual:1,microsoft:[1,4],fact:1,gain:1,dbi:1,onward:[1,3],autotrac:0,agamemnon:3,index:[1,2],show:[1,3],carefulli:1,text:[0,1,4,3],redirect:1,dbd:1,syntax:[1,4,3],bring:[1,3],session:[1,5,3],permiss:3,last_ddl_tim:[1,3],label:[1,4],anywai:0,feedback:0,involv:5,current:[1,4,3],onli:[1,3],slow:[0,2],synonym:1,just:[1,3],copyright:3,menu:1,explain:[1,3],configur:1,releas:[1,4],behind:3,should:[0,1],experiment:1,analyz:1,rich:1,tune:[1,3,2],local:[1,3],vigor:1,info:[1,3],yasql:[1,4],hit:[1,3],contribut:1,get:[0,1,5,3],familiar:[1,4],express:[1,3],broadest:1,aim:3,cannot:[1,3],report:[0,1,4,3],nathan:1,requir:1,xclip:1,uncomfort:1,homegrown:1,bar:[1,3],enabl:3,artist:1,legola:[1,3],cstatement:1,"public":1,"default":[1,3],orcl:[1,3],blogspot:[1,4],common:1,though:[1,4,3],contain:[1,3],privileg:1,telecommun:1,where:[0,1,3],seamlessli:1,view:[1,4,3],respond:1,column_wildcard:1,set:[0,1,3],dump:3,startup:1,dependn:3,see:[1,3],sed:1,bare:[1,3],result:[1,3],arg:1,buturov:1,close:1,improv:[1,4],nonstandard:3,best:1,gmail:4,statu:1,defin:[0,1,3],kei:[1,3],correctli:0,hopefulli:5,down:[1,3],pattern:1,review:1,ubiquit:1,urllib:3,yasl:1,enough:3,restructur:3,between:[0,1,3],"import":[1,3],awai:1,experi:1,approach:1,across:1,attribut:[0,3],altern:[1,4,2],xplain:1,str:[1,3],extend:[1,3,2],cachestat:1,screen:3,sho:1,pypi:[1,4],extens:[1,4],job:1,entir:[1,3],matplotlib:1,otherwis:3,distinguish:3,lregist:1,come:1,embed:[1,3],incomplet:1,popul:[1,3],paramnam:3,last:[1,3],expos:3,plugin:1,rlwrap:1,someth:5,howev:[0,1,5,3],immers:1,alon:3,cincyshak:3,foreign:[1,3],april:1,capabl:[1,4,3,2],instanc:[1,3],scripthost:3,mani:[1,3],login:1,timesort:3,whole:1,con:[1,3],comment:[1,3],tnsname:4,simpli:[1,3],author:[1,3],can:[0,1,4,3],tgz:1,format:[0,1,3,2],inher:1,poo:1,creat:[1,4,3],written:[1,3],littl:1,linux:1,respect:[1,3],guid:1,assum:[0,1],duplic:1,quit:[1,3],default_file_nam:3,union:3,west:1,three:1,been:[1,4],rephead:0,json:[1,3],much:[0,1,3],interpret:[0,1,3],interest:[1,5],modif:1,addit:[1,4,3],r252:3,fals:3,all_col_com:1,remaind:[1,3],squirrel:1,both:[1,3],imag:3,summari:[1,2],fkeyindex:1,remark:[0,1],uncommon:1,defect:1,tiger:1,unzip:1,els:3,repetit:1,educ:1,present:[1,4],statist:1,"case":[1,3],multi:0,save:[1,3],look:[1,5],gnu:1,plain:1,top9i:[1,3],sourceforg:1,alter:1,cursor:1,admin:1,invok:[1,3],neat:1,smart:[1,3,2],abov:1,decept:1,fun:1,jdevelop:1,anonym:[0,1],higer:1,everyon:1,bin:[1,4],file:[1,4,3],stdout:1,almost:1,oracle_hom:1,sqlprompt:1,readm:1,non:[1,4,3,2],activ:[1,3],need:[1,3],archiv:0,textfil:1,conf:1,synopsi:1,unneed:0,ship:1,sever:[1,3],"_dir_index":3,fki:1,oci:1,develop:[1,4,5],welcom:[0,1,4,2],grant:1,perform:1,suggest:1,make:1,quirk:[1,2],cross:[1,2],same:[1,3],freeli:1,binari:1,drawback:[1,2],document:[1,4,3,2],mysqlpi:[1,3],twelfth:3,difficult:1,appreci:1,finish:[0,1],http:[1,4,3],hostnam:4,again:3,sqlython:1,wherea:1,effect:[1,3],disconnect:0,column_nam:1,nix:3,user:[1,5,3],ownership:1,opinion:0,extern:1,immedi:1,easygo:1,expand:1,recent:[1,4,3],safe:0,task:1,kept:1,center:1,com:[1,4,3],markup:1,page:[1,2],well:[0,1,4,3],versatil:1,honor:1,pickl:[2,5],person:1,client:[1,4,3],command:[0,1,4,3,2],expens:1,thi:[0,1,4,5,3],choos:1,undefin:0,everyth:0,self:1,latest:4,load:[1,3],pssgroup:4,identifi:1,entri:[1,4,3],execut:[1,3],less:1,"true":3,when:[0,1,5,3],pylab:1,rest:3,collabor:1,align:[1,3],rdbm:[1,4,3,2],kill:1,virtual:1,mysql:[1,4,3],volunt:4,speed:1,renam:1,languag:1,web:[1,3],downright:1,cluster:[1,3],quieri:1,easi:[1,4],hint:1,danger:1,had:1,except:1,param:3,desktop:1,add:1,myscript:1,blob:[2,3],exercis:1,newmemb:1,input:[0,1],subsequ:[4,3],approxim:1,match:[1,3],build:1,earli:1,applic:1,inspir:[1,4,3],ctrl:3,around:[0,1],transpar:[1,5],webpag:1,incorpor:1,untar:1,afiedt:3,term:1,realiz:1,cpan:1,know:3,csv_x:1,authorship:[2,4],password:[0,1,4],dba:1,python2:1,table2:3,insert:[1,3],xqueri:1,all_sourc:1,repfoot:0,specif:1,bashrc:1,brace:1,incred:1,orlando:1,integ:1,server:[1,4],aeschylu:3,collect:5,benefit:4,dbms_metadata:1,unstabl:4,either:3,night:3,popular:1,output:[0,1,3,2],resiz:1,realiti:1,manag:1,underli:1,encount:1,www:[1,4,3],didn:3,old:1,often:1,wildsql:[1,3],acknowledg:[1,2],webserv:3,interact:[1,3],some:[1,5],back:1,xpk_parti:1,sampl:1,nonetheless:1,subst:3,march:1,tablespac:1,trust:1,rollseg:1,charg:1,redo:1,avoid:[1,3],exec:[0,1,3],sql_echo:3,glogin:1,usernam:[1,4,3],substitut:[1,3,2],tracker:[0,1],exit:[1,3],ddl:1,necessari:[1,5],reproduc:[1,3],trunk:4,jrrt:[1,3],machin:[1,4,3],core:1,particular:1,who:1,run:[1,4,3,2],timeout:3,power:[0,1],cha:[1,3],acronym:1,reach:1,inspect:1,usag:1,viabl:1,devlin:[1,4],sqlpytyhon:1,step:1,senora:[1,4],repositori:[1,3],preferenti:1,feb:1,cornerston:1,assembla:[0,1,4],earlier:[1,5],stage:1,crippl:0,about:[0,1],sra:1,actual:[1,3],gnome:3,world:1,valid:1,transpos:[1,3],party_report:3,do_greet:1,scott:1,unfortun:1,catherin:[1,4],estim:1,act:3,table_nam:[1,3],commit:3,produc:1,block:[0,1],do_:1,matur:1,routin:5,own:[1,3],desc:[1,3],within:[1,3],profession:1,easy_instal:[1,4],automat:[1,3],appropri:3,stop:0,right:[1,3],contributor:4,claus:1,all_object:1,hang:1,your:[1,4,3],inclus:3,git:3,statistict:1,log:[0,1],bazaar:3,ergonom:1,support:[1,4],question:[1,3],"long":[0,1,3,2],custom:1,like:[1,3,2],start:1,reli:5,trigger:1,interfac:[1,4],editor:[1,3],suit:1,"var":[1,3],xxxx:1,individu:[0,1],slight:4,etc:[1,3],"function":[1,4,3],head:[1,3],larri:1,gzip:1,form:[1,4,5],offer:[1,3],forc:1,great:1,opt:1,basic:1,jul:3,idea:1,link:[1,3,2],translat:1,newer:1,don:[1,3],line:[0,1,4,3,2],stand:0,buf:3,bug:[0,1,4,2],longer:0,suppli:1,pull:[1,4,3],hire:1,made:5,possibl:[1,3],arrays:0,wish:1,dml:1,maximum:3,maxfetch:3,tell:1,object_typ:[1,3],limit:[0,1,2],absenc:1,rerun:1,site:1,highlight:1,problem:[0,1],easyinstal:1,similar:1,email:1,connect:[0,1,4,5,3],linux2:3,featur:[0,1,3],"_dir_tabl":3,pin:1,"int":[1,3],request:0,dure:[1,5],all_tab_column:[1,3],pie:[1,3],repres:4,btitl:0,ana:1,implement:5,kozman:1,xvalid:1,exist:1,doe:[1,3],simplest:1,probabl:[1,3],echo:[1,3],denot:1,readi:[1,3],googl:4,want:1,against:[1,4,3],todo:3,sqlplu:1,excel:1,detail:[1,5],invalid:1,declar:[1,3],futur:1,rememb:[1,3],varieti:1,test:4,you:[1,4,5,3],out:1,architectur:1,node:[1,3],autocommit:0,draw:4,hwm:1,intend:5,wildcard:[1,3],all_tabl:3,toad:1,sequenc:[1,3],symbol:3,introduc:1,athen:3,luca:[1,4],frodo:[1,3],briefli:1,insensit:[1,3],track:1,peak:1,consid:0,sql:[0,1,4,3,2],shafer:1,ago:1,experienc:1,imit:1,session_longop:1,furthermor:1,paus:0,directori:[1,3],reliabl:3,martin:1,descript:[1,3],scroll:[1,3],wenora:1,postresql:1,ignor:3,assign:1,potenti:1,time:[1,5,3],plu:[0,1,4,3,2],fresh:5,decemb:1,sqlcmd:1,hello:1},objtypes:{},titles:["Limitations","Long Live the Command Line: SQL*Plus and Alternatives","Welcome to SQLPython’s documentation!","SQLPython’s extra capabilities","Introduction","Design Notes"],objnames:{},filenames:["limitations","comparison","index","capabilities","intro","design"]})