Databases
StackOverflow2013
Commentsdbo
 
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
PostId
PostIdCreationDate
UserIdCreationDate
› search options
 
 

Note that there are some explanatory texts on larger screens.

plurals
  1. COI upvoted Sven's answer but just a little note: using the WebBrowser component is quite manageable, and in fact, it's intended for exactly this kind of use (embedding in application UIs). You can point the browser control at a URL, sure, but you can also exactly specify the content it contains, respond to events, and so forth. There's even an embedded resource protocol/scheme (res://) which you can use to reference embedded resources. But obviously if the Flash component itself is clean, that's a better way to go :)
    primarykey
    data
    text
    singulars
    1. PODisplaying Flash content in a C# WinForms application
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
  2. COLomaxx: *Fiddler is for HTTP. *Headers, url, params are all good *Have to contact our corporate admins and see if they're feeling nice enough to look at the logs
    primarykey
    data
    text
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
  3. CO@svec Because the source code is for distribution, and many of those who use it don't have Boost, and can't or don't want to download and build Boost. But some of the libraries are slated for inclusion so that's good. Should've happened 5 years ago, but hey. By all means.
    primarykey
    data
    text
    singulars
    1. POEasy-to-Use Regular Expression Support in C++?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
  4. COIt doesn't look that difficult to port one of the FOSS options on that page to Python. I know it's not the answer you want, but I couldn't find a Python one either.
    primarykey
    data
    text
    singulars
    1. POPure Python library to generate Identicons?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
  5. COAgree! No self-respecting C compiler will ever do this. SILENTLY OVERFLOW BABY! And we wouldn't have it any other way. This is what's great about C, after all.
    primarykey
    data
    text
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
  6. COAre you interested in using a framework or libraries, or are you just interested in knowing how to implement a custom caching solution?
    primarykey
    data
    text
    singulars
    1. POHow do I implement a HTML cache for a PHP site?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
  7. COAgree, only use _T macros if you want generic text, i.e., the ability to code for both Unicode and Ascii/MBCS.
    primarykey
    data
    text
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
  8. COClose, but not available on XP y deafult. Though I will consider it.
    primarykey
    data
    text
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
  9. COYes, I know I could _write_ such a thing. The idea is to reuse any available resources and to simplify sharing of the script.
    primarykey
    data
    text
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
...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