The Heap™ – Consultancy ©®

« first day (35 days earlier) ← previous day next day → last day (5129 days later) »

drachenstern

02:52

@BrianBallsunStanton do what depend on each other how?

Q: Schema to support dynamic object properties

Hi people. I'm working on an editor that enables its users to create "object" definitions in real-time. A definition can contain zero or more properties. A property has a name, a type and possibly a default value that corresponds to the type. Once a definition is created, a user can create an in...

schema

VtC: Off Topic Doesn't Belong

Brian Ballsun-Stanton

03:19

@drachenstern These

drachenstern

@BrianBallsunStanton ah, so I'm working with a technical team from the initial vendor to resolve that. It's reported from the hardware, so it's hard to know. I know I can sort on the DiscoveredAt to find most recent time, but otherwise I assume (and you know what they say about assume) that the time equivalent means they happened in the same minute (or thereabouts)

ever have the lights in your house go off and come right back on? Or dim really low but not quite go off?

that sort of event

Brian Ballsun-Stanton

03:40

wait, are you working at triggering them at the same time?

I don't understand the real-time requirements for resolve.

I'd say that you were working at the wrong granularity if this is a real problem.

drachenstern

It's a real problem, but not realtime

I can take as long as I need to process the items in the list

Brian Ballsun-Stanton

Hrmm

drachenstern

Which part of the question is becoming less clear, I tried to use the spreadsheet and the question to demonstrate the problem

I only added spacing to the spreadsheet to make it easier to follow

Brian Ballsun-Stanton

oooooh

ooooh

that's fun

no SQL is not the right way to do it, because order of rows matter

It's absolutely trivial to do in a procedural language

drachenstern

I know, that's what I'm thinking

Brian Ballsun-Stanton

03:44

I mean... roughly speaking in SQL, it would be to ETL the off events and on events to 2 separate tables, then start outer joining them

drachenstern

but I didn't know if there was a trick to get SQL to coerce the values quickly, cos they are sets

Brian Ballsun-Stanton

Becuase it's "really hard" to say "last 3 rows"

well, really hard or really easy

drachenstern

lol, yeah, I know

Brian Ballsun-Stanton

in oracle, I'd make a stored procedure.

drachenstern

at least with a procedural I can compare and backtrack

oh, it'll be a stored procedure no matter what, and all the TSQL goodies anyone wants to use

Brian Ballsun-Stanton

03:46

yeah, I don't know SQL-Server

But unless there's a compelling reason why it has to be on the DBMS, make it in the app

since you're doing stored procedures and that kind of nonsense anyways

iteration 1: clean up dupes to fit business rules.

Iteration 2: prune to table.

trivial to do in procedural

drachenstern

yeah, that's my thought process too

it's the way I started this morning, right up until my machine BSoD'd for the fourth time in 7 days

so I replaced it with another box and spent half a day or more getting it setup

Brian Ballsun-Stanton

eeew

drachenstern

yeah, tell me about it

So anyways, I know the logic, I know the access routines, I know the tables, I think I'll be ok

Brian Ballsun-Stanton

04:01

yep

drachenstern

Brian Ballsun-Stanton

hehehehe

12 hours later…

drachenstern

15:41

VtC: Belongs on SO:

Q: using a self-referancing employee table, how can i detect if a peroson reports into another?

I have a typical self referencing employee table. the data is hierarchical and I use the following UDF to encapsulate a simple CTE to derive an output of a particular person's direct and indirect reports. that is to say I can pass in a single employee and get back a listing of them and everyone u...

sql-server-2005 cte

6 hours later…

eiefai

21:53

hi people, so... what do we have to do for SO to starts migrating db related question to dba.se?

drachenstern

22:16

It has to leave public beta I believe. The reason being that they don't want to migrate and then the site fold

So, to answer your question more directly: you need to get everyone you know that does databases to get on here and ask questions that are not SO/SF/SU questions

« first day (35 days earlier) ← previous day next day → last day (5129 days later) »

all rooms

Transcript for

Feb7

Feb '118

Feb9

General on- and off-site discussion for dba.stackexchange.com....

frogs mysql nosql oracle postgresql sqlite sql-server

join this room
about this room

00:00

06:00

12:00

18:00

all times are UTC