Skip to main content

Posts

Array support in the works!

Hi all, Jon Hanna is working to add Array support to Npgsql. He already sent a patch which I applied to my working copy and it is working very well! Now it is possible to write code like that: NpgsqlConnection conn = new NpgsqlConnection("Server=127.0.0.1;User id=npgsql_tests;password=npgsql_tests;"); conn.Open(); NpgsqlCommand d = new NpgsqlCommand(); Int32[] a = new Int32[2]; a[0] = 4; a[1] = 2; NpgsqlCommand command = new NpgsqlCommand("select :arrayParam", conn); command.Parameters.Add(new NpgsqlParameter("arrayParam", a)); Console.WriteLine(command.ExecuteScalar()); conn.Close(); And get this logged on server: LOG: statement: select array['4','2']::int4[] Also, Npgsql is able to receive an array from server as the example above shows. Npgsql will print to console: System.Int32[] Which shows it received an int32 array as expected! Excellen...

Parameters explicit typing support commited in cvs

Hi all! Today I commited a patch ( here , here , and here ) to allow parameters explicit typing on plain queries. What this means? This means that all parameters are sent to backend carrying its explicit type as specified by DbType and/or NpgsqlDbType enums. This will allow better typing matching between client and server. See here for Jon Hanna discussion about it. This explict typing isn't completely new. It was already being applied to function calling. We just decided to apply it to plain queries too. Now queries are sent this way: select * from tablea where field_serial = '4'::int4 where they were being sent as: select * from tablea where field_serial = 4 This modification may lead to problems, as said in discussion above (end of first post), but we hope this can be easily fixed. Please, send your comments about it. Please, grab a cvs copy of it and give it a try. We soon will be doing a new beta release which will contain this code. Thanks Jon Hanna, Agrinei and Jos...

I'm back from my vacation!

Hi, all! I just returned from my trip to visit my grandfather and other related. It was very, very enjoyable and I could get some rest and meet great people! I took a lot of pictures with my digital camera ( in fact, I took more pictures this time than ever in my whole life! ) I shall post some here later. About development activities, I will be returning to Npgsql project and start to integrate many patches which are pending. Josh Cooley did the excellent job with Npgsql2 beta2 release so you can enjoy some of the newest features we implemented lately. Stay tuned for more features and improvements!! I'd like to thank Daniel Nauck for his asp.net providers implementation which are also available for download. Thank you, Daniel! That's all, folks. I will keep you informed as soon as I get more news.

Going out on vacation for 2-3 weeks

Hi, all! On this end of year, I'm going visit my grandfather. So, I will be out for 2 or three weeks starting on this wednesday (2007-12-12). But don't worry, Npgsql will be in excellent hands: Josh Cooley will be heading any new beta release (which we expect to be released soon) and all patches and reviews needed. I don't know if there will be Internet connection where I'm going to, but if there is, I will let you know. Thanks everybody and Merry Christmas!!

Npgsql listed as one of MS Entity Framework providers in Press Release

Hi, all! Microsoft has released its beta 3 of ADO.Net Entity Framework and Npgsql is one of the providers which will support it . We are working on this support and, as announced, we will have support for entity framework whithin 3 months of RTM. That's exciting news and shows we are doing a good work to bring better and better support for Postgresql .Net developers! Stay tuned! References: http://money.cnn.com/news/newsfeeds/articles/prnewswire/AQTH06106122007-1.htm http://online.wsj.com/article/PR-CO-20071206-904072.html?mod=wsjcrmain

Pure Eye Candy...

After struggle for some time to get compiz-fusion 0.6.2 to work on my old intel 855/GM graphics card, I finally got it working. I was playing around reading some bug descriptions of intel xorg driver when I faced a comment from Ian which gave me some hope: "Although I'm using Debian, if I turn this option off none of my terminal window contents get painted,[...]" This is exactly the behavior I was facing when running compiz-fusion with newer driver (2.1.1). After making the change in xorg.conf... voilĂ ! It worked perfectly! No more repaint problems!! Ah, the modification: Option "XAANoOffscreenPixmaps" "true" With this configuration set, I could go one more step and get mplayer composition to work. :) I followed the instructions on this blog post about mplayer composition and compiled mplayer rc2 with the patch linked there and to my surprise it worked perfectly!!! The only drawback is that the patch only works on 24bits and my card hasn...

Npgsql2 Beta1 Released!!

Hi, all! Npgsql Development Team is proud to announce that Npgsql2 Beta1 is available! Its assembly version is 1.98.1, just in case you need to configure something with it using its assembly number. In this release, besides the usual bug fixes, we would like to highlight initial support for System.Transactions, COPY IN/OUT and uuid postgresql 8.3 datatype. Full release notes can be found here . You can get it at the usual place . I'd like to thank God for allowing me to make this happen. I'd like to help all who helped us contributing with feedback, bug fixes and comments which allowed us to improve Npgsql even more! Stay tuned for more features in upcoming releases. Keep your feedback and bug fixes coming!