AWS Entry into the TechEmpower Framework Benchmark Project

AWS Entry into the TechEmpower Framework Benchmark Project

[Shark8]

TechEmpower is Benchmarking different frameworks for web-development ( http://www.techempower.com/benchmarks/#section=motivation&hw=i7&test=json ).

There was no entry for AWS, or any other Ada showing (I know there's matreshka, and IIRC several Ada/CGI bindings), so I coded one up.

Unfortunately there is no DB-functionality in it right now, as I couldn't get the ODBC to work, nor could I find a working InterBase (or FireBird) binding for Ada.

Re: AWS Entry into the TechEmpower Framework Benchmark Project

[Shark8]

I suppose a link to what I've done would help:
https://github.com/OneWingedShark/web-framework-test

Re: AWS Entry into the TechEmpower Framework Benchmark Project

[Shark8]

I got a response from the TechEmpower guys and there're three options for DB:
MySQL, Postgres, and Mongo.

Well, I grabbed MySQL... tried to use GNADE, but that apparently linked in 16-bit code and couldn't be run on my system. I tried getting the GNADE 2.0 branch, but so far I cannot get it to link with mysqlclient.lib and/or libmysql.lib

Any suggestions?

Re: AWS Entry into the TechEmpower Framework Benchmark Project

[Dmitry A. Kazakov]

On Wed, 20 Nov 2013 23:21:30 -0800 (PST), Shark8 wrote:

> I got a response from the TechEmpower guys and there're three options for DB:
> MySQL, Postgres, and Mongo.
> 
> Well, I grabbed MySQL... tried to use GNADE, but that apparently linked in
> 16-bit code and couldn't be run on my system. I tried getting the GNADE
> 2.0 branch, but so far I cannot get it to link with mysqlclient.lib and/or
> libmysql.lib
> 
> Any suggestions?

ODBC

-- 
Regards,
Dmitry A. Kazakov
http://www.dmitry-kazakov.de

Re: AWS Entry into the TechEmpower Framework Benchmark Project

[Shark8]

> > Any suggestions?
> 
> ODBC

Thank you, but they said they're not doing ODBC:
https://groups.google.com/forum/?fromgroups=#!topic/framework-benchmarks/Lb6K6MZdgN0

Re: AWS Entry into the TechEmpower Framework Benchmark Project

[Vadim Godunko]

On Thursday, November 21, 2013 11:21:30 AM UTC+4, Shark8 wrote:
> I got a response from the TechEmpower guys and there're three options for DB:
> 
> MySQL, Postgres, and Mongo.
> 
> Any suggestions?

Matreshka ;-)

Re: AWS Entry into the TechEmpower Framework Benchmark Project

[ake.ragnar.dahlgren]

On Tuesday, November 19, 2013 3:59:04 AM UTC+1, Shark8 wrote:
> TechEmpower is Benchmarking different frameworks for web-development ( http://www.techempower.com/benchmarks/#section=motivation&hw=i7&test=json ). There was no entry for AWS, or any other Ada showing (I know there's matreshka, and IIRC several Ada/CGI bindings), so I coded one up. Unfortunately there is no DB-functionality in it right now, as I couldn't get the ODBC to work, nor could I find a working InterBase (or FireBird) binding for Ada.

Using GNATCOLL it's possible to "talk" to a SQLite or PostgreSQL database. To use it you use a text file to describe the tables of your database (the schema). Then you use the executable gnatcoll_db2ada to generate the tables in the database (I've only used it for PostgreSQL), and then you use the same tool to generate the Ada code to be used by your application. Example usage:

To create the tables in the PostgreSQL database:
gnatcoll_db2ada -dbmodel=database_description.txt -dbhost=localhost -dbport=5432 -dbname=database_name -dbuser=user_name -dbpasswd=some_password -createdb

To generate the Ada files:
gnatcoll_db2ada -dbmodel=database_description.txt -api=Auto_Generated_Database_API

When using the SQL database in the Ada code you need the Connection instance.

         Description : GNATCOLL.SQL.Exec.Database_Description;
         Connection  : GNATCOLL.SQL.Exec.Database_Connection;

      Description := GNATCOLL.SQL.Postgres.Setup(Database      => Database_Name,
                                 User          => User_Name,
                                 Host          => Host_URL,
                                 Password      => User_Password,
                                 SSL           => Postgres.Allow,
                                 Cache_Support => True);
      Connection := GNATCOLL.SQL.GNATCOLL.SQL.Exec.Get_Task_Connection(Description  => Description);

When you are finished talking to the database (i.e. when it's time to shutdown the application) you need to:

      GNATCOLL.SQL.Exec.Free (Connection);
      GNATCOLL.SQL.Exec.Free (Description);

You can for example construct an SQL statements by:

      Query_Insert : constant GNATCOLL.SQL.SQL_Query :=
        GNATCOLL.SQL.SQL_Insert(Values => ...);

Before using it you always need to reset the connection to the database by:
      Connection.Reset_Connection;
Then you can execute the SQL statement using the connection instance:
      ... := Connection.Insert_And_Get_PK(Query => Query_Insert,
                                          PK => Auto_Generated_Database_API...);

For further details please read the GNATCOLL documentation.

Best regards,
Åke Ragnar Dahlgren

Re: AWS Entry into the TechEmpower Framework Benchmark Project

[Jeffrey Carter]

On 11/21/2013 12:21 AM, Shark8 wrote:
> I got a response from the TechEmpower guys and there're three options for DB:
> MySQL, Postgres, and Mongo.
>
> Well, I grabbed MySQL... tried to use GNADE, but that apparently linked in 16-bit code and couldn't be run on my system. I tried getting the GNADE 2.0 branch, but so far I cannot get it to link with mysqlclient.lib and/or libmysql.lib
>
> Any suggestions?

I've accessed MySQL using APQ.

-- 
Jeff Carter
"I didn't squawk about the steak, dear. I
merely said I didn't see that old horse
that used to be tethered outside here."
Never Give a Sucker an Even Break
103

Re: AWS Entry into the TechEmpower Framework Benchmark Project

[Oliver Kleinke]

Am Wed, 20 Nov 2013 23:21:30 -0800 (PST)
schrieb Shark8 <onewingedshark@gmail.com>:

> I got a response from the TechEmpower guys and there're three options
> for DB: MySQL, Postgres, and Mongo.
> 
> Well, I grabbed MySQL... tried to use GNADE, but that apparently
> linked in 16-bit code and couldn't be run on my system. I tried
> getting the GNADE 2.0 branch, but so far I cannot get it to link with
> mysqlclient.lib and/or libmysql.lib
> 
> Any suggestions?

There's Postgres-Ada.
https://github.com/io7m/coreland-postgres-ada

GNATCOLL.SQL supports Postgres.
http://docs.adacore.com/gnatcoll-docs/sql.html

I think it should be fairly simple to code a minimalistic binding to
the MongoDB C API.

Re: AWS Entry into the TechEmpower Framework Benchmark Project

[Thomas Løcke]

On 11/21/2013 08:21 AM, Shark8 wrote:
> I got a response from the TechEmpower guys and there're three options for DB:
> MySQL, Postgres, and Mongo.
>
> Well, I grabbed MySQL... tried to use GNADE, but that apparently linked in 16-bit code and couldn't be run on my system. I tried getting the GNADE 2.0 branch, but so far I cannot get it to link with mysqlclient.lib and/or libmysql.lib
>
> Any suggestions?


Here's another vote for GNATColl:

http://docs.adacore.com/gnatcoll-docs/sql.html

It works very well. We use it quite extensively at AdaHeads for our
project.

-- 
Thomas Løcke | thomas@12boo.net | http://12boo.net

Re: AWS Entry into the TechEmpower Framework Benchmark Project

[J Kimball]

The old APQ 2.1 is practically a disaster. It doesn't support prepared
statements, accessing columns by name in some instances and feels rather
archaic overall. Not something I would suggest.

There is a APQ successor that effectively rips apart Warren's APQ and
rebuilds it part of the KOW framework by Ogro.

https://bitbucket.org/kowframework

On 11/21/2013 11:38 AM, Jeffrey Carter wrote:
> On 11/21/2013 12:21 AM, Shark8 wrote:
>> I got a response from the TechEmpower guys and there're three options
>> for DB:
>> MySQL, Postgres, and Mongo.
>>
>> Well, I grabbed MySQL... tried to use GNADE, but that apparently
>> linked in 16-bit code and couldn't be run on my system. I tried
>> getting the GNADE 2.0 branch, but so far I cannot get it to link with
>> mysqlclient.lib and/or libmysql.lib
>>
>> Any suggestions?
> 
> I've accessed MySQL using APQ.
> 

Re: AWS Entry into the TechEmpower Framework Benchmark Project

[J Kimball]

I added prepared statements and reorganized the packages in Postgres-Ada
and have it currently cramed into an assembla repo.

https://incendius.assembla.com/code/Ada-cx/git-6/nodes

On 11/21/2013 01:32 PM, Oliver Kleinke wrote:
> Am Wed, 20 Nov 2013 23:21:30 -0800 (PST)
> schrieb Shark8 <onewingedshark@gmail.com>:
> 
>> I got a response from the TechEmpower guys and there're three options
>> for DB: MySQL, Postgres, and Mongo.
>>
>> Well, I grabbed MySQL... tried to use GNADE, but that apparently
>> linked in 16-bit code and couldn't be run on my system. I tried
>> getting the GNADE 2.0 branch, but so far I cannot get it to link with
>> mysqlclient.lib and/or libmysql.lib
>>
>> Any suggestions?
> 
> There's Postgres-Ada.
> https://github.com/io7m/coreland-postgres-ada
> 
> GNATCOLL.SQL supports Postgres.
> http://docs.adacore.com/gnatcoll-docs/sql.html
> 
> I think it should be fairly simple to code a minimalistic binding to
> the MongoDB C API.
> 

Re: AWS Entry into the TechEmpower Framework Benchmark Project

[Jacob Sparre Andersen]

Thomas Løcke wrote:
> Shark8 wrote:

>> [...] there're three options for DB: MySQL, Postgres, and Mongo.

> Here's another vote for GNATColl:

And one more for me.  I use it both at AdaHeads (with Thomas) and for
other projects.

Greetings,

Jacob
-- 
xsnow | xshovel > /dev/null

Re: AWS Entry into the TechEmpower Framework Benchmark Project

[Shark8]

On Friday, November 22, 2013 1:37:14 AM UTC-7, Jacob Sparre Andersen wrote:
> Thomas L�cke wrote:
> 
> > Shark8 wrote:
> 
> >> [...] there're three options for DB: MySQL, Postgres, and Mongo.
> > Here's another vote for GNATColl:
> 
> And one more for me.  I use it both at AdaHeads (with Thomas) and for
> other projects.

That's the library I've had the most success with so far.
Unfortunately, the good build I got last night didn't include the Postgresql... so now I'm trying to get another good build, this time with it. Getting a persistent error from ld.exe: "cannot find -lpq"

*sigh*

Re: AWS Entry into the TechEmpower Framework Benchmark Project

[ake.ragnar.dahlgren]

On Friday, November 22, 2013 10:14:33 AM UTC+1, Shark8 wrote:
> On Friday, November 22, 2013 1:37:14 AM UTC-7, Jacob Sparre Andersen wrote: > Thomas L�cke wrote: > > > Shark8 wrote: > > >> [...] there're three options for DB: MySQL, Postgres, and Mongo. > > Here's another vote for GNATColl: > > And one more for me. I use it both at AdaHeads (with Thomas) and for > other projects. That's the library I've had the most success with so far. Unfortunately, the good build I got last night didn't include the Postgresql... so now I'm trying to get another good build, this time with it. Getting a persistent error from ld.exe: "cannot find -lpq" *sigh*

I've seen that error too. When you do ./configure for gnatcoll you should have one parameter -with-postgresql=path_to_the_directory_where_postgres_is_installed

Last time I recompiled gnatcoll the installation couldn't find Postgresql if the path to it contained spaces. It required a reinstallation of Postgresql to relocate it.

Good luck,
Åke Ragnar Dahlgren

Re: AWS Entry into the TechEmpower Framework Benchmark Project

[Ludovic Brenta]

Jacob Sparre Andersen writes:
> Thomas Løcke wrote:
>> Shark8 wrote:
>
>>> [...] there're three options for DB: MySQL, Postgres, and Mongo.
>
>> Here's another vote for GNATColl:
>
> And one more for me.  I use it both at AdaHeads (with Thomas) and for
> other projects.

Is it possible to persuade you guys to package gnatcoll for the next
release of Debian[1]?

[1] http://bugs.debian.org/640532

-- 
Ludovic Brenta.

Re: AWS Entry into the TechEmpower Framework Benchmark Project

[Shark8]

>> Getting a persistent error from ld.exe: "cannot find -lpq" *sigh*
> 
> I've seen that error too. When you do ./configure for gnatcoll you should have one parameter -with-postgresql=path_to_the_directory_where_postgres_is_installed
> 
> Last time I recompiled gnatcoll the installation couldn't find Postgresql if the path to it contained spaces. It required a reinstallation of Postgresql to relocate it.

Just tried uninstall/reinstall (to a location w/ no spaces) no luck. I'm going to uninstall and try the 32-bit version, but if that fails I'll be well and truly out of ideas.

Re: AWS Entry into the TechEmpower Framework Benchmark Project

[Thomas Løcke]

On 11/22/2013 06:45 PM, Ludovic Brenta wrote:
> Is it possible to persuade you guys to package gnatcoll for the next
> release of Debian[1]?
>
> [1] http://bugs.debian.org/640532


I'm a Slackware guy, so I really have no idea how to package stuff for
Debian, but funnily enough Jacob and I actually talked about this a few
days ago. I mentioned to him that it would be nice to have as wide a
range of Ada stuff available for Debian as there are for FreeBSD.

Jacob did not look un-interested in packaging gprbuild/gnatcoll for
Debian.  :)

-- 
Thomas Løcke | thomas@12boo.net | http://12boo.net

Re: AWS Entry into the TechEmpower Framework Benchmark Project

[Graham Stark]

On Tuesday, 19 November 2013 02:59:59 UTC, Shark8  wrote:
> I suppose a link to what I've done would help:
> 
> https://github.com/OneWingedShark/web-framework-test

That's interesting. I had a go at the first two database tests using the Posgres stuff in GnatColl and a little database code generator I wrote a couple of years ago (http://virtual-worlds-research.com/downloads/mill). The code is here:

https://github.com/grahamstark/techempower/

I suspect my version is much slower than their peak performers, though I've just tested it locally. They have a peak on the first database test of 105,939 whereas I'm struggling to get above 2,000; I'm guessing that's still under 10,000 on their hardware.

Graham

Re: AWS Entry into the TechEmpower Framework Benchmark Project

[Shark8]

[UPDATE]
I've gotten the static build going, now it's failing on the relocatable with the same error.

I did this by (a) adding "-L." and "-L.." to the linker's options in, IIRC, the common gpr file for GNATcoll; (b) enclosing "-lpq" in parentheses -- apparently the & operator chokes on adding a single element; (c) copying the contents of Postgresql's lib dir to the source-dir [from which make and ./configure are run].