@JeroenVannevel If your program has been tested on small examples and works there, then you might well be prepared to wait a while for a larger example to complete
SELECT q.UserId
,MIN(q.CreationDate)
,MIN(p.CreationDate) HAVING (p.PostTypeId = 2 AND p.ParentId = q.PostId)
,q.PostId[Post Link]
FROM
(
SELECT
MIN(p.CreationDate) [CreationDate]
,MIN(p.Id) [PostId]
,MIN(u.Id) [UserId]
FROM Users u JOIN Posts p ON u.Id = p.OwnerUserId
WHERE (p.PostTypeId = 1 AND u.Id = 34073)
GROUP BY u.Id
) q
,Posts p
GROUP BY q.UserId, q.PostId
ORDER BY q.UserId
hmm, I would have thought the p.ParentId = q.PostId would be a condition on the join with Posts, and the p.PostTypeId = 2 could either be part of the join condition or a where clause
It seems to be a common problem that people are unable to explain clearly what their program is supposed to do. I guess that's why programming-challenge problems are good to review — at least you can find and read the original problem description
WITH FirstQs(CreationDate, PostId, UserId)
AS
(
SELECT
MIN(p.CreationDate) [CreationDate]
,MIN(p.Id) [PostId]
,MIN(u.Id) [UserId]
FROM Users u JOIN Posts p ON u.Id = p.OwnerUserId
WHERE (p.PostTypeId = 1)
GROUP BY u.Id
)
SELECT UserId
,MIN(CreationDate)
--,MIN(p.CreationDate) HAVING (p.PostTypeId = 2 AND p.ParentId = q.PostId)
,PostId[Post Link]
FROM
FirstQs
GROUP BY UserId, PostId
ORDER BY UserId
@GarethRees I Googled for "globalized discretization" and it seems to be quite an advanced data mining/data science concept. Perhaps that's why it's difficult to understand, he might be taking a data theory type of course.
Practically everything that came up was a scientific paper. There's not even a Wikipedia page for it.
> The process of converting data sets with continuous attributes into input data sets with discrete attributes, called discretization, was studied in many papers, see, e.g., [1–3, 5, 7, 10, 11, 13, 15]. We will assume that input data sets contain examples, characterized by attribute and decision values. A concept is defined as a set of all examples that have the same value w for decision d.
So, sᴉɔuɐɹɥԀ suggested I write a SEDE query to find first questions with answers posted within 24 hours, and here it is:
WITH FirstQs(QCreationDate, PostId, UserId)
AS
(
SELECT
MIN(p.CreationDate) [CreationDate]
,MIN(p.Id) [PostId]
,MIN(u.Id) [UserId]
FROM Users u JOIN Posts p ON u.Id ...
FirstQsA(ACreationDate, APostId)
AS
(
SELECT
MIN(p.CreationDate) [ACreationDate]
,MIN(p.Id) [APostId]
FROM Posts p JOIN FirstQs ON CreationDate = p.CreationDate
WHERE (p.PostTypeId = 2 AND p.ParentId = PostId)
)
It only returns the value for the top item in FirstQs.
I have a program which reads and analyses MPEG-TS files. I've been using gperftools to identify hotspots and optimize them, and 45% of all samples at this point are in my main bitstream reader function.
I've already:
Reduced the number of overflow checks to one per call (not shown here, since ...
Just write a SELECT and try to join tables correctly, and apply aggregates & filters. SELECTs are the most difficult, other operations are pretty easy for the most part
Background
In machine learning, it's common to encounter the problem of making a decision as to which discrete category an object belongs to based on a set of continuous attributes. For example, we may have this collection of observations on three attributes A, B and C, where the decision has be...
Done a lot of reading today. Here is the completed router portion of the MVC-inspired project I am currently working on while trying to become a better programmer. I'm looking at how other frameworks are doing things and just kind of piecing together what like most.
Folder structure:
[project]
...
it's really like SQL with a few differences. See that let score? That lets (lol) you define an intermediate variable in your query to store a result of a subquery. It's basically a nested select statement
a from-select query returns an IQueryable so you can perform Queryable extension methods on it: just put parentheses around it and you have your collection to call things on
that's compiler stuff. It creates an expression tree
I am using below code to recognize which set up I need to use in Codeigniter:
$dev_urls = array('dev.com');
$prod_urls = array('prod.com');
if(in_array($_SERVER['HTTP_HOST'], $dev_urls)){
define('ENVIRONMENT', 'development');
}
else if(in_array($_SERVER['HTTP_HOST'], $prod_urls)){
defin...
I have written the following utility, as my first non-tutorial program in Go.
The purpose of the utility is
to connect to a torque/force sensor (aka load-cell) via UDP;
to send an initialization command; and
to record the resulting stream of measurements.
Since I am planning further functio...
@JeroenVannevel people were saying they had to run some mission with some random people online and got 23000 cash or something for beating it, and they were pretty excited about it.. doesn't sound like the GTA that I am interested in playing
sounds like an MMO grind is what i mean
@Marc-Andre i like the ones like saints row, just cause, and crackdown where you have godlike powers
The Aim
Since I very rarely write code to do things other than business logic any more I've set myself a challenge:
Split a string into a list of substrings by splitting on a matching string, without using string.Split() or similar methods of string (substring, indexof, etc).
The method must a...
Your organization is a bit confusing.
TCFileData is a hacked attempt to force abstract classes into a language without abstract classes, and TCFile is a hacked attempted at creating a namespace for a language that doesn't have namespaces, and your use of generics here seems unnecessary.
I think...
I am completing the CodingBat exercises for Java. Here is the one I have completed just now:
Given n > = 0, create an array length n * n with the following pattern, shown here for n = 3 :
{0, 0, 1, 0, 2, 1, 3, 2, 1} (spaces added to show the 3 groups).
Here is my code:
pub...
let queue = NSOperationQueue()
queue.addOperationWithBlock() {
// do stuff on this background queue
}
let mainQueue = NSOperationQueue.mainQueue()
mainQueue.addOperationWithBlock() {
// do stuff on the main thread
}
Of course, there's an NSOperation object, so you can just create an NSOperation object, and call queue.addOperation(op), or you can create an array of operations, and add them all at once.
queue.cancelAllOperations()
You can set (or get) the maximum concurrent count.
Get the count of remaining operations on the stack (or just get a reference to the operation array)
But the real power comes when you start diving into the NSOperation class itself.
Your organization is a bit confusing.
TCFileData is a hacked attempt to force abstract classes into a language without abstract classes, and TCFile is a hacked attempted at creating a namespace for a language that doesn't have namespaces, and your use of generics here seems unnecessary.
I think...
If a function is 1 line and it's well-named (here it's just "silly_case"), and there's test coverage for that function, do you still find that 1 line unreadable? If anything I might change (len(input_string) + 1)/ 2 to pivot_index and perhaps move "".join(string_as_list) to its own line but otherwise this seems like a straightforward list comprehension to me. — Scott Lobdell2 hours ago
There's not much code here, but I think it can be pretty cleanly divided into two parts:
Generate three bytes for a color from an integer
Have a way of getting multiple integers which are guaranteed to be unique
Simple as your algorithm is, you're already running into limitations by coupling ...
I am using below function to set month information on context passed. It is working fine, but please review it and let me know if any potential flaws or any improvements in this code
// Expects month to be 1-12 index based.
prototype.monthInformation = function(year, month){
var date = ne...
Okay, so if I've done my query correctly, there are 8,670 questions, which were the first question asked by that asker, and received an answer within 24 hours.
So, sᴉɔuɐɹɥԀ suggested I write a SEDE query to find first questions with answers posted within 24 hours, and here it is:
WITH FirstQs(QCreationDate, PostId, UserId)
AS
(
SELECT
MIN(p.CreationDate) [CreationDate]
,MIN(p.Id) [PostId]
,MIN(u.Id) [UserId]
FROM Users u JOIN Posts p ON u.Id ...
I have a program which reads and analyses MPEG-TS files. I've been using gperftools to identify hotspots and optimize them, and 45% of all samples at this point are in my main bitstream reader function.
I've already:
Reduced the number of overflow checks to one per call (not shown here, since ...
Done a lot of reading today. Here is the completed router portion of the MVC-inspired project I am currently working on while trying to become a better programmer. I'm looking at how other frameworks are doing things and just kind of piecing together what like most.
Folder structure:
[project]
...
I have written the following utility, as my first non-tutorial program in Go.
The purpose of the utility is
to connect to a torque/force sensor (aka load-cell) via UDP;
to send an initialization command; and
to record the resulting stream of measurements.
Since I am planning further functio...
The Aim
Since I very rarely write code to do things other than business logic any more I've set myself a challenge:
Split a string into a list of substrings by splitting on a matching string, without using string.Split() or similar methods of string (substring, indexof, etc).
The method must a...
Your organization is a bit confusing.
TCFileData is a hacked attempt to force abstract classes into a language without abstract classes, and TCFile is a hacked attempted at creating a namespace for a language that doesn't have namespaces, and your use of generics here seems unnecessary.
I think...
I am completing the CodingBat exercises for Java. Here is the one I have completed just now:
Given n > = 0, create an array length n * n with the following pattern, shown here for n = 3 :
{0, 0, 1, 0, 2, 1, 3, 2, 1} (spaces added to show the 3 groups).
Here is my code:
pub...
There's not much code here, but I think it can be pretty cleanly divided into two parts:
Generate three bytes for a color from an integer
Have a way of getting multiple integers which are guaranteed to be unique
Simple as your algorithm is, you're already running into limitations by coupling ...
I am using below function to set month information on context passed. It is working fine, but please review it and let me know if any potential flaws or any improvements in this code
// Expects month to be 1-12 index based.
prototype.monthInformation = function(year, month){
var date = ne...
