The Heap™ – Consultancy ©® - 2012-10-24 (page 1 of 2)

4:13 AM

@AaronBertrand "I think there is a MUCH more efficient way to write this query in about one line" Really? Is there ANY query that cannot be written in one line?

Jack Douglas

5:48 AM

@RichardTheKiwi ha ha :)

Jack Douglas

8:08 AM

@maple_shaft a couple of things for when you are around:

1) I forgot Microsoft has their own cloud service (not AWS), called "Windows Azure SQL Database"–I don't know much about it tbh but others here will probably be able to help you find out if it could suit you

2) I signed up for a trial for Oracle Cloud. You might like to know the base pricing I get to convert my trial to a live instance: S5 £125pm, S20 $900pm, S50 $2000pm

the 5,20 and 50 refer to the storage limit in each option, transfer limits are 30,120,300 accordingly

dezso

storage limit in what unit?

Jack Douglas

@dezso GB

@maple_shaft also from the FAQ:

How can I access the data in Oracle Database Cloud Service?

You can access data in your Oracle Database Cloud Service in multiple ways, including:

From an Oracle Application Express application running in an Oracle Database Cloud Service
From a Java application running in an Oracle Java Cloud Service or
Through RESTful Web Services

.
in other words, you can't just connect to the Cloud database the way you would a database on AWS (with a VPN or whatever): you application stack has to live in there too or you have to write an http API

.

Jack Douglas

9:01 AM

Rituraj: Welcome to Oracle Chat Support. How may I help you?
Jack Douglas: Hi, I've just signed up for a trial
Rituraj: Okay.
Jack Douglas: I understand the difference between the S5, S20 and S50 options
Jack Douglas: but I want to know if it is possible to add RAC nodes, and how
Jack Douglas: (presumably not on the trial, but I need to know if it is possible)
Jack Douglas: the purpose would be to scale-out during high demand months as our workload will be variable
Rituraj: Just for your reference, Oracle cloud has in-built feature to take care of the scale-out during high demand it…

forums.oracle.com/forums/…

dezso

9:40 AM

I miss a few verbs here: dba.stackexchange.com/a/27507/6219

@JackDouglas do you expect any answers in the near future?

Jack Douglas

9:57 AM

@dezso doesn't sound right to me

@dezso no idea :-)

interesting there are only 16 questions in this forum: the first on Oct 4

maple_shaft

11:32 AM

@JackDouglas Thanks for the additional information!

$2,000 per month for only 50GB of persistent storage and 300GB transfer in/out? That is not very much. I wouldn't feel comfortable going live with less than 250GB dedicated storage.

Also what about persistent backups? Do they consume this same storage limit?

In Amazon backups go to a mount on the S3 and an 800GB EBS mount is less than $200/month.

None of this is even considering the cost of leasing a Weblogic application server cluster which I am sure is many thousands of dollars extra.

Jack Douglas

@maple_shaft how are you going to get that cluster talking to the Oracle Cloud Database?

SQL*NET is out, so is JDBC etc etc

maple_shaft

@JackDouglas Ummm... how else is Java supposed to talk with a database without JDBC?

Jack Douglas

@maple_shaft you have to use the Java stack in the Oracle Cloud

or via an http API

that you write

@maple_shaft I'm looking into this–at the moment I'm not sure

maple_shaft

How is the HTTP API supposed to talk with the database without JDBC

Jack Douglas

it can internally

maple_shaft

11:44 AM

as in a Java stored procedure?

Jack Douglas

but communication between the cloud and any other layer you have is restricted

@maple_shaft yes

maple_shaft

fuck.that

Jack Douglas

or possibly their own Java server layer–I'm not quite sure on that one

maple_shaft

all of my servers, database and application should be on the same subnet

Jack Douglas

3 hours ago, by Jack Douglas

How can I access the data in Oracle Database Cloud Service?

You can access data in your Oracle Database Cloud Service in multiple ways, including:

From an Oracle Application Express application running in an Oracle Database Cloud Service
From a Java application running in an Oracle Java Cloud Service or
Through RESTful Web Services

maple_shaft

11:45 AM

SHOULD

Jack Douglas

"Oracle Java Cloud Service"

maple_shaft

open up port 1521 on the firewall

Jack Douglas

@maple_shaft no way

thats not going to happen

if you need that you need a different solution without a doubt

maple_shaft

Well then this... me.... Oracle... cloud.... is not going to happen

