Skip to content

Database Query

Database Query

Every DPD headword is a row in a database, and every part of it — the lemma, the part of speech, the meaning, the construction — is a column in that row. The Database Query tab searches those columns directly, so you can find words by what their fields contain, not only by their spelling.

For example: every masculine noun whose lemma starts with dhamma, or every word whose construction contains the root √dhar.

Opening the Tab

Click on the Database Query tab in the top left corner of the web page to open it. It is the fourth tab, after DPD, CST Bold Definitions and Tipiṭaka Translations.

Database Query tab Database Query tab

You can also open it directly at www.dpdict.net/?tab=dq.

Filters

Each filter has three parts: the field to search, the search type, and the value to look for.

Three filter rows with an or group Three filter rows with an or group

The field is the name of a database column, such as lemma_1, pos or meaning_1. Start typing and choose one from the list. The search types are:

  • contains — the value appears anywhere in the field.
  • starts with — the field begins with the value.
  • ends with — the field ends with the value.
  • regex — the value is a regular expression, for power searches.

Searches are case-sensitive: in lemma_1, dhamma finds dhamma 1.01, while Dhamma finds nothing.

Click + filter to add a row, and the × at the end of a row to remove it. You can use up to ten filters.

and / or

The selector at the start of each row joins it to the row above. and means both must match. or starts a new group, which is set apart by a dashed line, so

a and b or c and d

means (a and b) or (c and d).

In the picture above, the search finds every masculine noun whose lemma starts with dhamma, or any word whose lemma starts with buddh.

Results

Press search to run the query. The results appear below as a table, one row per headword, with the columns you chose to show.

Results table Results table

The limit is the most rows a search will return, up to 100. When there are more results than the limit, the page says so above the table, and the fix is to add filters to narrow the search.

Choosing the Fields to Show

Click show to choose which columns appear in the results.

Choosing the fields to show Choosing the fields to show

Type in the box to find a field, tick the ones you want, and click default fields to go back to the usual eight. At least one field is always shown.

Fetch all fields

With fetch all fields off, each search fetches only the fields you are showing, which is faster. If you then tick another field, the page asks you to search again before it can show that column.

With it on, every field is fetched, so ticking or unticking a field updates the table straight away without another search. The trade-off is that each search takes a little longer.

Presets

A preset saves the filters, the shown fields, the limit and the fetch all fields setting together, so you can come back to a query later.

A saved preset A saved preset

Type a name and press save. Choose a preset from the list to load it, and delete to remove the one you are looking at.

Presets are kept in your own browser only, not on the server. They do not follow you to another browser or computer, and clearing your browser's site data removes them.

Export

The results can be saved to your computer with export TSV for a spreadsheet, or export JSON for a script.

Export buttons Export buttons

Both buttons save the columns you are showing, in the order they appear, and stay disabled until a search has returned some results.

Issues

If you have any problems or suggestions for improvement, please add it to the DPD issues on GitHub.