Reputation
2,849
Top tag
Next privilege 3,000 Rep.
Cast close & reopen votes
Badges
11 27
Newest
 Necromancer
Impact
~150k people reached

2d
answered What kind of database should I use?
Aug
26
comment Suggestion for enforcing unique constraint in a table where soft delete is implemented
You're better off having a position_history table and moving deleted items there
Aug
20
revised What's the quickest way to periodically export PostgreSQL data to a local file on Windows?
added 119 characters in body
Aug
20
revised What's the quickest way to periodically export PostgreSQL data to a local file on Windows?
added 119 characters in body
Aug
19
revised What's the quickest way to periodically export PostgreSQL data to a local file on Windows?
added 128 characters in body
Aug
19
answered What's the quickest way to periodically export PostgreSQL data to a local file on Windows?
Aug
18
answered postGIS schema qualifier - best practice
Aug
12
comment Schema for ACL/User/Group/Role management
Have you considered using impersonation / proxy authentication?
Aug
11
comment Type of relational/object-oriented database with improved joins for object graphs?
A database that supports Recursive Common Table Expressions is a good start. Read Joe Celko's Trees and Hierarchies in SQL for Smarties, and Ch 27 of Joe Celko's SQL for Smarties (5th)
Aug
10
revised Feasible to have thousands of users in Postgres?
added 20 characters in body
Aug
10
comment Creating one stored procedure for all CRUD operations
Why? It's so much simpler to allow direct table or view access. Also, there's a programming principle: a function should do one thing
Aug
7
comment Cap on number of rows matching a condition in Postgres
you would do this using a trigger
Aug
6
revised Columns names are case sensitive on postgres
edited title
Jul
30
answered Database design - need someone to guide me
Jul
28
comment Multiple types of parts with multiple types of information (unspecified amount)
See you next year when you ask "how the heck do I analyze EAV data?"
Jul
25
awarded  Necromancer
Jul
24
revised Postgres DDL and DML best practices and coding standards
added 136 characters in body
Jul
21
answered DB design for employee working hours constraints
Jul
18
comment Plural vs Singular Table Name
what does "too close for clarity" mean?
Jul
17
awarded  Necromancer