Jack Douglas

they should probably have told you all this

:)

maple_shaft

11:47 AM

@JackDouglas They were fucking sales guys. Even if they knew they didn't want to scare us away

Jack Douglas

well I guess you have some ammunition now...

what will you do instead?

maple_shaft

@JackDouglas no... that just can't be right... you have to be misunderstanding something they told you...

if what you say is true...

then they would literally expect us to rewrite our data access layer, abandon our ORM framework, and completely restructure our application built on over a decade of Java EE standards

Jack Douglas

@maple_shaft "Oracle Java Cloud Service" is Java EE

maple_shaft

So is JDBC

Jack Douglas

so you would have a migration job on your hands?

cloud.oracle.com/mycloud/f?p=service:java:0

maple_shaft

11:50 AM

@JackDouglas I would have to rewrite the data access layer of the application

Jack Douglas

@maple_shaft why?

if you are running your Java in their cloud, you can connect to the database normally I think

just not if you are using external application servers

they want you to let them run the whole farm :)

maple_shaft

@JackDouglas RIGHT! Thats what I was getting at!

Jack Douglas

but on the other side, the cost is included

you don't need to pay separately for your application servers

maple_shaft

I intended to use the Oracle CLoud application server cluster so that it would be able to communicate via JDBC to the database

really?

Jack Douglas

whoa, cost is not included

sorry

maple_shaft

11:53 AM

@JackDouglas oh okay... you got me excited there for a minute

Jack Douglas

$250, $499, $1499 tiers

maple_shaft

link? ^^

Jack Douglas

1,2,4 servers

@maple_shaft not public I'm afraid–you need to sign up for a trial to see

maple_shaft

ahh

Jack Douglas

well, maybe not sign up for a trial, perhaps you just need a login, I'm not sure

maple_shaft

11:54 AM

no thats okay... this information is beyond valuable for me now

Jack Douglas

the levels are called S1, S2, S4

maple_shaft

@BenBrocka Hey.... what are you doing out of the TL?

Jack Douglas

data transfer: 50,250,500

storage: 5,10,25

"RAM for Java Heap": 1.5,3,6

@maple_shaft you can serve applications direct without the Java layer using 'Apex' but that doesn't help you.

maple_shaft

@JackDouglas busily writing stuff down

Jack Douglas

Oracle Java Cloud Service is an enterprise-grade platform as a service for building and deploying Java EE, Oracle WebLogic Server, and Oracle Application Development Framework (Oracle ADF) applications. “It’s designed to be flexible and easy to use,” says Purdy. “And it is also a standards-based solution -it’s not proprietary and there is no cloud lock-in...”

maple_shaft

12:03 PM

@JackDouglas Earlier when you shared pricing for the database plans, you started out with figures in pounds then started using dollars?

is it dollars or pounds?

Jack Douglas

all in dollars–I might have used a £ by mistake

maple_shaft

ty

Jack Douglas

so your migration would be WebLogic to Weblogic?

doesn't sound so bad :)

maple_shaft

@JackDouglas No... it will be Tomcat to Weblogic...

but...

The application is currently only using third party and open source frameworks that allow it not to be locked into being run on an enterprise application container

It doesn't use any of the advanced enterprise level features of an application container, and can run solely in a web container

but weblogic will give us clustering support and sticky sessions, where with Tomcat I would have fairly boring load balancing

brb

Jack Douglas

sure
.
looks like the trial version is missing the 'administration' tab where you can configure backup–and I'm not having much luck finding it in the docs :)

.

from the Java cloud pricing page:

> End-User may upsize from a lower edition to a higher edition at any point of time (downsizing is not allowed)

which isn't ideal for your use-case

though I guess on the plus side you can at least stay on S1 until you get customers signing up

Ben Brocka

12:20 PM

@maple_shaft I'm in six regularly actually, I just don't talk in here all that much

maple_shaft

12:57 PM

@JackDouglas back... but have back to back meetings throughout the day...

Really, they won't let you scale back? Thats BS

But... it does make my decision a hell of a lot easier without the need for time consuming load testing

Aaron Bertrand

1:08 PM

@RichardTheKiwi not sure I understand your point

Jack Douglas

@maple_shaft what about the 50GB 'limit' for database size–is that a deal-breaker?

@AaronBertrand I think it was a joke?

obviously you can write any query on one line :)

Aaron Bertrand

