FrustratedWithFormsDesigner

less info
2,409 reputation
613
bio website
location
age
visits member for 2 years, 4 months
seen 1 min ago

7h
comment Wildcard subnet mask for IPv6
@NeilMcGuigan: I'm guessing that Colin probably thinks this is possibly off-topic because the IPv6 equivalent for 0.0.0.0/0 is going to be the same whether you're administering a database or writing a chat program, or something else.
11h
comment Best table name instead of “user”, if the DB doesn't like that
This could be a problem when working with developers who know nothing about Irish/French/German/Hunrarian/Croation. The Irish and French I could probably guess at, but the Croatian one I'd never guess what it was just by looking at the name.
11h
answered Best table name instead of “user”, if the DB doesn't like that
2d
reviewed Edit suggested edit on Divide single column value into multiple column depending upon the bit value of another column
2d
revised Divide single column value into multiple column depending upon the bit value of another column
improved formating, tags added
Jul
7
comment Oracle right outer join SELECT statement with a table
In the future, please also include what the exact problem is. Did you get an error code? Did the output look wrong? etc...
Jul
7
revised Oracle right outer join SELECT statement with a table
formatted query
Jul
7
revised How do I add versioning to this CMS I'm designing?
edited tags
Jul
4
revised Query with dynamic ranges in PostgreSQL based on status
edited tags
Jul
4
revised Personal and Global messaging database design
formatting
Jul
3
revised Is there a good way to select a row where the key represents the lower bound of a range?
formatting
Jul
2
revised Duplicate Relationships in Rails/MySQL Healthcare Application
edited tags
Jul
2
answered One table with a flag or two tables
Jun
30
comment How to avoid hardcoding a database link name in a package body
I think using execute immediate will work, if you're OK with using dynamic SQL.
Jun
27
comment Difference between Relational database and time series database?
Time-series databases could be implemented in an RDBMS: en.wikipedia.org/wiki/…
Jun
26
revised Optimal table design for a medical center rental service and recurrent shifts
added 88 characters in body
Jun
26
comment Optimal table design for a medical center rental service and recurrent shifts
@Enrique: I've updated with a bit about how to handle recurring bookings.
Jun
26
revised Optimal table design for a medical center rental service and recurrent shifts
added 2305 characters in body
Jun
25
comment Optimal table design for a medical center rental service and recurrent shifts
If you want to track the idea that appointments can recur, I'd do that in a separate table. I can post details on that later...
Jun
25
comment Optimal table design for a medical center rental service and recurrent shifts
@Enrique: Maybe instead of end_date you'd want a field to track duration of use? You still need a way to know if two bookings may potentially overlap, so you'd need end_date or duration (from start_date).