Put:

    .headers on
    .mode column

In a file called `.sqliterc` in the home directory of the user running sqlite.

(P.S. I found that in `man sqlite3`.)



Make sure using the following command to open the file:

    nano ~/.sqliterc


then add
    
    .headers on
    .mode column


to the file and save it


I&#39;ve googled endlessly for a method of getting a complete (and daily updated) list of all Yahoo ticker symbols available through http://finance.yahoo.com

Yahoo has information for stocks, futures etc for a lot of exchanges worldwide, and I&#39;d like a combined list of all the ticker symbols available through them. I&#39;ve tried YQL but they have a &quot;where symbol = (or in)&quot; clause restriction so I cannot select * from symbols.

So basically, getting detailed information for a single symbol or several symbols at one time is easy but I just can&#39;t seem to find out how to get a list of all available tickers.

Can anyone help, please?

How to get a complete list of ticker symbols from Yahoo Finance?

First off, the barest bones of the project I wish to create is a wiki engine implemented as a single page web app. I plan on having a set of features available from the  get-go with plenty of feature additions down the road.

**Basic Features**

 - page creation (creates both wiki article and discussion forum for that article)
 - markup and WYSIWYG ala [markitup](http://markitup.jaysalvat.com/examples/markdown/)
 - on-the-fly conversion between markup / html / WYSIWYG
 - a side bar to quick navigate
 - a top toolbar for choosing edit/view

**Advanced Features**

 - configurable side bar to navigate via different method
 - configurable toolbar (possibly add markup language of choice)
 - tags
 - editable todo&#39;s
 - drag and drop file uploads and image attachments

The engine would originally consist of the most basic page creation, markup and WYSIWYG editing, and saving. I would eventually like to extend this basic engine with drag and drop image support, file uploads, live data graphs, and a sidebar for customizing views.



I have done a fairly extensive search for a decent project from which to base my project off, but other than TiddlyWiki there does not seem to be any good javascript based wiki engines. I also considered applying Jquery on top of existing wiki engines but I believe I would end up rewriting it eventually anyway (Plus its just more exciting to add the features I want as I go). Either way I have arrived at implementing this beast with a javascript library + framework. 

I know that one cannot really compare some of these frameworks against each other as they are very much not apples to apples. I have tried to frame any comparison comments/questions against comparable pieces of the respective frameworks but I am open to being corrected.

So here we go:

Based on my own research and opinions I have narrowed the list down to the items below. I intentionally left out things such as SproutCore, corMVC, YUI, and others as I, in my limited capacity, thought the below items would be a better fit.

**My Options**

 - [jquery](http://jquery.com/) + [jqueryUI](http://jqueryui.com/) + [backbonejs](http://documentcloud.github.com/backbone/)
 - [knockoutjs](http://knockoutjs.com/)
 - [javascriptMVC](http://www.javascriptmvc.com/)
 - [Dojo](http://dojotoolkit.org/)
 - [ExtJS](http://www.sencha.com/)
 - [Cappuccino](http://cappuccino.org/)

--------------------------------------------------------------------------------------

jquery/UI + backbonejs
----------------------

_Overall_

&gt; From what I&#39;ve read this combination is used and beloved by many and is very flexible and extensible. My major concern is that this combination is simply not the best jumping off point for developing the more desktop oriented UI interface. 

_UI_

&gt;While jQueryUI or jqueryTools might be competitive they certainly do not seem to be on-par with the UI capabilities of other frameworks. Specifically they seem to be heavy on the effects but lacking on decent layout slicing support.

javascriptMVC
-------------

_Overall_

&gt; JavascriptMVC to me looks like it is essentially jquery + MVC(jqueryMX) extensions, along with a few other apps for documenting(documentJS), functional tests(funcUnit), and code and dependency management(stealJS). Beyond the benefits of the additional module, I think the functional debate really comes down to backbonejs vs. jqueryMX Am I correct on this and has anyone worked with or compared both?
&gt;&gt; - Features: jupiter&#39;s (maker of jMVC) overview of their [features](http://jupiterit.com/news/javascriptmvc-features)
&gt;&gt; - Link to [jqueryMX](https://github.com/jupiterjs/jquerymx)

_UI_

&gt;JavascriptMVC adds the [MXUI](https://github.com/jupiterjs/mxui) items on top of whatever is available for Jquery so I think at the very least it is a slight win in that category. 

knockoutjs
----------

_Overall_

&gt; My thoughts and concerns on this on this are very similar to the jquery + backbone comments. They both seem to offer similar features but just from a different perspective. An oft cited downside is that knockoutjs couples business logic and presentation too tightly with the data-bind&#39;s and that this binding method can break down for complex UI interaction but I would love to hear why that is a non-issue.
&gt;&gt; - [Discussion](http://news.ycombinator.com/item?id=1810665) of backbone vs knockoutJS concepts
&gt;&gt; - [Features](http://blog.stevensanderson.com/2010/07/05/introducing-knockout-a-ui-library-for-javascript/) of knockoutjs

_UI_

Blank at the moment



Dojo &amp; ExtJS
------------

_Overall_

&gt; I am going to combine the discussion Dojo and ExtJS because I know the least about them and they seem to play in nearly the same space. Most of the information on stackoverflow about these two seems to be out-of-date. From what I have seen is that they are both large frameworks that are good for desktop caliber app implementation. Dojo had been chided for poor documentation but that seems to be no longer the case. ExtJS of course has the commercial license, but it is really reasonable for what you get and I wouldn&#39;t hold that against it too much. The widgets in ExtJS seem to be somewhat more professionally done than Dojo, but I could certainly be corrected there. I would be interested to hear from anyone who has experience in both.

_UI_

&gt;Dojo has the [dijit](http://dojotoolkit.org/reference-guide/dijit/index.html) UI library 
&gt;ExtJS has UI features but they are not in Ext core. Here&#39;s the [documentation](http://dev.sencha.com/deploy/dev/docs/) and here are their [demos](http://www.sencha.com/products/extjs/examples/)

Cappuccino
----------

_Overall_

&gt; And then there is Cappuccino. No CSS, no html, but also it could be tough to use existing javascript libraries. Objective-J doesn&#39;t seem to scary, especially considering that they tout being able to write plain javascript as well. The demos are impressive and seem to closely approach the UI needs for the wiki engine. The cocoa based API is a lot to take in for someone not familiar with it, but maybe it is worth it. I have heard the layout engine is not always easy to work with but a young and possibly disruptive tech like this will certainly have some shortcomings.

_UI_

&gt;Blank at the moment

I apologize for writing so much but hey, at least its not a x vs y vs z question hoping for tons of cheap answers. So what do you think? What should be the basis for my desktop like wiki engine, that will hopefully become more feature rich (read complex) over time?




Where am I wrong about my project and these Javascript Frameworks?

we know when type `.mode column` let me see tables like column 
And `.headers on` , we can see the header of tables.
But I want to know if there is any way make the two default settings? 

Do some modify for the source code of sqlite??
OR is there a config file for these settings? 

Change SQLite default settings

<p>we know when type <code>.mode column</code> let me see tables like column
And <code>.headers on</code> , we can see the header of tables.
But I want to know if there is any way make the two default settings?</p>
<p>Do some modify for the source code of sqlite??
OR is there a config file for these settings?</p>


My database is about 25 MB, and I&#39;ve verified that the username accessing it, as well as the file permissions haven&#39;t changed in months. I&#39;m having a problem where queries are failing due to a &quot;database or disk is full&quot; and then sometimes &quot;database disk image is malformed&quot; issue.

Unless I&#39;m reading this wrong, my disk isn&#39;t anywhere near full (this is an Ubuntu server, 9.10, if it makes any difference)

    Filesystem           1K-blocks      Used Available Use% Mounted on
    /dev/sda1             19610300   2389596  16224560  13% /
    udev                     10240       128     10112   2% /dev
    none                    254136         0    254136   0% /dev/shm
    none                    254136        36    254100   1% /var/run
    none                    254136         0    254136   0% /var/lock
    none                    254136         0    254136   0% /lib/init/rw

As a test I just did an action that added a new record, and it&#39;s fine. I&#39;m trying to fiqure out if there&#39;s a specific set of actions that are failing. However, after the insert (and verifying that it&#39;s there) the number of bytes on disk for the database has not changed (neither up nor down).

Using the command line utility results in something like the following, which is failing spectacularly :)

    SQLite version 3.6.12
    Enter &quot;.help&quot; for instructions
    Enter SQL statements terminated with a &quot;;&quot;
    sqlite&gt; pragma integrity_check;
    *** in database main ***
    On tree page 2 cell 0: 2nd reference to page 26416
    On tree page 2 cell 1: 2nd reference to page 26417
    On tree page 2 cell 2: 2nd reference to page 26434
    On tree page 2 cell 3: 2nd reference to page 26449
    On tree page 2 cell 4: 2nd reference to page 26464
    On tree page 2 cell 5: 2nd reference to page 26358
    On tree page 2 cell 6: 2nd reference to page 26494
    On tree page 2 cell 7: Child page depth differs
    On tree page 2 cell 8: 2nd reference to page 26190
    On tree page 2 cell 8: Child page depth differs
    
    ... etc., etc. ...


Any ideas on where I should be looking next? Is there a problem with the maximum number of rows in a table or something? I did some reading on SQLite3 max values, and nothing in my database is anything close to them as far as I can tell.

I then took a look at my daily backups, and I see that the database backup hasn&#39;t changed in file size for 3-4 days - very strange. I restored a backup copy of the database from before the time it was not changing in file size, and still getting strange issues.

I&#39;m thinking I&#39;m going to have to (1) restore from an older backup, and (2) re-run my Rails migrations to fix.


SQLite3 database or disk is full / the database disk image is malformed

I&#39;ve been trying to get foreign keys working within my Android SQLite database. I have tried the following syntax but it gives me a force close:

    private static final String TASK_TABLE_CREATE = &quot;create table &quot;
    			+ TASK_TABLE + &quot; (&quot; + TASK_ID
    			+ &quot; integer primary key autoincrement, &quot; + TASK_TITLE
    			+ &quot; text not null, &quot; + TASK_NOTES + &quot; text not null, &quot;
    	+ TASK_DATE_TIME + &quot; text not null, FOREIGN KEY (&quot;+TASK_CAT+&quot;) REFERENCES &quot;+CAT_TABLE+&quot; (&quot;+CAT_ID+&quot;));&quot;;

Any ideas what I might be doing wrong? if you need to see the other table structure then I can, its just a very simple structure for the second with an ID and a name.


**Edit:** 

Here is the error:

&gt; 03-13 13:42:35.389:
&gt; ERROR/AndroidRuntime(312): Caused by:
&gt; android.database.sqlite.SQLiteException:
&gt; unknown column &quot;taskCat&quot; in foreign
&gt; key definition: create table reminders
&gt; (_id integer primary key
&gt; autoincrement, task_title text not
&gt; null, notes text not null,
&gt; reminder_date_time text not null,
&gt; FOREIGN KEY (taskCat) REFERENCES
&gt; category (_id));



SQlite - Android - Foreign key syntax

I need to convert a table from MySQL to SQLite, but I can&#39;t figure out how to convert an enum field, because I can&#39;t find `ENUM` type in SQLite.

The aforementioned field is `pType` in the following table:

    CREATE TABLE `prices` (
    	`id` INT(11) NOT NULL AUTO_INCREMENT,
    	`pName` VARCHAR(100) NOT NULL DEFAULT &#39;&#39;,
    	`pType` ENUM(&#39;M&#39;,&#39;R&#39;,&#39;H&#39;) NOT NULL DEFAULT &#39;M&#39;,
    	`pField` VARCHAR(50) NULL DEFAULT NULL,
    	`pFieldExt` VARCHAR(50) NULL DEFAULT NULL,
    	`cmp_id` INT(11) NOT NULL DEFAULT &#39;0&#39;,
    	PRIMARY KEY (`id`)
    )
    ENGINE=MyISAM
    ROW_FORMAT=DEFAULT

I need a field with only three values for the user to chose, and I would like to enforce that in the DB, not just in my application.

How to create ENUM type in SQLite?

I&#39;m trying to use the statement `SELECT TOP 1 * FROM tasks WHERE dueDate &lt; ?1 ORDER BY dueDate DESC` but SQLite says `near &quot;1&quot;: syntax error`. What&#39;s wrong?

SQLite - SELECT TOP syntax error

I need to fetch the first/top row of a table in a Sqlite database. 

But my program throws an SQLException &quot;Sqlite Syntax Error: Syntax error near &#39;1&#39; &quot; for the query that I am using:

    SELECT TOP 1 * 
    FROM SAMPLE_TABLE

That I guess is a syntax particularly for MS SQL SERVER and MS ACCESS. Right now I am using.

    SELECT *
    FROM SAMPLE_TABLE
    LIMIT 1

What is the best solution for this problem?

Content Type	Original Author	Original Content on Stackoverflow
Question	aelam	View Question on Stackoverflow
Solution 1 - Sqlite	Sdaz MacSkibbons	View Answer on Stackoverflow
Solution 2 - Sqlite	DevB2F	View Answer on Stackoverflow

Change SQLite default settings

Sqlite Problem Overview

Sqlite Solutions

Solution 1 - Sqlite

Solution 2 - Sqlite

Where am I wrong about my project and these Javascript Frameworks?

How to get a complete list of ticker symbols from Yahoo Finance?

Attributions