@JackDouglas not a cursor, and I think the definition of "one line" gets a little hazy. Anyway without any other context I'm not sure what he intended by that comment here.

Jack Douglas

can you have a cursor in a query? I probably don't understand what a cursor is in SQL Server

in 'Orable, they are PL/SQL code

Aaron Bertrand

1:40 PM

@JackDouglas again, hazy definitions.

Some people call a stored procedure or a multi-statement TVF a "query" - also you can write a query that has 50 subqueries - still one query?

Jack Douglas

@AaronBertrand wow, didn't know that. To me, a 'query' is something that starts with select :)

Aaron Bertrand

@JackDouglas so you've never heard of an update query? :-)

Jack Douglas

@AaronBertrand no?

Aaron Bertrand

Anyway, I didn't understand his point, or why he brought it here.

Lamak

@AaronBertrand For me a 'query' changes definition depending on my convenience

Jack Douglas

1:44 PM

though the latest version of postgres allows you to perform an update inside a CTE

and Oracle 12c lets you define a procedure in a CTE

both of which are pure genius

Aaron Bertrand

This is perfectly valid in SQL Server, use it all the time: WITH cte AS (...) UPDATE cte ...

Define a procedure - meaning it would be a temporary, session-scoped procedure?

Not sure if that's "genius" or not

Jack Douglas

WITH deleted_posts AS (
DELETE FROM posts
WHERE created < now() - '6 months'::INTERVAL
RETURNING *
)
SELECT user_id, count(*) FROM deleted_posts group BY 1;

that is genius

or madness, depending on your angle

@AaronBertrand yes, I can think of a load of times I'd have liked that

bluefeet

morning all

Jack Douglas

hi :)

ConcernedOfTunbridgeWells

Hi

Jack Douglas

1:50 PM

@AaronBertrand well, statement scoped to be exact

swasheck

Seriously???? This is what passes as news?

Aaron Bertrand

@JackDouglas yes, that's what I meant, but more specifically, if two users run the same statement at the same time

I'm not quite sure I understand what makes that a "procedure" - isn't a delete statement just a statement? I can do that in SQL Server without creating a procedure - just use OUTPUT

ConcernedOfTunbridgeWells

@swasheck Depends on your audience I suppose ;-}

Jack Douglas

@AaronBertrand two different things

11 mins ago, by Jack Douglas

though the latest version of postgres allows you to perform an update inside a CTE

thats the statement I posted

ConcernedOfTunbridgeWells

Nobody ever went broke underestimating the lowest common denominator.

Jack Douglas

1:56 PM

11 mins ago, by Jack Douglas

and Oracle 12c lets you define a procedure in a CTE

thats the other thing

Aaron Bertrand

@JackDouglas ok, you wrote the statement for the first thing you talked about, not the last, nor the thing we kept talking about. Pardon my confusion.

Jack Douglas

@AaronBertrand not at all–communication isn't my strongest suite (suit?) :)

Aaron Bertrand

Anyway the statement you posted is equally possible in SQL Server. About the creating a temporary procedure, would be interested to hear a use case, but not today

(I's busy)

Jack Douglas

@AaronBertrand I bet you are :-)

swasheck

@ConcernedOfTunbridgeWells well, we think everyone over there is James Bond so we're even

ConcernedOfTunbridgeWells

2:01 PM

@swasheck I'm way too fat to be James Bond.

The redtops here put out a large volume of inane drivel as well.

I've even heard 'Mail reading' used as an adjective to describe someone (the Daily Mail is a rather lowbrow tabloid aimed at the curtain-twitcher demographic).

In the same vein I've heard the term 'Millwall supporting' used similarly. Milwall is a London football club known for its inbred fan base.

swasheck

@ConcernedOfTunbridgeWells so, the image that i posted was from CNN ... not exactly a "rag" but it's so hard to tell anymore.

ConcernedOfTunbridgeWells

@swasheck I think CNN is quite a bit more lowbrow than it used to be in its heyday.

Jack Douglas

@ConcernedOfTunbridgeWells "Globally it is the second most visited newspaper website"

swasheck

@ConcernedOfTunbridgeWells true. i have many friends who read/watch AJ for their international news. i tend to check out DW.

ConcernedOfTunbridgeWells

@JackDouglas Oh, dear.

swasheck

2:06 PM

i just like watching the Deutsche Microsoft-Bashing.

so much anger over a browser

Ben Brocka

@JackDouglas not surprised, they use lots of link-bait and I know plenty of people who look just to see what ridiculous thing they're reporting

