Is the goal to make good ORM queries easier or to prevent bad queries? It's not clear there's really a compiler solution to the latter. If you're inside a loop in which a database cursor is in scope, then further database queries are prohibited? It's hard to see how that could be enforced other than something like What Color Is Your Function (https://journal.stuffwithstuff.com/2015/02/01/what-color-is-...) with some functions marked as making queries and others as not.

To solve this, maybe instead best practice would be to ensure the database connection is not in a global variable and must be passed down. That would make it more obvious when a database is improperly used within a loop.

The same problem exists for any expensive operation within a loop (say, a database query while parsing the results of an API call, or vice versa).

Without commenting on the merits of that idea, I'll just say that I do not want to be the one who has to moderate user generated content.

That's not really the right picture.

Congress.gov, originally THOMAS.gov, was a product of the Republican Contract with America take-over of Congress in the mid 1990s. Republicans in Congress, including Rep. Issa for example, were helpful in expanding the information that Congress publishes publicly. In the last 15 years, efforts to make Congress publish more and better-structured information have been relatively bipartisan and, mostly, led by nonpolitical staff. I would not describe Democrats as having been the ones to have exclusively created the access to congressional information that we have today, although Democrats in recent years have led on government transparency and accountability issues generally, beyond the Legislative Branch.

Changes that have required legislation have, as far as I'm aware, not really been influenced by the President, other than being signed into law, since they are Legislative Branch concerns and not Executive Branch concerns.

I did much of that so I appreciate you saying that the documentation is excellent. :)

Hi. I run GovTrack.

OP may have been unlucky on the timing. The site isn't usually down. Here's the link to the text of H.R. 1 on GovTrack: https://www.govtrack.us/congress/bills/119/hr1/text

We automatically add links to U.S. Code and other citations. In this case Congress.gov is missing rich formatting which we have (I'm not sure why they are missing it for this bill, normally they have it). GovTrack also allows making diff-like comparisons between bill versions and between bills (for example, you can see the last-minute changes made ahead of the vote on this bill).

Source code is available on GitHub if anyone wants to try making GovTrack better, although it's quite complicated because Congressional information is complicated and there's no real money behind this: https://github.com/govtrack/govtrack.us-web/

If anyone has particular thoughts on what would be helpful when viewing bill text --- within the realm of the information that is actually freely available --- I am all ears.

Totally agree with you that pride is important, but there's definitely more. Being a good engineer is frequently a problem of design --- whether it's user experience or code abstractions. Design is partly art, and that makes us artisans at least some of the time. The code that I've written that has endured the longest --- decades --- has been code that was designed well.

Hi. Author of that article here, and I worked with the DC Council to get the initial prototype going, if anyone has any questions.

What's important in the story is that the law went from being not open to open and the law-publication-process was modernized internally. The fact that it ended up on GitHub was the least important, but most fun, outcome.

GitHub adds nothing of any value for the transparency and accountability of the lawmaking process (I mean, what lawmakers do), but it is a great platform for publishing structured data files for the law to create open access.

Millions of Americans already use GovTrack.us to track legislation in the U.S. Congress and how their representatives and senators vote. I created GovTrack twenty years ago with the idea that information in context helps us hold our government accountable and empowers us to become the best advocates for the issues we each care most about.

Now, help us expand our work to tracking the President and the White House.

I agree that ethnic Jews with Christian religious beliefs is a legitimate concept. But I would rather call them Messianic Jews (or just Christian Jews) rather than adherents of "Messianic Judaism." To say that "Judaism" can include Jesus erases the Jewish religion by leaving it without a name, conveniently benefiting the dominant Christian religion. (And Messianic Jews who are not Jews should be called something else entirely.)

Yes and that was what I was saying (sorry it wasn't clear).

What it means to be a Jew is complicated. Jews form an ethnicity of interconnected people with a range of beliefs and practices (it is, definitionally, not whether one is religiously adherent to Judaism). To me, one could in principle be religiously Christian and also ethnically Jewish (that's an unusual view among Jews), but to do that requires having an actual connection to the Jewish ethnicity (e.g. if one was raised ethnically Jewish and maintains a Jewish identity). My impression is that "Messianic Jews" are religiously and ethnically Christian who are importing Jewish practices into their otherwise non-Jewish identity. If OP's wife was born Jewish or converted prior becoming a "Messianic Jew," I would stand corrected.

If I, a very white person, start singing songs from Back churches, that doesn't make me Black. I wouldn't face the real-world struggles against racism of Black people, for example, and I think that's a useful hint when thinking about who is and isn't a member of a minority group like Jews. Likewise, acting out Jewish practices doesn't necessarily make one a Jew, and as one example it doesn't subject one to the sorts of anti-Semitism faced by Jews. I'm not saying facing anti-Semitism a necessary or sufficient condition for being a Jew, but if not that, then there must be something else that connects one to the Jewish ethnicity --- the interconnected people who believe they are Jews --- other than just by saying so.

The unfortunate part is where Christians try to pass themselves off as Jews by adding "Jewish" to the name of their denomination. I wish my great aunts and uncles could have added "Christian" to their denomination to escape being murdered in the Holocaust, that would have been nice.

Text is unexpectedly complicated. Use Unicode.run to debug text. Paste text or click an example to see: See when characters like emojis are composed of multiple code points. Click code points in the debugger output to highlight them in the text. Switch between text / UTF-32 / UTF-16BE. See where text changes direction in bidirectional text. Get warnings about hidden code points that can alter the display of the text and normalization. See each code point's escape codes in a variety of programming languages and the “length” of the text.

> Agencies will just need to work with Congress to help them write laws

This is already exactly how it works.

One reason why legislating takes so long is because there is an enormous amount of collaboration between legislators and agencies to get it as right as they can.