bbsimonbb

I read once that when draisiennes first appeared in 1817, it was a surprise to the inventor that you could in fact lift your legs up and balance.

I forget completely where I might have read or heard this, but I love it so much I'm going to keep telling it. Can anyone confirm?

QueryFirst. I'm seething with the injustice. Use SQL as a language in C# projects. https://www.youtube.com/watch?v=QkJDccYSw8A

What problem does this solve?

Not sure, to answer your question, and I've been here daily for years. https://www.newyorker.com/news/letter-from-silicon-valley/th...

Super. Thanks for posting! Nice stack. I shall be using some of you're picks I think. I really want to go back to Vietnam some day.

Minis were produced from 1959 - 2000. VW Beetles, an older design and much worse to drive, from 1938 - 2003!

Making something that has moving parts and works is satisfying in itself. Using your intelligence to make that thing readable, maintainable and well organised is a bonus. Making tools to help other folk do this is a further bonus. As the quality of so many other jobs is in freefall, just about every developer job is to be cherished.

My mid-size (140) well-run company is as healthy a human environment as I'm likely to find. Toxic bicycle associations I've been part of, or sleepy public sector workplaces I've known, have helped set my expectations. So I've absolutely no problem that my company makes a wholesome profit for it's founders. I see a little bit of it, and I'd much rather be coding than doing what they do.

Developer culture, as it's matured, is fairly remarkable for it's openess and flatness, and I'm mostly very happy with the company of developers and their weird hobbies. More women would be nice.

Despite the predictions that it would all move to India, developers have been constantly in demand since I started doing this 25 years ago. It's let me travel and work wherever I want, and now it's going to let me work remotely so I can spend time with ageing parents on the other side of the world. WTF. I must have been very good in a past life.

Glad you mentionned that. I bought it at the time, read it, loved it, and decided to not become famous !

Not just jetbrains. pgtyped does this for postgres and typescript, and queryfirst for c# against sql server/postgres/mysql.

Perhaps put those farmers in touch with diabetics who would like some affordable insulin, or researchers who would like to consult publicly funded, peer-reviewed-on-their-own-time, research.

"Typed raw SQL" is the best we could think of to name this approach. Perhaps hackernews can do better? The common criteria are that SQL must be be validated in situ, and strong typing should be continuous from the database into the application code.

Typed raw SQL for data access now exists for typescript/postgres (pgtyped), Go (sqlc), Scala (scala-slick) and perhaps others. QueryFirst, Visual Studio extension since 2016, now has a VS Code version, and multiplatform .net 5 command line. (github)

This isn't the trial. The prosecution legal argument should be summarised, but the classic issues at an extradition hearing are: Is the charge political? Will the defendant receive a fair trial? Is there a chance the defendant will be executed? Those are all well established grounds for not extraditing. Any one of them should have stopped this extradition long ago.

I've been reading Murray since about 2005. He's always interesting and it would be a mistake to dismiss him on one opinion. I lose count of the number of big stories he's broken, or found himself in the middle of. He wasn't as radical in 2005 as he's become. His book on Alexander Burnes is serious and fascinating history. If you google his site for "Guardian" or "Rusbridger", you can follow the evolution that has led me, and perhaps readers of his site, to have a great deal more confidence in what we read there than in, scary quotes, the main-stream media.

SQL should have been in .sql files from the start. SQL in string literals is an industry-wide decades long aberration. I fixed this problem for C# with QueryFirst. I'm delighted to see all the support here the approach, which is clearly the way forward for data access.

https://marketplace.visualstudio.com/items?itemName=bbsimonb...

What tools let you do this in Java? I'm looking at porting my QueryFirst extension to Java, and I couldn't find anything in the space.

https://marketplace.visualstudio.com/items?itemName=bbsimonb...

Google gives Leonora pop 556, which to me is much more believable. There's nothing for 2k folk to do in Leonora.

Fixing data access for C# :-) https://marketplace.visualstudio.com/items?itemName=bbsimonb... This, I humbly submit, is superior to _all_ the existing approaches, in terms of developer speed and comfort, runtime perf, and testability.

Compared to EF, you author your projections in a sandbox where you can get familiar with your data as you build up your projection. Compared to stored procs, your queries are versioned and distributed with the app. Compared to Dapper and ADO, your SQL lives in a real environment and you have zero mappings to maintain. This ought to change the world, no?

...in Australia

[HPV vaccine is systematically given](https://www.health.gov.au/news/protect-your-kids-against-hpv...) to all 12 year olds, boys and girls, for free through school vaccination programs.

You clearly have strong points of view on the subject, but did you read my comment? France's physical borders with all neighbouring countries except Switzerland are open. You just drive, or walk, or ski across. The Italian one is notionally open but police pass in the trains and the police presence near the border can be noticeable. The Swiss one is notionally controlled but tens of thousands of cars pass every day and hardly any are stopped. A brown friend skiing out of a French resort wasn't aware of crossing the border, but still spent his whole day in a Swiss border post.

Nowhere do I, or would I, try to absolve France or any other country of its responsibilities. If you're in France with no legal basis, you can work. You can sign a regular work contract. Moreover, a work contract or the promise of one, will (at least in theory I've never tried it) let you get papers to stay. The instructions are [here](https://www.legalplace.fr/guides/promesse-embauche-sans-papi...). If you apply for asylum, you cannot work for 6 months, but you will receive an allowance during this time. Instructions [here](https://www.service-public.fr/particuliers/vosdroits/F2741). France has at various times taken in "lots" of refugies. Most recently returning colonists from Algeria, but also Spanish, Portugese, Russian and Armenian, as well as "poor" immigrants from a string of places. France, unlike some of it's neighbours, operates a "droit du sol" citizenship policy. Immigrants and/or their children can become French.

France doesn't control its borders. The border of the schengen zone is long and porous (like all borders). I don't want to underestimate the difficulties for refugies getting a start in France. People with no papers can enrol their kids in school and get some health care. To get expelled from the country, in addition to having no papers, you have to be a threat to public order, or be caught working illegally. So people 'employed' by gig workers would be exposing themselves to expulsion.

I found out about this from the mailing list of community bicycle workshops. I have seen zero coverage in French press. I'm glad the NYT is as shocked as I was.

At design time, we use the connection string specified in the qfconfig.json file, or the one you specify in the .sql file. At run time, you supply the method that creates the connection, so you should be able to do whatever you want.

Stored procedures are automatically supported. It's just SQL. We can discover the return type and create the wrapper just as we can for a query. But SQL in it's own file feels so much like stored procedures, you might prefer to store and version your SQL with your app code rather than create procedures that live in the database.

That's the comment I wanted! My thing is tightly integrated with Visual Studio, but the same approach would work for typescript. How many folks are talking to relational DBs with typescript? More and more I suppose?

Dapper has swept the world, but it still makes you maintain your own POCO, and your SQL is still in string literals, which has to be just the weirdest cultural practice. With my thing, because your SQL is in it's own file, we can constantly validate it, as you type, every time you save, every time you rebuild your queries, every time you run your tests.

Late Night Live, Phillip Adams. The smartest people in the world, all of them, 3 a night, 4 nights a week for 20 years, with humour. This is the most remarkable lifetime achievement in radio anywhere - better than Studs Terkel.