|
Sqlplus is my second home: Part 7 – Downloading files via sqlplus :-)
-
tanelpoder.com
-
13 years ago
-
eng
Some years ago I wrote about how sqlplus allows you to run sqlplus scripts directly from HTTP and FTP locations instead of the local filesystem. By the way, I didn’t even notice – my blog is over 5 years old already! :) I a recent email thread Marco Gralike just showed the simplest way I to open a HTTP URL and download + list its contents in a CLOB datatype. It’s the HTTPURITYPE and its getCLOB (and getBLOB) methods.
|
|
Sqlplus is my second home: Part 7 – Downloading files via sqlplus :-)
-
tanelpoder.com
-
13 years ago
-
eng
Some years ago I wrote about how sqlplus allows you to run sqlplus scripts directly from HTTP and FTP locations instead of the local filesystem. By the way, I didn’t even notice – my blog is over 5 years old already! :) I a recent email thread Marco Gralike just showed the simplest way I to open a HTTP URL and download + list its contents in a CLOB datatype. It’s the HTTPURITYPE and its getCLOB (and getBLOB) methods.
|
|
After writing my last post, The Next Step , and as I went back to perusing the steady stream of news and articles I proctor throughout the day, I started thinking about the prevalence of the Apple blog. I touched on this briefly in my last article. There’s a strangely pervasive mentality in the blogosphere these days that in order to be successful, one must do some combination of three things: write about Apple, adopt the linkblog format....
|
|
Now, Google’s no stranger to crazy experiments, and not all of them will necessarily change the world: for every self-driving car and wearable display, there’s an army of employees working on personal engineering projects. But it doesn’t sound like that’s what’s happening here.” - Sean Hollister of The Verge in Google building secret wireless network, says it involves ‘highly competitive consumer electronics’ . Permalink.
|
|
Can you imagine if one of these new open sourcerers took my advice and got this response, without the support I had. Can you imagine?” Disappointing. If you see a problem but do nothing constructive to remedy it, are you really seeing the right problem? Permalink.
|
|
As is usual for tea club, we performed tangentially related activities. A tangent so long that one may struggle to see the connection with tea. That is indeed why we are named “Tea and Stuff”, because as well as tea, we do stuff.
|
|
As is usual for tea club, we performed tangentially related activities. A tangent so long that one may struggle to see the connection with tea. That is indeed why we are named “Tea and Stuff”, because as well as tea, we do stuff.
|
|
Although the trailer features few live scenes from actual gameplay, it does exhibit impressive graphics especially when compared to traditional video game animations. I have high hopes for this game, and look forward to the day when live gameplay will be indiscernible from the animation used in the trailer. Permalink.
|
|
But when we’re gone, its hydrogen will still continue fusing, irrespective of the politics of our successor race, whatever species next decides to fill its nearest star with qualities like love, intentionality, goodwill, and grace.” I take some issue with this fatalistic point of view. The hydrogen will indeed continue fusing regardless of the majority of the decisions we make today, but that fact should not be used to discount the change..
|
|
In a space increasingly defined by Apple bloggers and their copycats, it is not only interesting to see another writer’s process, but also to see how that creator works towards such a different end product using largely the same tools as those obfuscating this space. “Fundamentally what he’s doing is quite simple: he tweets, and he retweets. A lot. Sometimes he goes 20 hours at a stretch, collating from those he follows and passing info..
|
|
I have now lived in Canada for over two years and there are some things that Canadians can’t seem to make up their mind on. Spelling Canadian spelling is stuck half way between British spelling and American spelling. Canadians will say: colour, favourite, honour (which are all British) program, realize (which are all American) Measuring units When you’re driving in Canada, everything is in kilometers. Snow fall is measured in centim..
|
|
I have now lived in Canada for over two years and there are some things that Canadians can’t seem to make up their mind on. Spelling Canadian spelling is stuck half way between British spelling and American spelling. Canadians will say: colour, favourite, honour (which are all British) program, realize (which are all American) Measuring units When you’re driving in Canada, everything is in kilometers. Snow fall is measured in centim..
|
|
Last weekend, we sponsored and attended our first PennApps, the world’s largest student run hackathon held at the University of Pennsylvania in Philadelphia. Nearly 500 students participated from a variety of universities across the US and elsewhere. Students were given 36 hours to get into teams, hack on projects, then show them off to the judges. The results were astounding. In total, over 100 hacks were submitted. Here are some of my per..
|
|
Last weekend, we sponsored and attended our first PennApps, the world’s largest student run hackathon held at the University of Pennsylvania in Philadelphia. Nearly 500 students participated from a variety of universities across the US and elsewhere. Students were given 36 hours to get into teams, hack on projects, then show them off to the judges. The results were astounding. In total, over 100 hacks were submitted. Here are some of my per..
|
|
A particularly astute observation from my favorite blog, Blogarach. “America is a nation of tantrum-throwing moral infants that’s been dragged bawling out of the crib of its own moral and ethical object impermanence, and even now it’s kicking and screaming on the floor of the department store, yelling that some black guy got into a California law school ahead of a deserving white.” Permalink.
|
|
Another post from what is quickly becoming my favorite blog, and one of the few sites whose articles I consistent read. “For all the po-faced, high-church sentimentality and stentorian sententiousness of the quadrennial American coronation day, there’s something almost charmingly — and disarmingly — tacky about our great national junket jubilee, a certain plastic tablecloth, fire-hall wedding, warming-tray ziti trashiness that makes the..
|
|
John Siracusa in an article from 2010, in which he briefly discusses the problem faced by those wishing to enter into blogging. “Of course, now I just spent 20 minutes futzing with Tumblr themes (before giving up when I realized that I won’t be happy with the results without investing many, many more hours) instead of writing the the post that motivated this little excursion in the first place.” For non-technical people, the problem..
|
|
The graph is among the most common data structures in computer science, and it’s unsurprising that a staggeringly large amount of time has been dedicated to developing algorithms on graphs. Indeed, many problems in areas ranging from sociology, linguistics, to chemistry and artificial intelligence can be translated into questions about graphs. It’s no stretch to say that graphs are truly ubiquitous. Even more, common problems often concern ..
|
|
The graph is among the most common data structures in computer science, and it’s unsurprising that a staggeringly large amount of time has been dedicated to developing algorithms on graphs. Indeed, many problems in areas ranging from sociology, linguistics, to chemistry and artificial intelligence can be translated into questions about graphs. It’s no stretch to say that graphs are truly ubiquitous. Even more, common problems often concern ..
|
|
The graph is among the most common data structures in computer science, and it’s unsurprising that a staggeringly large amount of time has been dedicated to developing algorithms on graphs. Indeed, many problems in areas ranging from sociology, linguistics, to chemistry and artificial intelligence can be translated into questions about graphs. It’s no stretch to say that graphs are truly ubiquitous. Even more, common problems often concern ..
|
|
Release includes, by popular demand: Improved the visuals - header space shrunk, overlaps fixed and nicer pics. The return of the small live tile - too small for me but people wanted it! Offline access - In testing at the moment. Swiping to move to next story. Minor Bug fixes. Clearer disclaimer .
|
|
The following question was asked on Stack Overflow: I have heard some strong developers say that “inline SQL in and of itself is not evil”. I do not understand how inline SQL is acceptable. To me its just like hard coding. Many a developer would scoff in my face for putting a connection string in the code vs a config file. So why is it that “SELECT value1,value2 FROM TABLE” is perfectly acceptable in compiled code?
|
|
Entity Framework and Foreign key constraint may cause cycles or multiple cascade paths
-
daniellittle.dev
-
13 years ago
-
eng
Today I ran into the issue for the first time. The first thing to note is the error isn't actually from Entity Framework it's from SQL…
|
|
Another article I glossed by a few weeks ago only to come back to it as the clock strikes midnight. “The changes to my working (and sleeping) routine have forced me to write when it’s time to write, not when I feel inspired.” At the time I didn’t understand the concept of writing when it was time to write rather than when I felt inspired, which is why I didn’t pay a great deal of attention to this article when Shawn Blanc first rele..
|
|
When I first saw this tweet roll by in my feeds either earlier this week I didn’t pay much attention to it. As I sit here and it’s nearly midnight, however, John Gruber’s excerpt came to mind: “Midnight: Hunter ready to write.” These days I have very small windows in which to write in: between homework and class during the day, and after I return home from FRC practice at 9:30 (at the earliest) each night. Outside of those small windows, wh..
|
|
Certainly one of the most interesting comparison I have seen to a closed nation like Korea scrolled into view in my news feed as an article from The Verge titled Eric Schmidt’s daughter reports on creepy North Korea trip, says the country is like ‘The Truman Show’ . Permalink.
|
|
A few days ago in preparation for posting We Have Lost One of Our Own , a short article I wrote eulogizing Aaron Swartz in response to the news that he had committed suicide, I spent some time perusing his work. This article, Take a Step Back, is one of the many I saved to Instapaper, and the one in which I found this interesting tidbit: “There are the blogs on ‘life hacks,’ which are full of gadgets and gizmos that seem to cause mor..
|
|
The title reworked for this article, Reginald Braithwaite’s article Why the Fuck? posted earlier today not only made it to the Hacker News front page, but to the top spot. He makes an interesting point to begin with, and then anticlimactically ended the piece with a call to arms in the fight against diabetes and obesity. But that’s his point: today the glamorous projects aren’t the ones helping people. The greatest technical minds of th..
|
|
I saw a similar post to this one a few days ago about Microsoft called Fail Fail Fail iPad on Gravitational Pull, using preductions from years long past that coincidentally fit current events to predict the eventual demise of Microsoft. Both articles were wrong. Permalink.
|
|
Tea Club was cancelled on Wednesday, so an impromptu belated meeting was held today instead, as all members were conveniently present thanks to a film night. This gave us the perfect opportunity for subjecting unaware participants to a very (un)scientific study.
|
|
Tea Club was cancelled on Wednesday, so an impromptu belated meeting was held today instead, as all members were conveniently present thanks to a film night. This gave us the perfect opportunity for subjecting unaware participants to a very (un)scientific study.
|
|
Persistencia ha sido el tema tratado en el OpenSpace que se ha realizado en las oficinas de tuenti. Hemos podido hablar sobre temas como NoSQL, ActiveRecord, BD basados en grafos, geoespaciales, … entre otros muchos. Ha habido mucho debate, con muchas opiniones, pero sobre todo muy buen ambiente. Muy interesante la charla que ha dado la gente de tuenti sobre como gestionan la persistencia. Es de agradecer la claridad y transparencia con ..
|
|
Ryota Watabe has translated some of my articles into Japanese and intends to translate more in the future (thanks for that! :) I have added a little “translations” section to the left sidebar of the blog (scroll down). Or just go to this link: http://www.csus4.net/d/japanese_translations_of_tanel_poder_s_posts_and_articles/ You might also want to follow Watabe-san on Twitter to get notified of any new Japanese translations that ..
|
|
Ryota Watabe has translated some of my articles into Japanese and intends to translate more in the future (thanks for that! :) I have added a little “translations” section to the left sidebar of the blog (scroll down). Or just go to this link: http://www.csus4.net/d/japanese_translations_of_tanel_poder_s_posts_and_articles/ You might also want to follow Watabe-san on Twitter to get notified of any new Japanese translations that ..
|
|
Earlier this morning Dan Ryan posted The Problem with Kickstarter over on Xconomy. Joshua Beckman of SthgNw commented on the piece, saying, “The problem really is that people sell ideas and are expected to deliver hard products.” I would take Josh’s opinion one step further: the problem is that people sell hard ideas and are expected to deliver hard products. Permalink.
|
|
So hiera wasn’t working when used through my puppetmaster. It worked perfectly when I was running my scripts manually with: puppet apply site.pp but the moment I switched over to regular puppetmasterd usage, everything went dead. I realized a while back, that I could always expect some hiera failures from time to time. Whether this is hiera’s fault or not is irrelevant, the relevant part is that I quickly added:
|
|
So hiera wasn’t working when used through my puppetmaster. It worked perfectly when I was running my scripts manually with: puppet apply site.pp but the moment I switched over to regular puppetmasterd usage, everything went dead. I realized a while back, that I could always expect some hiera failures from time to time. Whether this is hiera’s fault or not is irrelevant, the relevant part is that I quickly added:
|
|
What the heck is the INTERNAL_FUNCTION in execution plan predicate section?
-
tanelpoder.com
-
13 years ago
-
eng
Sometimes you see something like this in an execution plan: -------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | -------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | | | 2 (100)| | |* 1 | TABLE ACCESS FULL| T | 1 | 22 | 2 (0)| 00:00:01 | -------------------------------------------------------..
|
|
What the heck is the INTERNAL_FUNCTION in execution plan predicate section?
-
tanelpoder.com
-
13 years ago
-
eng
Sometimes you see something like this in an execution plan: -------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | -------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | | | 2 (100)| | |* 1 | TABLE ACCESS FULL| T | 1 | 22 | 2 (0)| 00:00:01 | -------------------------------------------------------..
|