5,347 reputation
925
bio website
location United States
age
visits member for 3 years, 7 months
seen Oct 21 at 13:31

Database design and software development consultant. My clients included everything from Fortune 100 companies to non-profits and mom-and-pop companies. I've worked with SQL databases since 1985. I'm a database generalist; I'm comfortable with every modern SQL dbms. My home server runs a half-dozen different database management systems. I test most of my answers under more than one of them.

I've developed relational models for implementation in non-SQL environments, like Lotus Notes and plain C++ code.

I also develop software in C, VBA, Python, Ruby, and php. I build web applications using various frameworks and languages, including Ruby on Rails, Laravel, and Phalcon.


Aug
13
comment How to create Combination of records (Order does not matter, no repetition allowed) in mySQL tables
500 recipes taken 3 at a time is about 20 million combinations. 500 recipes taken 4 at a time is about 2.5 billion. 500 taken 5 at a time is about 255 billion. 500 taken 6 at a time is about 2.1E13. You don't need to do this more efficiently; you need to do something completely different.
Jul
31
answered What is a standard or conventional name for a column representing display order?
Jul
23
comment pgsql slow query on table of 500 million rows
Is the only information you want from the database the total number of rows?
Jul
23
answered Plan for storing transactions in an easily retrievable manner, indefinitely
Jul
22
revised Constraint on Composite Type
Documented to work in 8.0+
Jul
22
answered Constraint on Composite Type
Jul
21
revised How do I know what indexes to create for a table
added 91 characters in body
Jul
14
answered optimizing MySQL for traffic analytics system
Jul
12
comment Dump PostgreSQL without DROP DATABASE
I think DROP DATABASE is included only when you use both -c and -C options on pg_restore. As far as I can tell, pg_dump never includes DROP DATABASE.
Jul
11
comment Is it possible to keep track of changes to tables structure?
In a disciplined development environment, you'd use your version control system--subversion, mercurial, git, even RCS in a pinch.
Jul
10
answered How to estimate/predict data size and index size of a table in MySQL
Jul
9
comment Indexes and Optimizations for Logging System
@ypercube: Right, corrected my answer. Thanks.
Jul
9
revised Indexes and Optimizations for Logging System
MySQL writes to the sort buffer.
Jul
9
comment Storing complex userdata
A to-do application doesn't require a user-defined database. It just requires user-supplied data.
Jul
9
answered Indexes and Optimizations for Logging System
Jul
8
comment Indexes and Optimizations for Logging System
Will you need to sort?
Jul
8
comment Storing complex userdata
I won't speak for other professional developers, but I try to avoid that kind of use case. Letting end users essentially design their own databases has always caused immense pain and suffering.
Jul
8
awarded  postgresql
Jul
2
comment what is the best practice when making changes to the the application and database?
@user24250: Updated answer.
Jul
2
revised what is the best practice when making changes to the the application and database?
TSQL is software development.