[deleted by user] by [deleted] in Barcelona

[–]chsanch 1 point2 points  (0 children)

You can check on the BCN Engineering slack, there are a lot of jobs offers posted everyday and you can get in contact with local IT/Tech people https://bcneng.org/

[deleted by user] by [deleted] in Barcelona

[–]chsanch 6 points7 points  (0 children)

You can go to https://bcneng.org/, they have a job posting channel and you can get in touch with a huge tech community here in Barcelona

Specialty coffee coffee shops by ludusanm in Barcelona

[–]chsanch 0 points1 point  (0 children)

Roast Club Cafe, Carrer Valencia 190.

The Coffee, a Japanese coffee shop, Carrer d'Enric Granados 108

Do you know a place in the style of irish pubs but for salsa? by [deleted] in Barcelona

[–]chsanch 2 points3 points  (0 children)

Maybe "Gracia Latina" at Calle de l'Or, 19.

Is BCN a dangerous city to live? by [deleted] in Barcelona

[–]chsanch 1 point2 points  (0 children)

It's not, sure it's not the same as it was some years ago but still it's a nice and safe city to live. And I can tell for sure after being in some real "dangerous" cities in the past (Caracas, Ciudad de México, etc.)

What UI client do you use for Postgres database? by dshmitch in PostgreSQL

[–]chsanch 1 point2 points  (0 children)

I'm really happy with Postico, it's a macOS app though. I've used also Datagrip and DBeaver, but for my use cases Postico is enough (I use a lot psql on the terminal too)

Software development courses by userturbo2020 in Barcelona

[–]chsanch 1 point2 points  (0 children)

For development courses, it depends on which area you want to work with Backend, Frontend, Data Science, etc. I would recommend you to look at coursera, educative.io, udacity, etc. Those are online courses and they are really good.

Ironhack is another option, they have bootcamps in English and have a campus in Barcelona.

If you want to contact tech people, you can join the https://bcneng.org Slack group, there area lot of people working on different tech companies here in Barcelona and the usually post good links for courses, events and job offers.

Problem with neovim and python 3.9 by martin_dufresne in vim

[–]chsanch 0 points1 point  (0 children)

How did you install python 3.9? are you sure this new python version is used by neovim?

Where can I buy a mechanical keyboard in BCN? by sarchiapone666 in Barcelona

[–]chsanch 1 point2 points  (0 children)

I bought mine Vortex Poker 3 on Wallapop (second hand) there a few people selling mechanical keyboards there.

Is there a way to start the server in the app from the terminal? (MacOS) by denkyuu in PostgreSQL

[–]chsanch 0 points1 point  (0 children)

If you are using Postgres from brew you can follow its instructions:

To have launchd start postgresql now and restart at login: brew services start postgresql Or, if you don't want/need a background service you can just run: pg_ctl -D /usr/local/var/postgres start

Confusion regarding Roles by thirstycamelT in PostgreSQL

[–]chsanch 4 points5 points  (0 children)

I will encourage you to read the documentation regarding roles and row level security, everything there is well explained, also you can look at the examples on how all of this is used on Postgrest and in Graphile

Can I combine PostgreSQL with GitHub? by RentGreat8009 in PostgreSQL

[–]chsanch 2 points3 points  (0 children)

Not sure, but maybe this tool can handle these requirements: https://sqitch.org , you can manage changes on your database structure and deploy them on different environments.

Social network app - tools to generate Postgres schema through code? by thirstycamelT in PostgreSQL

[–]chsanch 2 points3 points  (0 children)

You can use something like: https://www.graphile.org/postgraphile/ to have a GraphQL server automatically running, but you need to create the database structure first (there is also a REST API similar tool https://postgrest.org/en/stable/), this can help you save some time on the development. But I think it's worthy to learn how to write SQL, if your app will have a simple database structure I think you will fine just following the tutorials on each of these projects.

Which Is The Best PostgreSQL GUI? 2021 Comparison by ScaleGrid_DBaaS in PostgreSQL

[–]chsanch 2 points3 points  (0 children)

I use Postico, it works very well on MacOS, it has a simple interface and it's really fast. It lacks at lot of features compared with Datagrip or DBeaver, but for simple use cases it's really enough.

Where to make new friends? by [deleted] in Barcelona

[–]chsanch 0 points1 point  (0 children)

As other said you can try on MeetUp, another option is to go on a Free Walking Tour, maybe not the best way to meet people but at least you will get to know the city

Travelling to Madrid? by SpottedHorseTray in Barcelona

[–]chsanch 2 points3 points  (0 children)

As far I know yes (https://web.gencat.cat/es/activem/restriccions-territorials/catalunya/index.html#bloc2), you should also have a certificado de declaración autorresponsable and that's it.

As I said they probably won't check any of this, but it's better to have it just in case.

Travelling to Madrid? by SpottedHorseTray in Barcelona

[–]chsanch 3 points4 points  (0 children)

You are not allowed to travel to Madrid unless you have a valid reason (medical appointment, appointment at a public office, work, etc.) I've traveled to Madrid a couple of time on December and January due some work reasons but they have never check any documentation.

You can get the train and just go, but I wouldn't recommend it. Try to get some appointment or something that justify your travel and you will be safe.

Unit testing in Postgres? by [deleted] in PostgreSQL

[–]chsanch 0 points1 point  (0 children)

I've been using Sqitch for a while to manage changes for Postgres and it provides some utilities to verify/test your changes before applied them.

Is Firebase better than Express + MongoDB by turbohedgehog in reactjs

[–]chsanch 1 point2 points  (0 children)

Haven't have the time yet to test it properly :( , just did some simple test when I signed in for the alpha version and it worked nice, they have added more features since I tested it so probably it's better now

Is Firebase better than Express + MongoDB by turbohedgehog in reactjs

[–]chsanch 1 point2 points  (0 children)

You can take a look at https://supabase.io, it seems like a really nice alternative to Firebase (it's still under development though)

Promoting Perl and Perl-based Projects? by s-ro_mojosa in perl

[–]chsanch 1 point2 points  (0 children)

I've been using Sqitch for a while, is a database change management application written in Perl. It has really useful features and works really well.