ConcernedOfTunbridgeWells

@swasheck IE was a problem around 2000. Since FF and now Chrome it's less of an issue. They've had to back off their proprietary IE-isms and play nicely with standards more now.

@BenBrocka Rabble rousing for fun and profit. Unfortunately the gutter press have a disproportionate influence on public policy over here.

Ben Brocka

I don't see how, they don't even have page three girls!

@ConcernedOfTunbridgeWells Sort of. Lots of people are still on XP, which can't even get the minimum viable IE

swasheck

@BenBrocka new gravatar, eh?

ConcernedOfTunbridgeWells

@BenBrocka The management are blatantly partisan and use the paper to push their own political agendas. They will quitel happily use their audience to pick fights with MPs they don't like, and they have enough clout to push the MPs around to a surprisingly large extent.

So, they have a nice little business model of making issues out of the sort of stuff that can be used to wind up curtain twitchers and hammering it into public policy by a sort of strident partisan reporting style. Basically Yellow journalism for the 21st century.

Essentially, pandering to haters and stirring them up is quite a profitable business.

Ben Brocka

2:14 PM

@swasheck Back to the prinnies, dood

ConcernedOfTunbridgeWells

Much the same business model as Rupert Murdoch, although a slightly different demographic.

swasheck

@ConcernedOfTunbridgeWells is it me, or is humanity becoming increasingly angy?

Ben Brocka

I'm not angry! HOW DARE YOU IMPLY I'M ANGRY

swasheck

I blame the rappers and the video games.

Ben Brocka

Isn't there a new hotness now? That's so ninties

I blame the social medias and them thar i-devices

ConcernedOfTunbridgeWells

2:17 PM

@swasheck There's a nasty little feedback loop going down now where rabble rousing has turned into quite a good business model. As long as it's profitable it will probably continue until it it spawns something really catastrophic.

I'd argue the U.S. is just one charismatic wingnut away from becoming an out-and-out theocracy.

swasheck

@BenBrocka fine ... blame social media for the anger and sound-bite ment ... what were we talking about?

@ConcernedOfTunbridgeWells nah ... it is, and has been, a plutocracy for a while.

ConcernedOfTunbridgeWells

@swasheck It is for the moment but I don't think that state is stable. The plutocrats were quite happy for Santorum and Romney to blatantly pander to the far right. If the fuck up and let a genuine idealogue get into power it could really backfire.

Cade Roux

@ConcernedOfTunbridgeWells Our local newspaper web site enabled comments a few years ago and it's generally full of hate. But they need the page clicks. Especially now that they decided to only go to 3 days a week printing. Unfortunately they laid of a bunch of the writers. So quality has gone in the sh!tter.

ConcernedOfTunbridgeWells

Off to a meeting now. Back later.

swasheck

@CadeRoux i've never really understood the "clicks" metric as an indicator of relevance. unless it's just a bulk mentality ... if i generate clicks then some of those have to convert ad clicks? and then the advertisers aren't guaranteed that someone will buy their product. it's all vapor economics to me.

BAHAHAHAHAHAH ... user just requested access to the database. USERNAME: shart

Ben Brocka

2:26 PM

@CadeRoux local papers just aren't very practical anymore

Roy

Grm.. Just completed AS3AP benchmark of the Oracle Database Appliance. Out of the box performance is just below 3000 tps on 1 million rows. I think they must have bewitched it.

Ben Brocka

@swasheck Ad clicks are easy to track and there's a bunch of metrics to measure the "worth" of a page for advertisers. Relevance is more important than bulk eyes-on-page. Ad ROI...is the advertiser's problem

You do your site, advertisers, visitors and wallet a lot more good by making ads relevant and displaying them properly...which is why it makes me sad Youtube doesn't let me select which ads to show

swasheck

@BenBrocka while i understand why it works in terms of its extant state, i've just never really understood why the advertisers think it's a good idea :)

Ben Brocka

@swasheck honestly I think advertisers get a lot more out of online ads than they do print/etc ads. The concept of "mindshare" has pretty much gone away so they charge by clicks. If it was print they'd be paying far more per impression and have no way of tracking it at all to boot

Roy

@BenBrocka Aye, but it's no fun being a publisher getting paid 0.002 per click

swasheck

2:32 PM

@BenBrocka fair enough. this is why i never completed my MSIS ... i argued with the marketing prof for two semesters and never fulfilled the core requirements for the business part of the program

