This ORM looks interesting

It does distinguish between types, as has been pointed out in this thread.

I recreated the example from the video in SQLite:
https://gist.github.com/mattseh/185ea1c1da19132ac860

Here is the output:
https://gist.github.com/mattseh/a1f66394d842cb39cceb

That example was from SQLite. This is because SQLite doesn't have a dedicated date or datetime type, instead relying on base types, in this example, a string (reference: Datatypes In SQLite Version 3)

I tried a similar query on an app I'm working on, where pony is using Postgres, which is a lot more full featured.

Code:
In [11]: models.select(k for k in models.Keyword if k.last_google_search.year == 2013)[:]
SELECT "k"."id", "k"."site", "k"."keyword", "k"."last_search"
FROM "keyword" "k"
WHERE EXTRACT(YEAR FROM "k"."last_search") = 2013
It's almost like the ORM is generating database specific queries. Crazy, huh?

Edit: I looked into MySQL, and found this:

https://github.com/ponyorm/pony/blob/orm/pony/orm/dbproviders/mysql.py#L39

Anonymous quote from someone on skype: "kiopa seems stubbornly opposed to doing anything that might be convienent"
 


Anonymous quote from someone on skype: "kiopa seems stubbornly opposed to doing anything that might be convienent"

Yeah, and I could quite easily argue you guys are killing quality in order to save time. Again, I use my own database layer myself, but it's basically exactly the same as crackp0t. Only for single table stuff, but the majority stays in SQL.

Anyway, let's find out on (around) the 30th. :) crackp0t, you in? We need more people!
 
I was eager to read this thread and learn about a new ORM technique. But then I realized ORM didn't stand for online reputation management.
 
Is this still going to happen? I've been learning AngularJS in my spare time and want to try and build the front end for this in it (backend will be a Rails-powered JSON API). I'm not sure if that fits within the constraints of the competition as described previously but it might be interesting for some guys to read the code I end up writing.

Plus the odds of me completely failing are much higher because I'm still an Angular noob so that's fun too.
 
Yep, most definitely still happening. I was quite sick for a good while there, so if possible, just hang tight. I'll start a thread in this section shortly, with hopes of getting others on board.
 
I don't think the competition should attempt to compare raw development speed.

The delta speed of implementation between using ORM vs SQL, PHP vs Ruby, etc. is dominated to the point of immeasurability by far more monumental factors like familiarity/experience with the particular specs, your ability to focus, how you allocate your time, differences between participant devs, if you took your girlfriend's Adderall, etc.

Trying to compare dev speed also just complicates the logistics of this and prevents it from ever happening.

I think we should draw up a spec and just implement it with our favorite language and subsequent stack (full-stack framework/composable framework/orms/sql/sql generators/etc).

  • dchuck: ruby
  • me: clojure
  • mattseh: python
  • kiopa_matt: php
  • rage9: asm

Once we're done, then we could just compare our approaches and compare code.

I think we'd have a much more interesting post mortem if we didn't focus so hard on raw implementation speed. Let the code itself indicate which implementations are the fastest, cleanest, and most impervious to change.

Also, I think a good sample app would be a simple forum (tables: user, forum, topic, post). Create forum, create topic, edit, post, reply.
 
  • dchuck: ruby
  • me: clojure
  • mattseh: python
  • kiopa_matt: php
  • rage9: asm

I did not know I was part of your retarded version of the web developers "Hunger Games". I do not however, have an assembly web framework, so yeah, that's gonna be hard to produce.

I'd say Python, but mattseh will destroy me with his functional lambda statements.

3uvbax.jpg
 
I did not know I was part of your retarded version of the web developers "Hunger Games". I do not however, have an assembly web framework, so yeah, that's gonna be hard to produce.

I'd say Python, but mattseh will destroy me with his functional lambda statements.

3uvbax.jpg

it would be interesting to see the different ways you two code with the same language/framework. Plus, Matt is incapable of finishing a web app project so you have that leg up on him already.
 
it would be interesting to see the different ways you two code with the same language/framework. Plus, Matt is incapable of finishing a web app project so you have that leg up on him already.

It's live now, you just refuse to look at it.