How does it work?

MagNumDB is a database that contains about 300,000 items. These items are constants, names, values all extracted from more than 4,000 header files (.h, .hxx, .hpp, .idl, etc.) provided by standard Windows and Visual Studio SDKs.
Some values have been extracted from the very special uuid.lib file that contains the value of thousands of guids and property keys, not present anywhere else in header files.

 "C2P5"

To build this database, we have written a powerful C/C++ parser named C2P5 (for C/CPP/PreProcessor/Parser), tailored specifically for this task. C2P5 is capable of preprocessing, parsing and partially evaluating all header files as if they were included in a one big virtual project (that of course, does not compile). It currently supports the following preprocessor and C/C++ constructs:

  • #define preprocessor that define constants
  • #define preprocessor that define expression to compute constants
  • C and C++ enum definitions
  • Special GUID constructs like DECLSPEC_UUID, DEFINE_GUIDSTRUCT or MIDL_INTERFACE
  • Some IDL constructs
  • Etc.

The parser remembers dynamic preprocessor definitions (#if, #ifdef, etc.) that are conditions for constants definitions and expression computation. All parsed items are saved in the database, as well as the associated conditions. There may be more than one item corresponding to a given name, if there are differences in their associated conditions.

C2P5 supports the following types of constants, regardless of the way they are defined in source files:

  • integer, signed or unsigned, from 8-bit to 128-bit
  • floating point number, single (32-bit) or double (64-bit)
  • globally unique identifier, or guid, uuid, CLSID, IID, etc.
  • string, in narrow, wide, or utf-8/16/32 formats
  • character, in narrow, wide, or utf-8/16/32 formats
  • pointer, a constant cast as a pointer
  • property key, or PKEY, a combination of a guid (fmtid) and a 32-bit integer (id).

 Powered by

C2P5 and this MagNumDB web site are written in C# and use a Lucene database as a full-text search engine. C2P5 uses a custom ANTLR4cs C grammar for expression parsing, not for preprocessor parsing.

 

 Frequently Asked Questions

  • Q: Can I run custom queries? A: Yes. You can use Lucene's query syntax. Note the Database is case insensitive. Check out the list of columns with their corresponding database column names:

    • Index: the item's index.
    • Name: the item's name, or title. For enum values, it's prefixed with the enum's name.
      Corresponding database field: title.
    • Type: the item's type, expressed in a specific, universal system.
      Corresponding Lucene's field: valuetype, but use the value of the Storage type column for queries on items type.
    • Value: the item's value. For string values, it's displayed as is w/o quotes nor escaping.
      Corresponding database field: value. There is also a typedvalue field that can contain Lucene's Int32, Int64, Float, Double or String typed values.
    • Hex Value: the item's hexadecimal value, only valid for integer types.
      There is no corresponding database field.
    • Signed Value: the item's signed value, only valid for integer and double types. Useful when you found a unsigned number and want to get the corresponding signed value (uint -> int for example).
      There is no corresponding database field.
    • Source lines(s): the source lines from which the item was extracted. Comments and characters such as TAB, CR are preserved.
      Corresponding database field: source.
    • File path: the file path from which the item was extracted, terminated by the line index.
      Corresponding database field: filepath. There are also directory and filename fields. filename is useful to query for values in a given file.
    • Score: Lucene's score value. Items are returned sorted by score.
    • Guid formats: a utility columns that proposes all possible guid formats. Only valid for guid types.
      There is no corresponding database field
    • Char type: the character encoding (narrow, wide, etc.). Only valid for char and string values.
      Corresponding database field: chartype.
    • Storage type: the exact storage type in the database. Only used for specific queries.
      Corresponding database field: valuetype.
    • Conditions: the list of preprocessor conditions for a given item. If a condition is surrounded with a REVERSE function, it means the reverse condition of what's surrounded was the condition.
      Corresponding database field: conditions. There may be multiple conditions fields for one item.

    Some important points to note:

    • If you search for a negative number (like error codes expressed using signed integers), you can surround the search with double quotes, for example searching for "-2147009290" is equivalent to searching for 0x80073CF6, 80073CF6 (or even 3CF6 in this specific case). If you don't surround negative numbers with double quotes, the system will search for signed and unsigned corresponding values.
    • The full-text search uses items' name, value, hex value, guid formats, source lines, etc. so refine your search if you get back too many items.
    • You can search for guid binary values using just a part of their full definition. For example, if you search for '79eac9c5', it will get you 3 guid entries
    • Leading wild card search (*whatever) is allowed, but it may slow down the search significantly.

    Here are some example or custom queries:

    title:wm_user returns the WM_USER Windows message item, not all items that reference the WM_USER token.

    title:wm_u* returns all items (Windows messages probably) whose name starts with WM_U*.

    value:1024 AND title:wm_* returns all items (Windows messages probably) whose name starts with WM_U* and value is 1024. Note AND must be UPPERCASE for Lucene's to understand it as an AND operator.

    value:"00000002-0000-0000-C000-000000000046" returns the IMalloc IID guid value.

  • Q: I always get back 400 items at most. Why? A: The MagNumDb site currently limits the number of returned items to this value by design. This should be enough for most real search scenarios (like enums with a big list of values).
  • Q: Some values are empty. Why? A: The expression evaluator cannot sometimes compute the final value, because it sometimes require contextual information (custom defines, compiler architecture, etc.) that the parser doesn't have. You can enable the Source line(s) column to check what's the corresponding source and try to work it out by yourself. The origin file path and line number is also included.
  • Q: Can I get all values for a given enum? A: Sure. For example, __VSHPROPID is the name of an enum, and a query like this: parent:__VSHPROPID will get all the enum's values (66 entries).
  • Q: I sometimes get back items whose name starts with "__magnumdb__enum_". Why? A: C allows unnamed enums. The MagNumDb parser just gives them a name, using the defining file name and a counter.

 Database Metrics

  • Last update date: Tuesday, 17 October 2017
  • Items count: 304412
  • Parsed files count: 4278
  • Windows SDK version: 10.0.16299.0

 

 Contact

We welcome feedback.
Seen anything missing? A bug? A wrong value? Do you have any suggestion for improvements? Do you have an idea for a cool new feature?

Please contact us here

 About MagNumDB

MagNumDB  2017 Simon Mourier V1.0.3. All rights reserved.

Profile for Simon Mourier at Stack Overflow, Q&A for professional and enthusiast programmers


All product names, logos, and brands are property of their respective owners. All company, product and service names used in this website are for identification purposes only.

All values, names, source code fragments displayed here have been extracted from files that are property of their respective owners.

THIS SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND OTHER THAN AS SPECIFICALLY SET FORTH IN THE LICENSE AGREEMENT, INCLUDING WITHOUT LIMITATION WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NON-INFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

Index Score Name Type Value Hex value Signed value Guid formats Char type Storage type Source line(s) File path Conditions
Index Score Name Type Value Hex value Signed value Guid formats Char type Storage type Source line(s) File path Conditions
1 4.744583 HKEY_LOCAL_MACHINE Pointer System.Int32 (HKEY) -2147483646 0x80000002 System.Pointer
#define HKEY_LOCAL_MACHINE                  (( HKEY ) (ULONG_PTR)((LONG)0x80000002) )
%ProgramFiles(x86)%\Windows Kits\10\Include\10.0.16299.0\um\winreg.h(117,0)
  • If WINAPI_FAMILY_PARTITION(WINAPI_PARTITION_APP | WINAPI_PARTITION_DESKTOP | WINAPI_PARTITION_SYSTEM)
2 4.025912 IE_USE_OE_PRESENT_HKEY Pointer System.Int32 (HKEY) -2147483646 0x80000002 System.Pointer
#define IE_USE_OE_PRESENT_HKEY HKEY_LOCAL_MACHINE
%ProgramFiles(x86)%\Windows Kits\10\Include\10.0.16299.0\um\InetReg.h(447,0)
  • If WINAPI_FAMILY_PARTITION(WINAPI_PARTITION_DESKTOP)
  • Ifdef UNIX
3 3.795666 SPREG_LOCAL_MACHINE_ROOT String HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Speech Wide System.TypedString
#define SPREG_LOCAL_MACHINE_ROOT L"HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Speech"
%ProgramFiles(x86)%\Windows Kits\10\Include\10.0.16299.0\um\sapi53.h(1254,0)
  • If WINAPI_FAMILY_PARTITION(WINAPI_PARTITION_DESKTOP)
  • If _SAPI_VER >= 0x054
4 3.795666 SPCAT_AUDIOOUT String HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Speech\AudioOutput Wide System.TypedString
#define SPCAT_AUDIOOUT         L"HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Speech\\AudioOutput"
%ProgramFiles(x86)%\Windows Kits\10\Include\10.0.16299.0\um\sapi53.h(1255,0)
  • If WINAPI_FAMILY_PARTITION(WINAPI_PARTITION_DESKTOP)
  • If _SAPI_VER >= 0x054
5 3.795666 SPCAT_AUDIOIN String HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Speech\AudioInput Wide System.TypedString
#define SPCAT_AUDIOIN          L"HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Speech\\AudioInput"
%ProgramFiles(x86)%\Windows Kits\10\Include\10.0.16299.0\um\sapi53.h(1256,0)
  • If WINAPI_FAMILY_PARTITION(WINAPI_PARTITION_DESKTOP)
  • If _SAPI_VER >= 0x054
6 3.795666 SPCAT_VOICES String HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Speech\Voices Wide System.TypedString
#define SPCAT_VOICES           L"HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Speech\\Voices"
%ProgramFiles(x86)%\Windows Kits\10\Include\10.0.16299.0\um\sapi53.h(1257,0)
  • If WINAPI_FAMILY_PARTITION(WINAPI_PARTITION_DESKTOP)
  • If _SAPI_VER >= 0x054
7 3.795666 SPCAT_RECOGNIZERS String HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Speech\Recognizers Wide System.TypedString
#define SPCAT_RECOGNIZERS      L"HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Speech\\Recognizers"
%ProgramFiles(x86)%\Windows Kits\10\Include\10.0.16299.0\um\sapi53.h(1258,0)
  • If WINAPI_FAMILY_PARTITION(WINAPI_PARTITION_DESKTOP)
  • If _SAPI_VER >= 0x054
8 3.795666 SPCAT_APPLEXICONS String HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Speech\AppLexicons Wide System.TypedString
#define SPCAT_APPLEXICONS      L"HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Speech\\AppLexicons"
%ProgramFiles(x86)%\Windows Kits\10\Include\10.0.16299.0\um\sapi53.h(1259,0)
  • If WINAPI_FAMILY_PARTITION(WINAPI_PARTITION_DESKTOP)
  • If _SAPI_VER >= 0x054
9 3.795666 SPCAT_PHONECONVERTERS String HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Speech\PhoneConverters Wide System.TypedString
#define SPCAT_PHONECONVERTERS  L"HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Speech\\PhoneConverters"
%ProgramFiles(x86)%\Windows Kits\10\Include\10.0.16299.0\um\sapi53.h(1260,0)
  • If WINAPI_FAMILY_PARTITION(WINAPI_PARTITION_DESKTOP)
  • If _SAPI_VER >= 0x054
10 3.795666 SPCAT_TEXTNORMALIZERS String HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Speech\TextNormalizers Wide System.TypedString
#define SPCAT_TEXTNORMALIZERS  L"HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Speech\\TextNormalizers"
%ProgramFiles(x86)%\Windows Kits\10\Include\10.0.16299.0\um\sapi53.h(1261,0)
  • If WINAPI_FAMILY_PARTITION(WINAPI_PARTITION_DESKTOP)
  • If _SAPI_VER >= 0x054
11 3.795666 SPREG_SAFE_USER_TOKENS String HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Speech\UserTokens Wide System.TypedString
#define SPREG_SAFE_USER_TOKENS       L"HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Speech\\UserTokens"
%ProgramFiles(x86)%\Windows Kits\10\Include\10.0.16299.0\um\sapi53.h(1290,0)
  • If WINAPI_FAMILY_PARTITION(WINAPI_PARTITION_DESKTOP)
  • If _SAPI_VER >= 0x054
12 3.795666 UREGUSBFNENUMPATH String HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\USBFN\ Wide System.TypedString
#define UREGUSBFNENUMPATH L"HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Control\\USBFN\\"
%ProgramFiles(x86)%\Windows Kits\10\Include\10.0.16299.0\shared\usbfnbase.h(30,0)
13 3.354926 __magnumdb__enum_msouser_h_7::msoprfMachine Int32 1 0x00000001 1 System.Int32
msoprfMachine = 0x0001,	// use HKEY_LOCAL_MACHINE
%ProgramFiles(x86)%\Microsoft Visual Studio 14.0\VSSDK\VisualStudioIntegration\Common\Inc\office10\msouser.h(723,0)
14 3.321208 SPMMSYS_AUDIO_IN_TOKEN_ID String HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Speech\AudioInput\TokenEnums\MMAudioIn\ Wide System.TypedString
#define SPMMSYS_AUDIO_IN_TOKEN_ID        L"HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Speech\\AudioInput\\TokenEnums\\MMAudioIn\\"
%ProgramFiles(x86)%\Windows Kits\10\Include\10.0.16299.0\um\sapi53.h(1263,0)
  • If WINAPI_FAMILY_PARTITION(WINAPI_PARTITION_DESKTOP)
  • If _SAPI_VER >= 0x054
15 3.321208 SPMMSYS_AUDIO_OUT_TOKEN_ID String HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Speech\AudioOutput\TokenEnums\MMAudioOut\ Wide System.TypedString
#define SPMMSYS_AUDIO_OUT_TOKEN_ID       L"HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Speech\\AudioOutput\\TokenEnums\\MMAudioOut\\"
%ProgramFiles(x86)%\Windows Kits\10\Include\10.0.16299.0\um\sapi53.h(1264,0)
  • If WINAPI_FAMILY_PARTITION(WINAPI_PARTITION_DESKTOP)
  • If _SAPI_VER >= 0x054
16 3.321208 UREGMANUSBFNENUMPATH String HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\ManufacturingMode\Current\USBFN\ Wide System.TypedString
#define UREGMANUSBFNENUMPATH L"HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Control\\ManufacturingMode\\Current\\USBFN\\"
%ProgramFiles(x86)%\Windows Kits\10\Include\10.0.16299.0\shared\usbfnbase.h(36,0)
17 2.683941 __magnumdb__enum_msouser_h_7 Enum
enum
{
	msoprfUser = 0x0000,	// use HKEY_CURRENT_USER
	msoprfMachine = 0x0001,	// use HKEY_LOCAL_MACHINE
	msoprfIgnoreReg = 0x8000,	// always return defaults
};
%ProgramFiles(x86)%\Microsoft Visual Studio 14.0\VSSDK\VisualStudioIntegration\Common\Inc\office10\msouser.h(720,0)