DTest

@Roy just get more traffic so it adds up faster :)

swasheck

@DTest only if the plebes click the ads

Ben Brocka

@Roy Yeah, that does suck. It bugs me that advertisers seem so entitled in online ads. They can much more easily track their ROI, they totally ignore the cost of mindshare and they bitch like it's less useful than print ads

People have been ignoring print ads for ages, banner blindness is nothing new

swasheck

this one page encapsulates so many things that we've already discussed this morning/afternoon

blogs.sitepointstatic.com/examples/tech/css3-starwars/…

Jack Douglas

@Roy what does 'Grm' mean? Are you pleased with it or annoyed?

DTest

2:34 PM

@swasheck ironically I linked that to coworkers earlier this morning...we must follow the same tweeters

swasheck

@DTest either your tweeters follow HN or HN follows your tweeters

Ben Brocka

@Roy I make out fairly well on Youtube for rather little effort...granted I'm not trying to live off of it. It did buy me a new PC though

maple_shaft

@JackDouglas Why do you ask? Is 50GB plenty? I am not entirely sure how much space a typical Oracle database with LOB space for documents and such would consume

Ben Brocka

Consume ALL of the disks!

maple_shaft

Or perhaps storing user uploaded images and documents in LOB space is a n00b mistake?

Roy

2:38 PM

@BenBrocka nodnod but imagine trying to support content generation with dozens of people on payroll, like a newsroom or something. To me it looks like it takes insane amounts of traffic to support even a small newspaper-like operatio.

Cade Roux

@BenBrocka On paper, no. The problem is that the news coverage is declining. We were about to become the largest metropolitan area in the US without a daily paper. Then the Advocate decided to move in from Baton Rouge, so now we have a daily paper again. We'll see how long it lasts.

maple_shaft

@BenBrocka The reason that advertisers snub online media vs. print media is because most advertising agencies are relics to an older age

trust me

Ben Brocka

@maple_shaft Wouldn't surprise me

maple_shaft

I used to work for a company that provided software services and products for cable television

Roy

@BenBrocka A bith of both. It's almost unbelievably good performance =)

hrm, that came down wrong

@JackDouglas A bith of both. It's almost unbelievably good performance =)

maple_shaft

2:42 PM

@BenBrocka They still look at traditional advertising models and the older models that still look at targeting specific demographics and how many impressions per demo

Cable television still holds Neilson ratings in the highest regards, even though statistically the sample size is no longer relevant in the wake of so much television content

and as far as I know, there is no equivalent to Neilson families for online advertisements... nor does there need to be

Jack Douglas

@Roy you must work for a pretty big company to be playing with one of those ;-)

maple_shaft

All content providers are perfectly capable of providing their own data on views and demos

The Advertising industry right now is turned up on its head with the decline of television and the death of print media

Jack Douglas

@maple_shaft not necessarily

Roy

@JackDouglas No, and thats what's so great. It's a tiny company and they let me play with 2 of these beauties without the hassle of working in an enterprise :D

Jack Douglas

@maple_shaft but you better check with Oracle what happens when you hit that limit?

it's one thing for the price to go up, quite another if it's sorry, no can do

@Roy I'm jealous

maple_shaft

2:48 PM

@JackDouglas Nobody will need more than 50GB single schema storage... and no computer will need more than 640kb of memory

Jack Douglas

but glad you are on the site :)

@maple_shaft does you app search inside those LOBs or just serve them up?

I mean does it do anything at all to them other than expose them as hyperlinks to download?

Roy

@JackDouglas Well, the guy who got my old job now has an Exadata. We can both be jaleous ;)

maple_shaft

@JackDouglas serve them straight up, no olives, no lemon twist.

Write bytes... read bytes later.... user profile pic

Jack Douglas

@maple_shaft just user profile pictures?

how many bytes per pic?

maple_shaft

@JackDouglas and team logos, and player avatars

Jack Douglas

2:51 PM

@maple_shaft still, we're not talking about general document storage here

maple_shaft

right now a 1MB limit and only GIF, JPG and PNG

no, no documents, PDFS and the like, well...

maybe a few, but these will be administrator things only

Jack Douglas

your other sensible option is hashing and serving the images on an external cdn

swasheck

@JackDouglas i'd choose Amazon Glacier

Jack Douglas

@swasheck don't joke about it :-)

@maple_shaft I've gone the hashing route myself and if you can keep it simple I think it is an acceptable compromise

