Tags » Databases

Millions of historic images posted to Flickr

An American academic is creating a searchable database of 12 million historic copyright-free images. Kalev Leetaru has already uploaded 2.6 million pictures to Flickr, which are searchable thanks to tags that have been automatically added. 28 more words

Main Posts

SQL Server - Sum with Case

create table #temp
(
client nvarchar(10),
id int
);

insert into #temp (client, id ) values (‘aaa’,’1′)
insert into #temp (client , id ) values(‘aaa’,’2′) 42 more words

Databases

Racecourse Auction Success

Yesterday James and Sons of Fakenham had their August auction at Fakenham Racecourse, and the day went very smoothly. The database system that has been 16 months in the development process is now functioning very well for purpose – at no time was I more than about 10 lots behind the action, meaning that I was able to produce invoices without many delays. 84 more words

Striving to be less skull-numbingly boring, SAP files mobile device patent

SAP is an enterprise software giant that has long made products that do the boring blocking and tackling in corporate data management.

But wait! The company has now published a patent application it filed last year for a new mobile device — a piece of flashy hardware — referred to in the patent as a “ 248 more words

Business

Copy a Postgres database the easy way

You can copy a Postgres database with this simple command.

create database destination_db with template source_db

The source and destination databases need to be on the same server, and as far as I can tell, this command must be run while connected to the postgres database, not the source. 19 more words

Databases

A+ Education

A+ Education

Moving from the comfortable/everyday Google environment I am now venturing into some new territory.  Ready for some more rigorous (academic) searching I strap on my hiking boots and start to climb the mountain. 442 more words

Chris Tite presenting on "Evolutionary database design" at Agile User Group

For many decades now both developers and DBA’s have viewed the database as somewhat of a slow moving monolith which should be altered as little as possible and designed very clearly upfront. 194 more words

Databases