6 ms·
Thank you for the examples. I made some queries that are analogous to my temporal query needs Here I'm looking for every student, other students with DOB with
by koolkao 13y ago
Thank you for the examples.
I made some queries that are analogous to my temporal query needs
Here I'm looking for every student, other students with DOB within 2 weeks of the given student:
http://demo.htsql.org/student.define(similar_students:=%20(student.dob%3E=dob%20-%2014%20&%20student.dob%3C=dob%20+%2014%20&%20student.id%20!=%20id)@student)%20%7Bid,%20name,%20dob,%20/similar_students%7Bid,name,dob%7D.sort(dob)%20%7D http://demo.htsql.org/student.define(similar_students:=%20(s...
Here for every semester with at least one student, I find the oldest and the youngest students enrolled:
http://demo.htsql.org/semester%20.define(starting_students:=%20(student.start_date%3E=begin_date%20&%20student.start_date%3C=end_date%20&%20!is_null(student.dob))@student)%20%7B*,%20count(starting_students)%20:as%20'nStudent',%20max(starting_students.dob)%20:as%20'youngest',min(starting_students.dob)%20:as%20'oldest'%20%7D%20?%20count(starting_students)%3E0 http://demo.htsql.org/semester%20.define(starting_students:=...
No being a computer scientist I have to admit I do not appreciate the intricacies of the 'problems with SQL' blog entries. But working with htsql I gotta say it seems a lot more intuitive than SQL. It feels like the logic correspond much better to my mental model. And that there is much less of the jumping up and down the code to nest my SQL code logic that I find myself doing all the time.
Is there a way to install this on a PostgresQL instance on Win8?
- clarkevans 13y agoHTSQL requires Python 2.7 and psycopg2 binary. As long as those install, I don't see any problems. We have tested it with older versions of Windows without any issues. If you run into a problem, you could report an issue: https://bitbucket.org/prometheus/htsql/issues https://bitbucket.org/prometheus/htsql/issues