maple_shaft

@JackDouglas good idea,maybe for a later date, we have to get out the door by January even if it means drowning my grandmother in a bathtub

Jack Douglas

2:54 PM

simple='no deletes'

swasheck

@maple_shaft do you work for the russian mafia?

maple_shaft

its do or FUCKING DIE deadline

swasheck

@maple_shaft what's the product?

maple_shaft

got money for fancy pants Oracle hosting but nothing to hire another developer... FML

Jack Douglas

@maple_shaft in which case I guess you can live with the 50GB limit but you probably should still ask them in theory what happens when you hit it–you won't want to be redesigning in a hurry when you get to 49Gb

maple_shaft

2:56 PM

@swasheck top secret... it is a corporate wellness program that mixes fantasy football with World of Warcraft

it is a fitness thing.... get your employees healthier by playing our online game... provide reports on improving employee health

swasheck

@maple_shaft see: the last comment by @JackDouglas

maple_shaft

hmmm

swasheck

sometimes in the mad rush of the present, the future is cast aside, only to come back to bite your biscuits when it becomes the present.

maple_shaft

@swasheck Startup mentality though... think like a dog that doesn't know if they are even going to have a next meal... do whatever it takes... fuck preparing for the future, I don't know if the lights are going to be on next year...

if the future requires more than 5 minutes of thought then it is too much

swasheck

@maple_shaft ... swim in the cash and tighten the bandaids until you can sell out and it becomes someone else's problem?

maple_shaft

3:00 PM

@JackDouglas in your professional opinion though, assuming I store images in LOB, and assuming a typical 60 table well normalized schema, roughly 10k users to start, how quickly might I burn through 50GB?

@swasheck Sell out? No. Make obscene amounts of money, hire people smarter than me to clean up the mess I created :)

Jack Douglas

@maple_shaft they all have a profile pic?

maple_shaft

@JackDouglas No... maybe half of them, and then there will be teams of about 4-6 people each team has a logo

Jack Douglas

what are avatars–unique to users?

maple_shaft

they can be

or stock... which obviously wouldnt be stored

swasheck

@maple_shaft en.gravatar.com ?

then you don't store it

maple_shaft

3:04 PM

^^^ Thought about it actually :)

Jack Douglas

sounds like ~1mb per user give or take

swasheck

sign in with facebook/google/twitter and rip their profile pic?

10k users = 10Gb

let them host it

@swasheck FUCK NO

3:05 PM

that's plenty of breathing room to start with

maple_shaft

NO NO NO NO NOOOOOOOOOOOOOOOOOOOOOO!!!!!!!!!

swasheck

BAHAHAHAHAHAHAHA

maple_shaft

made that mistake once

swasheck

@maple_shaft what happened?

maple_shaft

We have a problem... this screen doesn't come up... no you can't see our server logs, no you cannot remote connect to my pc, I will run a query and show you a few records in an email... how was I supposed to deploy this package again?

etc..

etc...

troubleshooting with a blindfold

with a client that is paranoid about SOX compliance

swasheck

3:08 PM

hahah

maple_shaft

where the corporate politics is so thick and so heavy that you can can't cut through it with a knife... and god forbid there is a single bug

because pushing a new release for them takes months

never

again

DTest

this 'bug'/feature of mysql is so annoying bugs.mysql.com/bug.php?id=61555

swasheck

@DTest "This implies that MySQL InnoDB HAS NOT BEEN ACID COMPLIANT FOR THE LAST 5 YEARS."

DTest

that among other things :D

swasheck

@DTest are you beginning to see the light?

DTest

3:11 PM

(un)luckily, most mysql apps don't give a rats about ACID compliance

swasheck

i kid, i kid

DTest

@swasheck No, i just want it to be fixed :D

swasheck

@DTest quite true

@DTest there are a multitude of mysql->postgresql tools out there

DTest

if I had an inkling on C programming, I'd probably delve into the source. But I doubt it's a simple fix.

@swasheck hehe..i am curious how postgres would handle the situation.

ConcernedOfTunbridgeWells

3:52 PM

@DTest If you've never used C it might be worth your while learning it. Its bark is worse than its bite - architecturally C is actually quite simple. For a start, these were some pontifications I wrote about picking up C from a background in other languages.

There are truckloads of C programming resources on the web.

swasheck

@ConcernedOfTunbridgeWells #13 is priceless

