Databases
StackOverflow2013
Postsdbo
POCreating charts from sql files
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCreating charts from sql files
    primarykey
    data
    text
    <p>I have a sql file containing information about a potential clients website keywords. I have exported this file from an ipad SEO app and got a sql file. I would like be able to show the information as charts or tables but Ive never worked with this file format before. Are there any good programs that can do this or is this a "hardcore programer task"?</p> <p>Thank you! </p> <p>Few lines taken from the sql file</p> <pre><code> SQLite format 3@ Ô Ô-‚% ‡‡bgÅÅ_tabledomainsdomainsCREATE TABLE domains (domain_name varchar(100), id INTEGER PRIMARY KEY, sort integer, country varchar(2))Å--Ågtablekeywords_historykeywords_historyCREATE TABLE keywords_history (position integer, date_added varchar(10), id INTEGER PRIMARY KEY, kid integer)^ÅatablekeywordskeywordsCREATE TABLE keywords (sort integer, domain_id integer, id INTÅÇ tablekeywordskeywordsCREATE TABLE keywords (sort integer, domain_id integer, id INTEGER PRIMARY KEY, keyword_text varchar(500), country varchar(2)) ÉÓ◊¬∞ñÉliving.seSE-unifiedsweden.seSEes√§k.seSE#virotell.seSE) mediaanalys.seSEapple.comUS˚˚≤£ìiT6 Ï› ¥ûÑo]D%÷¡•ëvW1·ƒ®˛ãtV)1hallm√∂bler malm√∂SE(#hallm√∂blerSE'/f√•t√∂ljer malm√∂SE%-belysning malm√∂SE#/ inredningskonsultSE"3heminredning malm√∂SE!% heminredningSE$belysningSE$Atr√§dg√•rds m√∂bler malm√∂SE3 tr√§dg√•rds m√∂blerSE+ soffbord malm√∂SEsoffbordSE-k√∂ksbord malm√∂SEk√∂ksbordSE$Avardagsrums m√∂bler malm√∂SE&amp;!f√•t√∂ljerSEsoffaSE3vardagsrums m√∂blerSE )m√∂bler malm√∂SEm√∂blerSE visitkortSE)webbutvecklingSE!webbdesignSE!web designSEadwordsSE ppcSE /sponsrade l√§nkarSE seoSE 3s√∂kmarknadsf√∂ringSE 3s√∂kmotoroptimeringSE !v√§rmepumpSE!abonnemangSEvirotellSE mobilSE teleSE ppcSE 3s√∂kmotoroptimeringSEseoSE apple )˚˚∏•íÄn\J9&amp;Ì⁄»∂§íÄn\J8&amp;Ó€…∑•ìÅo]K9'ÒfiÀ∏¶îÇp2!2013-02-07 1!2013-02-070!2013-02-07/!2013-02-07 .! 2013-01-24-!2013-01-24,!)2013-01-24+!2013-01-24 *!2013-01-24)!2013-01-24(!2013-01-24 '!2013-01-23&amp;!2013-01-23%!2013-01-23 $!2013-01-23#!2013-01-23"!2013-01-23 !!2013-01-11 !2013-01-11!2013-01-11! 2013-01-11!2013-01-11!)2013-01-11!2012-12-24!2012-12-24!2012-12-24!2012-12-24!2012-12-24!2012-12-24!2012-12-24 !2012-12-24!2012-12-24!2012-12-24 !2012-12-19 ! 2012-12-19!2012-12-19!%2012-12-19 !2012-12-16!'2012-12-16 ! 2012-12-16 !2012-12-16 !2012-12-16!2012-12-16!2012-12-16!2012-12-16!2012-12-14!)2012-12-14 ! 2012-12-14! 2009-06-05! @2009-2 2pÓ‹À∏•íÄn\J9&amp;Ì⁄»∂§íÄn\J8&amp;Ó€…∑•ìÅo]K9'ÒfiÀ∏¶îÇp2!2013-02-07 1!2013-02-070!2013-02-07/!2013-02-07 .! 2013-01-24-!2013-01-24,!)2013-01-24+!2013-01-24 *!2013-01-24)!2013-01-24(!2013-01-24 '!2013-01-23&amp;!2013-01-23%!2013-01-23 $!2013-01-23#!2013-01-23"!2013-01-23 !!2013-01-11 !2013-01-11!2013-01-11! 2013-01-11!2013-01-11!)2013-01-11!2012-12-24!2012-12-24!2012-12-24!2012-12-24!2012-12-24!2012-12-24!2012-12-24 !2012-12-24!2012-12-24!2012-12-24 !2012-12-19 ! 2012-12-19!2012-12-19!%2012-12-19 !2012-12-16!'2012-12-16 ! 2012-12-16 !2012-12-16 !2012-12-16!2012-12-16!2012-12-16!2012-12-16!2012-12-14!)2012-12-14 ! 2012-12-14! 2009-06-05! @2009-06-01 !¶Ó‹ ∏¶îÇo]K'›À∏î¶Å9o]J8%Ó‹ ∏¶U!2013-02-180T!2013-02-18/S!2013-02-18.R!2013-02-18-Q!2013-02-18,P!2013-02-18+O!2013-02-18*N! 2013-02-18)M!2013-02-18(L!2013-02-18'K!2013-02-18&amp;J!2013-02-18%H!2013-02-18#F!2013-02-18!G!2013-02-18"D!+2013-02-18C!2013-02-18B!2013-02-18A!2013-02-18@!2013-02-18?!2013-02-18&gt;!2013-02-18I!2013-02-18$&lt;!2013-02-18;!2013-02-18:! 2013-02-189!2013-02-188!2013-02-077!2013-02-076!2013-02-075!2013-02-074!2013-02-073!2013-02-07 'VÌfl¡≤£ìiT6 Ï› ¥ûÑo]D&amp;÷¡•ëvW1·ƒ®˛ãtV)1hallm√∂bler malm√∂SE(#hallm√∂blerSE'/f√•t√∂ljer malm√∂SE%-belysning malm√∂SE#/ inredningskonsultSE"3heminredning malm√∂SE!% heminredningSE$belysningSE$Atr√§dg√•rds m√∂bler malm√∂SE3 tr√§dg√•rds m√∂blerSE+ soffbord malm√∂SEsoffbordSE-k√∂ksbord malm√∂SEk√∂ksbordSE$Avardagsrums m√∂bler malm√∂SE&amp;!f√•t√∂ljerSEsoffaSE1vardagsrumsm√∂blerSE )m√∂bler malm√∂SEm√∂blerSE visitkortSE)webbutvecklingSE!webbdesignSE!web designSEadwordsSE ppcSE /sponsrade l√§nkarSE seoSE 3s√∂kmarknadsf√∂ringSE 3s√∂kmotoroptimeringSE !v√§rmepumpSE!abonnemangSEvirotellSE mobilSE teleSE ppcSE 3s√∂kmotoroptimeringSEseoSE apple macUS [Ì”¡®ñ|[07sovrumsm√∂bler malm√∂SE/)sovrumsm√∂blerSE.sovrumSE-'mattor malm√∂SE,mattorSE+)matbord malm√∂SE*matbordSE </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USAbel
    1. USAbel
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POCreating charts from sql files
      1. This table or related slice is empty.
      1. VTUpMod
    1. COa sql file typically contains a series of database commands, which could be many different things. Could you edit your post to include what the first few lines of the sql looks like (you should be able to open it in any text editor)
      singulars
      1. POCreating charts from sql files
      1. USJonny Cundall
    2. CO@JonnyCundall added a few lines Jonny
      singulars
      1. POCreating charts from sql files
      1. USAbel
    3. CO@Abel: It looks like that is a series of database commands, and does not include any data. How do you expect to show data as charts or tables, if you don't actually have the data?
      singulars
      1. POCreating charts from sql files
      1. USJosef K
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload