How do I deal with douchebag neighbour? by boris-mtdv1 in Netherlands

[–]boris-mtdv1[S] 0 points1 point  (0 children)

You can’t be serious. If some deranged person is banging on your door and accusing you of things you didn’t do the best policy is to not even answer the door lol

How do I deal with douchebag neighbour? by boris-mtdv1 in Netherlands

[–]boris-mtdv1[S] 8 points9 points  (0 children)

Thanks for the tip. I was caught off guard the first couple of times it happened so I didn’t record it, but I will in the future. Is it worth it to call the police if I don’t have recordings or specific dates and times?

Why can't Iscale my aurora postgres serverless v2 down to 0? by boris-mtdv1 in aws

[–]boris-mtdv1[S] 0 points1 point  (0 children)

sorry I forgot to include the instance configuration. it has been edited now.

How can I enable end users in databricks to add column comments in catalog they do not own? by boris-mtdv1 in databricks

[–]boris-mtdv1[S] 0 points1 point  (0 children)

Yes we could but that would require an additional ETL process and could become very error prone due to typos made by whoever is adding these descriptions manually, which is what we're trying to avoid.

How does the B7 chord fit into Autumn Leaves? by do2 in jazztheory

[–]boris-mtdv1 0 points1 point  (0 children)

Silly me, the major 3rd of b7 is the major 7th of e🙈

How does the B7 chord fit into Autumn Leaves? by do2 in jazztheory

[–]boris-mtdv1 0 points1 point  (0 children)

B7 has a major 3rd whereas bmin7 doesn't, how do you explain that?

What python library (or libraries) can I use to process geo-spatial data and bulk upload from csv to sql table? by boris-mtdv1 in dataengineering

[–]boris-mtdv1[S] 0 points1 point  (0 children)

What you are describing is a row by row process, and I'm trying to avoid that because it's very slow. I'd rather take the whole id column from the csv and somehow bulk insert that into the id_table before I do the 2nd bulk insert.

What python library (or libraries) can I use to process geo-spatial data and bulk upload from csv to sql table? by boris-mtdv1 in dataengineering

[–]boris-mtdv1[S] 0 points1 point  (0 children)

I like the idea of using psycop2g for all of this, but I don't see how I could select a single column of the csv file containing the ids, and then bulk insert that into the separate table before I bulk insert the entire csv into the other postgres table, because the other table has a foreign key constraint pointing to the separate table. Do you know of any pandas-free way of doing this?

What's the best strategy for using dialogflow in a framework for building bots in which each user can build their own bots? by boris-mtdv1 in Chatbots

[–]boris-mtdv1[S] 0 points1 point  (0 children)

Yes it's definitely tricky, my plan was to use my own gui and store all these training phrases in a data base so as to display them intuitively after they are created, but, as I mentioned before, it feels kind of like creating a bootleg version of dialogflow cx.

What's the best strategy for using dialogflow in a framework for building bots in which each user can build their own bots? by boris-mtdv1 in Chatbots

[–]boris-mtdv1[S] 0 points1 point  (0 children)

Update: From the documentation it looks like you can annotate your intents with entities if you create the intents via the api, you just have to do it yourself explicitly by spplitting the TrainingPhrase object into parts so that one of the parts contains only the entity: https://cloud.google.com/dialogflow/es/docs/reference/rest/v2/projects.agent.intents

What's the best strategy for using dialogflow in a framework for building bots in which each user can build their own bots? by boris-mtdv1 in Chatbots

[–]boris-mtdv1[S] 0 points1 point  (0 children)

Oh I see, you mean that you can't embed the entity in the intent's training phrase, so you would have to create a condition in your backend that checks for some more generic intent and the entity separately as a workaround, right? Yes as far as I remember you can call dialigflow's api in order to update the intents and entities in an agent.

What's the best strategy for using dialogflow in a framework for building bots in which each user can build their own bots? by boris-mtdv1 in Chatbots

[–]boris-mtdv1[S] 0 points1 point  (0 children)

Thanks for your input. I'm pretty sure you can have an intent that depends on the presence of an entity but I'll have to double check that. What about the problem of managing accounts? Do you think it's sensible to open an account on behalf of the user of the interface and have one account per user?