metadata

A python web application framework for tight DB/GUI coupling?

I'm a firm believer of the heretic thought of tight coupling between the backend and frontend: I want existing, implied knowledge about a backend to be automatically made use of when generating user interfaces. E.g., if a VARCHAR column has a maximum with of 20 characters, there GUIs should automatically constrain the user from typing mo...

How can I get the definition (body) of a trigger in SQL Server?

Unable to find a SQL diff tool that meets my needs, I am writing my own. Between the INFORMATION_SCHEMA and sys tables, I have a mostly-complete working version. But one thing I can't find in the metadata is the definition of a trigger, you know, the actual SQL code. Am I overlooking something? Thanks. ...

Is it possible to select from "show tables" in MySQL?

Well, yes, the title says it all. SELECT * FROM (SHOW TABLES) AS my_tables Something along these lines, though the above does not work (on 5.0.51a, at least). ...

Customizing Search Results Display in Sharepoint Services 3.0 Wiki

I'm looking at using a Windows SharePoint Services 3.0 wiki as a metadata repository. We basically want a community-driven dictionary and for various reasons we're using Sharepoint instead of say MediaWiki. What can I do to customize or completely replace searchresults.aspx? Features I'd add if I knew how: Automatically load the #1 ...

How do you determine what SQL Tables have an identity column programatically

I want to create a list of columns in SQL Server 2005 that have identity columns and their corresponding table in T-SQL. Any ideas? Results would be something like: TableName, ColumnName ...

Is it possible to save metadata in an image?

We create thumb images on our server and I'm looking for a way to save metadata (text) in that image. Is that possible? At this moment we use PHP and we create JPG images. ...

Any Metadata driven UI sample code?

Hi, I am in the process of designing a .net windows forms application that uses metadata to drive the UI. Apart from finding http://msdn.microsoft.com/en-us/library/ms954610.aspx, I have nothing much to look forward to. Anyone here worked on metadata driven User interfaces? What are the implications of following this methodology and any...

Accessing Greasemonkey metadata from within your script?

Is there any way that my script can retrieve metadata values that are declared in its own header? I don't see anything promising in the API, except perhaps GM_getValue(). That would of course involve a special name syntax. I have tried, for example: GM_getValue("@name"). The motivation here is to avoid redundant specification. If GM me...

What Oracle privileges do I need to use DBMS_METADATA.GET_DDL?

(Excuse any ignorance of mine here - I'm not a seasoned Oracle user.) I'm attempting to use the DBMS_METADATA.GET_DDL function (in conjunction with ALL_OBJECTS or some such) to get the DDL for all of the tables in a particular schema. When I do this (either for all objects or for a single specific object) I get an ORA-31603 error ("obje...

Are Meta Keywords Obsolete?

Creating a website for a BraodBand Company, and not too sure whether or not to go ahead and fill in the meta keywords? Are they still necessary? ...

How do I determine if a column is an identity column in MSSQL 2000?

I want to do this in code, not with ALT+F1. ...

Getting image metadata in .NET without regards to metadata format

Given a filename, I need to be able to access certain metadata in an image for a (closed source) project I'm currently developing, without regard to how the metadata is stored (that is, Exif, IPTC, or XMP). In particular, I want to access geotagging data. Is there a way of doing this without requiring any third party assemblies or libra...

What SQL query or view will show "dynamic columns"

I have a table of data, and I allow people to add meta data to that table. I give them an interface that allows them to treat it as though they're adding extra columns to the table their data is stored in, but I'm actually storing the data in another table. Data Table DataID Data Meta Table DataID MetaName MetaData So...

Where are seed_value and increment_value for IDENTITY columns?

I'm collecting metadata using the sys.* views, and according to the documentation, the sys.identity_columns view will return the seed and increment values like so. CREATE TABLE ident_test ( test_id int IDENTITY(1000,10), other int ) SELECT name, seed_value, increment_value FROM sys.identity_columns WHERE object_id = OBJECT_ID( '...

How do you configure WCF to support FaultContracts where both the host and client are in the same process using a net.pipe?

I'm trying to create an in-process unit test for my service to client interactions using net.pipe binding. Like a good WCF service it uses FaultContractAttribute on service operations to expose possible faults (wrapped exceptions) to metadata. I would like to have the client and service endpoints configured thru XML (App.config). Howe...

How do I check if a column exists in SQL Server?

How do I check if a column exists in SQL Server 2000? ...

Write dpi metadata to a jpeg image in Java

I am trying to programatically set the dpi metadata of an jpeg image in Java. The source of the image is a scanner, so I get the horizontal/vertical resolution from TWAIN, along with the image raw data. I'd like to save this info for better print results. Here's the code I have so far. It saves the raw image (byteArray) to a JPEG file, ...

What data mapping tool is good for mid size projects

I need a data(and metadata) mapping tool for mapping one database metadata to other. Are there any cheap tools available for that purpose? ...

What metadata repository tools are used in industry?

For logical data model mapping, do we have some tools in the market. Any open source or relatively cheap tool? ...

Does .NET (Mono) support cross-platform file operations and cross-platform audio metadata handling (through libraries)?

For my next project, the two leading frontrunners are .NET and Java. The project is to take a directory (something like My Music in Windows) that contains directories and music files (MP3s initially, but eventually expanded to other music formats). For each file, it would allow you to play the file and view/edit its metadata, filename, a...