Bloomfield Ridge, Kings County, New Brunswick

Bloomfield Ridge is a settlement in Kings County, New Brunswick.

Bloomfield Ridge
Location of Bloomfield Ridge in Kings County, New Brunswick

History

Notable people

gollark: Yes.
gollark: And yes, this is a hybrid of JS and SQL via template strings, isn't it great?
gollark: And this doesn't even ACTUALLY WORK.
gollark: ```javascriptexport const enqueueCrawl = async (crawlURL, tier) => { // robotsPolicy will be filled in on first actual crawl for the domain // this has to be done as a fairly complex DB-side query to prevent race conditions console.log("running insert for", crawlURL.toString()) const [domain] = await DB`INSERT INTO domains (domain, enabled, robotsPolicy, tier) SELECT ${crawlURL.hostname}, FALSE, NULL, ${tier} WHERE NOT EXISTS (SELECT id, domain, enabled, robotsPolicy, tier FROM domains WHERE domain = ${crawlURL.hostname}) RETURNING id` console.log(crawlURL.toString(), domain) // Add entry to crawl queue await DB`INSERT INTO crawl_targets (url, domain) VALUES (${crawlURL.toString()}, ${domain.id}) ON CONFLICT (url) DO UPDATE SET added = NOW()`}```This should NOT be quite so bee.
gollark: I'm busy trying to work out exactly how horrible a PostgreSQL query I need to do this stupid thing under concurrent write load.

See also

References

    This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.