nothing says "Disaster Recovery Mode" like posting a question and abandoning it

0

Q: Unable to start SQL Server Instance 2008 R2 - DB file corrupt

I was not able to start the SQL Server 2008 R2 production DB instance. After reading the log file error message is " The log scan number passed to log scan in database ‘master’ is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). ...

DTest

@ConcernedOfTunbridgeWells some good pointers for sure, but I'm sticking with my script languages for now :)

swasheck

@DTest Lua, Haskell, etc.?

ConcernedOfTunbridgeWells

@DTest Try reading some of Ousterhout's pontifications on two language programming. Most of the common open-source scripting languages (Tcl, Python etc.) have C APIs that make it easy to bolt the interpreter into a C program, or vice-versa. Writing the core functions in C and wrapping them in a scripting language is often a good way to build an application.

DTest

@swasheck snakes, oysters and sledgehammers (python, perl, bash respectively)

swasheck

4:02 PM

@DTest thank goodness you didnt say PHP

though i prefer zsh

ConcernedOfTunbridgeWells

@DTest Python's C API isn't as straightforward as Tcl's one is, but it's quite easy to build a Python front-end on (say) a fast handler for a core data structure written in C.

swasheck

@ConcernedOfTunbridgeWells that's pretty common in the python community

ConcernedOfTunbridgeWells

Tcl's C API is dead simple. It uses an argv-style structure to interchange data between the Tcl interpreter and the C code. It was originally designed for wrapping command line C programs.

DTest

@swasheck developers.facebook.com/blog/post/2010/02/02/…

ConcernedOfTunbridgeWells

@swasheck Yes, it is. I think its quite a good way to build apps.

swasheck

4:06 PM

@DTest the exception to the rule

DTest

i think they released a new version recently but couldn't find the article. the art of compiling has been lost to me for 10 years.

most of the stuff I write now adays are quality of life scripts and not full-fledged apps

Jack Douglas

4:20 PM

@maple_shaft "...This Service is not an instance - it's a slice of an instance, implemented with schema isolation. So just as you could not create a RAC node from a schema, you cannot create one from a Database Cloud Service. In addition, configuration options like RAC are not exposed in the Database Cloud - it's essentially Platform-as-a-Service, not Database- or Infrastructure-as-a-Service..."

Ben Brocka

@maple_shaft facebook is trying to be that...sorta. Only it;s real data instead of these famed Nielson families no one seems to know

Have you ever known someone in a Nielson household? I sure as heck haven't...

swasheck

@BenBrocka my family was approached about it within the last 5 years - but then when they heard how little TV we actually watch ...

Ben Brocka

@swasheck Heh. Yeah, they'd never let me be one either. My "TV" is youtube and netflix...and I do'nt use netflix

swasheck

@BenBrocka we're heavy netflix/amazon prime users. other than that we watch "The Amazing Race" and I watch sports OTA. We keep cable because the bundle is cheaper than paying for Internet access outright.

Ben Brocka

Hate cable companies for crap like that

swasheck

4:39 PM

@BenBrocka is there a home electronics SE?

Ben Brocka

@swasheck there's "electronics," which is really more like electrical engineering

swasheck

meh ...

Lamak

truly bad answers here, specially since the problem was already identified on comments

0

Q: Select distinct returning duplicate results

I'm trying to return the top n most read blog posts in a kentico site, but for some reason my query is returning two duplicate rows despite using the DISTINCT clause. The query is below: SELECT DISTINCT TOP 3 [BlogPostTitle] ,[BlogPostDate] ,[BlogPostSummary] ,[BlogPost...

sql distinct kentico

Ben Brocka

There's also DIY/home repair

swasheck

@BenBrocka yeah - that's my thought. i just coerced comcrap into a good deal

so i'm looking to go OTA HDTV

Jack Douglas

4:44 PM

@Lamak you are not kidding

but tbh I'm glad that king of stuff is off-topic here

Cade Roux

@swasheck Did that, haven't looked back.

swasheck

@CadeRoux we don't watch much tv and what we do watch is available OTA ... we stream quite a bit so i would like to keep Internet, but the blocker has always been Comcast's belligerence with its bundling.

maple_shaft

@BenBrocka relevant:

> "Ratings are a currency, so they're just as important now as they were ten years ago. It's how we get paid. But in this new media environment, do these numbers reflect accurately how many people are viewing this content? The answer is no."

President of NBC

Cade Roux

