Reputation
8,155
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
3 18 43
Newest
 Informed
Impact
~372k people reached

2d
reviewed Leave Closed Count the same value from 2 tables
2d
reviewed Close Unable to point out Exact cause behind anonymous block failure(Postgresql)
2d
comment When to include and exclude products from a webshop database?
I am afraid this will be closed as 'Primarily opinion-based'. Otherwise, in smaller systems (measured by the number of customers/orders/SKUs), I would possibly keep all the data in one place. If you plan to grow big, having the logical groups of tables separated might give a bit more room to play with when scaling out. But my main concern would be this: if the data returned to the application has to be aggregated often, then the DB might be a better place for doing it. This also means that keeping the tables in the same DB is better.
2d
reviewed Reviewed Which of these database designs is normalized?
2d
comment Which of these database designs is normalized?
Is a fiscal year really bound to a company? (I am no financial expert, just asking.) If yes, what will prevent you from coupling a fiscal year of company X with a branch of company Y?
2d
reviewed No Action Needed Run MySQL replication by schedule or on demand
2d
reviewed Reviewed Select Multiple Values from Same Column; one sql statment and split into separate columns
2d
comment Select Multiple Values from Same Column; one sql statment and split into separate columns
Do you want a pivot?
2d
reviewed Reviewed Database Engine Services status failed
2d
reviewed Close how to export mysql database in xammp
2d
reviewed Close SQL Server - Best practices on debugging extremely complex stored procedures
2d
reviewed Close Is it possible to import a CSV file into MySQL using VB.Net?
2d
reviewed Close Usage of COALESCE?
2d
comment Tuning a Postgres INSERT only database
How often will this thing being queried? Should the queries be really real-time, or is a (possibly very small) delay acceptable?
2d
comment Print to console as SQL executes
SELECT 'some text'; \echo of a psql command, you cannot use it in pgAdmin. If you want an error-like message (like a warning or such), you can create a pl/pgsql function that emits a message of the desired level using an incoming parameter, like the one I used here.
May
19
revised postgresql-xl wiki excerpt
added 85 characters in body
May
19
revised postgresql-xl wiki description
added 383 characters in body
May
19
wiki created postgresql-xl description
May
19
wiki created postgresql-xl excerpt
May
19
suggested approved edit on postgresql-xl tag wiki