ypercube

London, United Kingdom

in.another.dimension

Age: 45

Interests: math, programming and games, not necessarily in that order.

Not sure if my next web app will make me a millionaire or a billionaire. In the mean time, I'm looking for a new job. Send proposals to my personal email: ypercube@gmail.com

top accounts reputation activity favorites subscriptions

Are there DBMS that allow a Foreign Key that References a View (and not only base tables)?

database-design referential-integrity asked May 14 '12 at 23:02

dba.stackexchange.com

10 votes

Why chat profile in some rooms does not have a parent SE profile?

bug status-completed chat network-profile asked Jun 4 '12 at 7:56

meta.stackoverflow.com

9 votes

C weird array syntax in multi-dimensional arrays

c arrays multidimensional-array pointer-arithmetic asked Nov 13 '11 at 2:49

stackoverflow.com

7 votes

Can spatial index help a “range - order by - limit” query

database-design postgresql index query-performance spatial asked May 22 '12 at 21:19

dba.stackexchange.com

7 votes

Optimization problem: compound clustered keys, flag conditions and index-merge

mysql optimization asked Aug 3 '12 at 11:02

dba.stackexchange.com

6 votes

Performance of query with a range condition and order by

database-design index query-performance sqlite asked May 22 '12 at 19:36

dba.stackexchange.com

6 votes

Do I deserve downvotes for answering such a simple question?

discussion down-votes vote-to-close asked Feb 25 '12 at 10:42

meta.stackoverflow.com

Top Answers

What are the mathematical/computational principles behind this game?

stackoverflow.com

Do people really want to look at multiple windows at once?

ux.stackexchange.com

MySQL COUNT DISTINCT

stackoverflow.com

What database technologies do big search engines use?

dba.stackexchange.com

Why do wildcards in GROUP BY statements not work?

dba.stackexchange.com

MySQL IF NOT NULL, then display 1, else display 0

stackoverflow.com

Does the join order matters in SQL?

stackoverflow.com

Using IS NULL or IS NOT NULL on join conditions - Theory question

stackoverflow.com

Optimization of C code

stackoverflow.com

What are important languages to learn to understand different approaches and concepts?

stackoverflow.com

Using 'case expression column' in where clause

stackoverflow.com

Are expletives allowed in SE chat?

meta.stackoverflow.com

Convert hex to binary in MySQL

stackoverflow.com

Python variable assignment question

stackoverflow.com

Are nested queries standard in the SQL language?

stackoverflow.com

Mysql CHECK Constraint

stackoverflow.com

selecting where two columns are in a set

dba.stackexchange.com

Graph auto-layout algorithm

stackoverflow.com

How can we update in more than 1 table?

stackoverflow.com

Why does MySQL add a feature that conflicts with SQL standards?

stackoverflow.com

How to do sum of sum in mysql query

stackoverflow.com

~x + ~y == ~(x + y) is always false?

stackoverflow.com

Error in SQL syntax

dba.stackexchange.com

Make sure two columns are sorted in the same order

dba.stackexchange.com

Get two weeks of data but group by a period of 7 days

dba.stackexchange.com

MySQL sort by some list

stackoverflow.com

MySQL: get MAX or GREATEST of several columns, but with NULL fields

stackoverflow.com

In SQL, is it OK for two tables to refer to each other?

stackoverflow.com

Help with this query

dba.stackexchange.com

If MAX(id) != COUNT(id), does that mean rows have been deleted?

dba.stackexchange.com