@swasheck We're on Cox. The only thing we watch on "TV" is the Saints, which is always sold out so it's always available OTA from a local network affiliate - even the Monday and Thursday night games. Everything else is Amazon, Netflix or Plex (via USENET downloads and DVD rips).

maple_shaft

What happens to a country when it finds out its currency is valueless?

Weimar Republic comes to mind

swasheck

4:58 PM

@CadeRoux yep ... Broncos and The Amazing Race here.

@maple_shaft exactly my point

maple_shaft

people needing a wheelbarrow full of money to buy a loaf of bread

Lamak

@JackDouglas but op already said that the records weren't exact duplicates, why is people still giving wrong answers?, and some of them have upvotes

maple_shaft

20,000 households out of 115 million TV viewing households

does not an accurate sample size make

swasheck

@maple_shaft additionally ... i had a friend who grew up in the USSR and he said that their lottery, at one point, was for toilet paper

maple_shaft

Heavily watched shows get cancelled all the time because of stasitical anomalies

Firefly anyone?

Ben Brocka

5:00 PM

@maple_shaft exactly. Ratings are worse measures of engagement/etc than clicks online, as long as click fraud is mitigated. So why are they LESS valuable? It's crazy.

maple_shaft

^^^^

Cade Roux

@swasheck I would gladly put the money I spend on USENET service towards a streaming service that had everything - HBO, etc. But right now it's too much trouble, so we just use my parents's Netflix account and Amazon Prime

maple_shaft

Family Guy was cancelled after two seasons because it got poor ratings... but apparently MILLIONS of people watched and loved it

i was one of those

but only a few neilson families watched family guy

so the show was cancelled

Jack Douglas

@Lamak downvotes from me :-) you can't second guess the hordes on SO

maple_shaft

these kinds of variances occur when your sample size is not sufficient for the size of the population

swasheck

5:03 PM

@CadeRoux nice. i am somewhat disappointed in the movie offerings on amazon and netflix, but meh

maple_shaft

The problem with online advertisements is that there isn't a single unifying currency that can replace what Neilson data is

Cade Roux

@swasheck The kids like the kid series like Arthur and Martha on Netflix from visiting my parents. And we already have Prime.

swasheck

@CadeRoux ... so i need a tuner and an antenna?

maple_shaft

We need Bitcoin for ad clicks, and EVERYBODY must accept it as a standard

Jack Douglas

@maple_shaft 20,000 is plenty for 115 million if I understand statistics correctly, with one big caveat: they have to be truly representative (ie random)

Cade Roux

5:06 PM

@maple_shaft Which is why we need digital certificates and subscribers. Your purchase of the rights should be independent of the delivery. You should be able to buy a movie on Amazon and then decide to use Apple as your provider. None of this will ever happen.

maple_shaft

@JackDouglas The kind of family that would volunteer for something like Neilson immediately makes it no so random

but I digress, mathematically speaking 20k is sufficient

it used to be 5k not so long ago!

Cade Roux

@swasheck If you have an HDTV, you shouldn't need a converter box - I just have a little square antenna which usually works fine - sometimes it needs to be moved, but we only use it about 20 times a year

maple_shaft

@CadeRoux It gives me hope though for the future that business plans based on ad revenue are still nowhere near tapped out, we have hit the tip of the iceberg.

If this unifying currency exists some day then impressions can be tracked universally, and then all those eyeballs become a LOT more valuable to a lot more companies, $$$

@CadeRoux Perhaps instead of purchasing a certificate for the specific content, that all content be given a universal certificate regardless of provider. Information on impressions can be tracked and provided to an indpendent certificate authority that maintains a business model of providing Neilson like reports to interested advertising agencies

Now as an ad agency, I find your content as a provider more useful to me if your content has this unique cerficate because my report shows that Gangnam Style got 800 million views worldwide

It is crazy enough to work

Cade Roux

5:22 PM

@maple_shaft Exactly.

Lamak

5:51 PM

It seems that my comments are angering people lately. Now I'm getting random downvotes on 2 years old answers. sigh

6

A: How to edit data in result grid in SQL Server Management Studio

You can do something similar to what you want. Right click on a table and select "edit top 200 rows" (if you are on SQL Server 2008) or "open table" in SQL Server 2005. Once you get there, there is a button on the top that says "SQL"; when you click on it, it lets you write an SQL statement and y...

Not ready to pull an Aaron yet, though :-)

Transcript for

The Heap™ – Consultancy ©®