Databases
StackOverflow2013
Postsdbo
 
Search
scanning

Scanning is the default search option for small tables.

Enter text here to perform a scan over supported column types.

Text columns with limited length use a substring search If the entered text is a number, integer columns will be scanned for an exact match of the value.

The scanning search option is disabled for large tables.

seeking

Seeking is the default search option for large tables.

Seeking requires indexes and can only be done using the column (or columns) the index is defined on.

In the single-column case, the database will seek to the position the entered search term would be at and return all rows greater or equal to that value.

In the multiple-column case, the above still applies to the column you supplied non-empty search text for. All previous columns, however, will be using an equality match.

Id
AcceptedAnswerId
CreationDate
FavoriteCountLastActivityDate
LastActivityDate
LastEditDate
LastEditorUserIdLastEditDate
ParentIdCreationDate
OwnerUserIdCreationDate
› search options
PostTypeIdCreationDate
ScoreLastEditDate
Title
ViewCountLastEditDate
 
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTWiki
    1. USMichael Myers
    1. USCommunity
  2. PO
    primarykey
    data
    text
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTWiki
    1. USTomalak
    1. USCommunity
  3. PO
    primarykey
    data
    text
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTWiki
    1. USTomalak
    1. USCommunity
  4. PO
    primarykey
    data
    text
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTWiki
    1. USskaffman
    1. USCommunity
  5. PO
    primarykey
    data
    text
    <p><a href="http://www.gnu.org/software/emacs/manual/html_node/elisp/index.html" rel="nofollow noreferrer">Emacs Lisp</a> is the extension language for the <a href="http://www.gnu.org/software/emacs/" rel="nofollow noreferrer">GNU Emacs text editor</a>, and in fact, most of the functionality of Emacs is implemented using Emacs Lisp. Users generally customize Emacs' behavior by adding Emacs Lisp statements to their .emacs, or writing separate packages. A guide to learning Emacs Lisp for non-programmers can be found <a href="http://www.gnu.org/software/emacs/emacs-lisp-intro/html_node/index.html" rel="nofollow noreferrer">here</a>.</p> <p>Emacs Lisp differs from most other lisps in two main ways:</p> <ol> <li>It has special features for scanning and parsing text, as well as features for handling files, buffers, arrays, displays, and subprocesses. This is due to the fact that it is designed to be used in a text editor</li> <li>It uses <a href="http://en.wikipedia.org/wiki/Scope_(programming)#Dynamic_scoping" rel="nofollow noreferrer">dynamic scope</a> as opposed to lexical scope. This was done very intentionally, the reasons are well explained in the <a href="http://www.gnu.org/software/emacs/emacs-paper.html#SEC17" rel="nofollow noreferrer">1981 paper</a> on Emacs.</li> </ol> <h2>Wisdom from the Stack</h2> <ul> <li><a href="http://stackoverflow.com/questions/154097/whats-in-your-emacs">What's in your .emacs?</a></li> <li><a href="http://stackoverflow.com/questions/41522/tips-for-learning-elisp">Tips for learning Elisp?</a></li> <li><a href="http://stackoverflow.com/questions/2241111/lisp-community-quality-tutorials-resources">Lisp Community - Quality tutorials/resources</a></li> <li><a href="http://stackoverflow.com/questions/2087532/troubleshooting-techniques-for-emacs-and-elisp">Troubleshooting techniques for Emacs and Elisp</a> </li> </ul>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTWiki
    1. USTrey Jackson
    1. USCommunity
  6. PO
    primarykey
    data
    text
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTWiki
    1. USTrey Jackson
    1. USCommunity
  7. PO
    primarykey
    data
    text
    <p><strong>Description</strong></p> <p>The Microsoft UI Automation Framework is a part of the Microsoft .Net Framework (from 3.0 on) that enables elements on the Windows Desktop to be manipulated programmatically regardless of the technology they were originally created by - although typically they will be WinForms, WPF or Silverlight applications. </p> <p>The principle uses of the UIAutomation Framework are creating Screen Readers, and Test Automation.</p> <p><strong>Resources</strong></p> <ul> <li><a href="http://msdn.microsoft.com/en-us/library/ms747327.aspx" rel="nofollow noreferrer">UIAutomation Framework on MSDN</a></li> <li><a href="http://blog.functionalfun.net/2009/06/introduction-to-ui-automation-with.html" rel="nofollow noreferrer">An Introduction to UI Automation</a></li> <li><a href="http://white.codeplex.com/" rel="nofollow noreferrer">Project White</a></li> </ul>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTWiki
    1. USSamuel Jack
    1. USCommunity
  8. PO
    primarykey
    data
    text
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTWiki
    1. USSamuel Jack
    1. USCommunity
  9. PO
    primarykey
    data
    text
    <p>This tag is for questions about migrating <strong>existing applications</strong>, or <em>legacy code</em>, from <a href="http://stackoverflow.com/questions/tagged?tagnames=vb6&amp;sort=info&amp;pagesize=50">Visual Basic 6</a> to a more modern platform. Unfortunately migration is usually a tricky task. The most common target platforms are <a href="http://stackoverflow.com/questions/tagged?tagnames=vb.net&amp;sort=info&amp;pagesize=50">VB.Net</a> and <a href="http://stackoverflow.com/questions/tagged?tagnames=c%23&amp;sort=info&amp;pagesize=50">C#</a>. </p> <p>Here are some typical motives for migration </p> <ul> <li>To use a more modern programming language for <strong>enhancements</strong>. <ul> <li>This will give some increase in productivity. </li> <li>This also keeps the developers happy, which is a valid business benefit in itself. There are <a href="http://forums.construx.com/blogs/stevemcc/archive/2008/03/27/productivity-variations-among-software-developers-and-teams-the-origin-of-quot-10x-quot.aspx" rel="nofollow noreferrer">bigger gains in productivity</a> from attracting and retaining <a href="http://www.joelonsoftware.com/articles/HighNotes.html" rel="nofollow noreferrer">good developers</a> than anything else. </li> </ul></li> <li>To use a <strong>fully supported</strong> programming stack. <ul> <li>Although the VB6 runtime is still <a href="http://msdn.microsoft.com/en-us/vbrun/ms788708.aspx" rel="nofollow noreferrer">fully supported</a> by Microsoft as part of Windows, many people worry that support will be dropped one day. The VB6 IDE is no longer supported. </li> </ul></li> </ul> <p><strong>Frequently asked questions</strong></p> <ul> <li><em>What is the best strategy for migration?</em> There are a range of different opinions, as can be seen from the <a href="http://stackoverflow.com/questions/tagged?tagnames=vb-migration&amp;sort=votes&amp;pagesize=50">questions tagged <code>vb-migration</code></a>! For what it's worth, here is a <a href="http://msdn.microsoft.com/en-gb/dd408373.aspx" rel="nofollow noreferrer">Microsoft UK page with their advice</a>. </li> <li><a href="http://stackoverflow.com/questions/507291/should-we-select-vb-net-or-c-when-upgrading-our-legacy-apps">Should we select VB.Net or C#?</a> </li> <li><a href="http://stackoverflow.com/questions/3319561/risks-around-relying-on-vb6-applications">What are the risks around continuing to rely on VB6 applications?</a> </li> <li><a href="http://stackoverflow.com/questions/400479/vb6-lives-forever-like-cobol">Will VB6 live forever like COBOL?</a></li> </ul>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTWiki
    1. USMarkJ
    1. USCommunity
...and more
 

Querying!

 
Guidance
A table list

Lists show table rows with slightly less information than detail views, therefore not requiring section labels.

This list shows the beginning of an entire table.

Search

Searching on lists works via indexes when the table is large. On the left you see input fields generated from viable indexes and an expandable report for all indexes that are unavailable for searching with the respective reasons.

Searching along indexes is called seeking and this is one of the main values that databases offer. The trivial alternative is scanning, which is potentially inefficient as it works by walking the entirety of the candidate rows to find the matches.

The offer to scan is given for small tables. Currently, this only works on text and integer columns and they are searched all at once.

Loading more

Loading more rows than the initial 10 results is also currently restricted to a single reloading of 100 entries.

A future version will keep auto-loading on scroll for tables that have suitable indexes.

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