tag:blogger.com,1999:blog-5541296000399974369.post4610244452797180294..comments2024-03-09T02:51:27.612-05:00Comments on Peter Eisentraut's Blog: How can I get the compiler to check my SQL queries?Anonymoushttp://www.blogger.com/profile/02849480732923051923noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-5541296000399974369.post-62239285031127851512009-07-22T06:03:58.103-04:002009-07-22T06:03:58.103-04:00We're currently working on PostgreSQL support ...We're currently working on PostgreSQL support in DbLinq, especially under Linux with Mono. It has to mature a bit, but we're already planning some advanced features like tsvector support.<br /><br />Feel free to partecipate at http://code.google.com/p/dblinq2007 or at ##dblinq on freenode!Emanuele Ainahttp://nerd.ocracy.org/em/noreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-60720679745744751202009-07-20T09:11:35.588-04:002009-07-20T09:11:35.588-04:00Support for this really needs to be built into the...Support for this really needs to be built into the language. Although I'm not usually a Micro$oft fan, I do have to admit that they have done a good job with Linq. You can use native C# code to write SQL-like queries against databases (as above), or against XML, or against any other provider that you can write.<br /><br />But the key is that the support for this was built into the language.Manly Henhttps://www.blogger.com/profile/00704913066303902256noreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-64918242891601577132009-07-19T15:46:50.866-04:002009-07-19T15:46:50.866-04:00http://linq.to/db<a href="http://linq.to/db" rel="nofollow">http://linq.to/db</a>.https://www.blogger.com/profile/03897424974394505020noreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-50741705194166348472009-07-19T14:52:36.584-04:002009-07-19T14:52:36.584-04:00There is PG'OCaml for OCaml: http://merjis.com...There is PG'OCaml for OCaml: http://merjis.com/developers/pgocamlTobunoreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-16056281406445519662009-07-19T05:30:31.883-04:002009-07-19T05:30:31.883-04:00Hi
http://link.to/db is "linq to sql" f...Hi<br /><br />http://link.to/db is "linq to sql" for other DBs including pgSQL.<br /><br />Mono is a implementation of C# and the associated stack.<br /><br />Combining the two gives you a completely open source stack that will run on *nix.<br /><br />I have never used linq but 5min of googeling did the job.<br /><br />EnjoyAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-58046078076152671192009-07-18T13:14:33.783-04:002009-07-18T13:14:33.783-04:00Well, there's my Java tool that I blogged abou...Well, there's my <a href="http://micktech.wordpress.com/2009/05/25/tmdbc-extending-the-java-compiler-to-handle-sql/" rel="nofollow">Java tool that I blogged about</a> a couple of months ago, scroll a bit down to see code showing how I do it.<br /><br />It doesn't do code completion of SQL, nor anonymous SQL like in that example, my approach is equivalent to declaring SQL functions in PostgreSQL, but it does syntax and type checks at compile time. It also generates the types if you want it to.<br /><br />When working on it I've also figured out features in PostgreSQL that would be beneficial for a tool that uses this approach. I'm planning on getting that up on that uservoice thing -- when I find the time to clean up and organize my notes, grumble grumble...Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-22739001587931151962009-07-18T13:07:59.950-04:002009-07-18T13:07:59.950-04:00In Python, Dejavu/GeniuSQL comes closest: the synt...In Python, Dejavu/GeniuSQL comes closest: the syntax is checked at "compile time" but the type checks are performed at runtime.<br /><br />You might look at GLORP which works similarly in Smalltalk.Anonymousnoreply@blogger.com