Lincovery: sql

0 important 0 comment

sorting collections

added by: Arnošt Štědrý (Dec 1, 2009) groups: Programování, Technologie

In fact, Oracle is now rich in features for working with collections, with one important special case: sorting arrays of data. This article demonstrates a small number of techniques that we can adopt for sorting our collections.

link: http://www.oracle-developer.net/display.php?id=428

tags: sql oracle pl/sql adrian's oracle pages oracle-developer.net oracle developer

bookmark detail

0 important 0 comment

MySQL: GROUP BY Modifiers

added by: Arnošt Štědrý (Nov 30, 2009) groups: Programování, Technologie

These rows represent higher-level (or super-aggregate) summary operations. ROLLUP thus allows you to answer questions at multiple levels of analysis with a single query.

link: http://dev.mysql.com/doc/refman/5.0/en/group-by-modifiers.html

tags: sql webdesign mysql group by

bookmark detail

0 important 1 comment

PostgreSQL v roce 2009 (PostgreSQL 8.4) - Root.cz

added by: Arnošt Štědrý (Jun 25, 2009) groups: Programování, Technologie

Každoročně přinášíme článek věnovaný novinkám v PostgreSQL verze 8.4, která je k dispozici.

link: http://www.root.cz/clanky/postgresql-v-roce-2009-postgresql-8-4/

tags: open source sql programming database postgresql

bookmark detail

0 important 0 comment

Hibernate SQL logging

added by: Arnošt Štědrý (Apr 6, 2009) groups: Programování, Technologie

log4j.logger.org.hibernate.SQL=DEBUG log4j.logger.org.hibernate.type=TRACE

link: http://blog.krecan.net/2009/04/05/hibernate-sql-logging/

tags: java hibernate framework sql programming logging

bookmark detail

0 important 0 comment

Morgan's Library Home

added by: Arnošt Štědrý (Mar 18, 2009) groups: Programování, Technologie

Opravdu velka knihovna prikladu toho, co se da v Oracle delat a novinek ze sveta Oracle

link: http://www.morganslibrary.org/

tags: sql tutorial software oracle database

bookmark detail

0 important 0 comment

How FriendFeed uses MySQL to store schema-less data - Bret Taylor's blog

added by: Arnošt Štědrý (Mar 2, 2009) groups: Programování, Cizí projekty, Technologie

Krajne poucne az nesmirne zajimave

link: http://bret.appspot.com/entry/how-friendfeed-uses-mysql

tags: web 2.0 sql web application json

bookmark detail

0 important 0 comment

wwwsqldesigner - Google Code

added by: Lukáš Gavenda (Jan 29, 2009) groups: Programování, Cizí projekty, Technologie

WWW SQL Designer allows users to create database designs, which can be saved/loaded and exported to SQL scripts. Various databases and languages are supported. Ability to import existing database design.

link: http://code.google.com/p/wwwsqldesigner/

tags: sql designer web-based

bookmark detail

0 important 0 comment

SQL indexing in 9 minutes and a half

added by: Arnošt Štědrý (Jan 24, 2009) groups: Programování, Technologie

Proper indexing is one of the keys to database performance - yet a disturbingly high number of people have it more or less wrong. This presentation is based ...

link: http://cz.youtube.com/watch?v=7ZgG7ttJTSc

tags: index sql database performance indexing roughsea faroult

bookmark detail

0 important 0 comment