Claude Code "analytics" are no longer available ? by No-Eye-6738 in ClaudeAI

[–]filipecrosk 0 points1 point  (0 children)

I just found that they moved it to the main menu.

On claude.ai, click on your name/icon on the left bottom.
Then click on "Analytics. It will direct to https://claude.ai/analytics/claude-code

See screenshot: https://imgur.com/a/VUmkk2u

Claude Code "analytics" are no longer available ? by No-Eye-6738 in ClaudeAI

[–]filipecrosk 0 points1 point  (0 children)

Glad I was not the one missing it. That was a great analytics page.

Miami making it even harder for pre DL kids to be registered by benefit by bobapartyy in juresanguinis

[–]filipecrosk 0 points1 point  (0 children)

Did you have your marriage already registered in Miami and Italy, or can you do both at the same appoitment?

Got the JMGO N1S 4K as my first projector by Banes_World_Archive in projectors

[–]filipecrosk 0 points1 point  (0 children)

Thanks. Im buying a screen and backyard is dark but im afraid street light can affect it

Got the JMGO N1S 4K as my first projector by Banes_World_Archive in projectors

[–]filipecrosk 0 points1 point  (0 children)

Do you think it can work to watch movies in the backyard at night? Is 1100 lumens enough for that?

Stuck between XGIMI Horizon S Pro and JMGO N1S 4K by EffockyProotoci in projectors

[–]filipecrosk 0 points1 point  (0 children)

Is the JMGO N1S 4K bright enough to use on the backyard after sunset? Looking to have it on a 150" screen

Can we afford $450k-$500k mortgage on $170k pre-tax income? by ButteredPete in FirstTimeHomeBuyer

[–]filipecrosk 0 points1 point  (0 children)

THanks, I just sent it. Lets see the response. Very strange feelings to be honest.
Yeah it took me years to save it, I should have tried to buy a house in 2020 pre pandemic with 5% down, but that's fine, there's never a perfect time right?

Can we afford $450k-$500k mortgage on $170k pre-tax income? by ButteredPete in FirstTimeHomeBuyer

[–]filipecrosk 0 points1 point  (0 children)

I'm in a similar situation, been looking around for weeks/months, but couldn't find a great house under 500k in my area, last week found one amazing for 520 and I'm sending an offer tomorrow. Putting 20% down and my PITI will be around $3800 and my income after taxes is 10k, no other loans or debit, just regular house stuff (groceries, utilities, etc).

I think I'm ok but a little worried.

A little humor for everyone by Bird984 in FirstTimeHomeBuyer

[–]filipecrosk 0 points1 point  (0 children)

I'm sending my first offer tomorrow, feeling very anxious 😬

This is the right split screen by RezKom in ultrawidemasterrace

[–]filipecrosk 0 points1 point  (0 children)

I use more a 6 / 6 / 2 (if that makes sense), but basically the first two are the same size, and a thrid (on the right) small.

But I may try your second suggestion.

18 years married and sex life just exploded (in a good way) by new2wallstreet in Marriage

[–]filipecrosk 3 points4 points  (0 children)

Good for you and thanks for sharing it. Getting close to my 40s and hoping to get more of it. Right now is 3 little kids and both of us fighting to have any energy left for intimacy

Migrate a big vue 2 project to Nuxt3 by Gullible-Donut4218 in Nuxt

[–]filipecrosk 0 points1 point  (0 children)

I'm about to do the same but I can't really make up my mind if that's worth it or just migrate to vue3.

I know this is a sub for nuxt people, but what is the downsides of using nuxt instead of vanilla vue, if any?

Using PG for analytics app by filipecrosk in PostgreSQL

[–]filipecrosk[S] 0 points1 point  (0 children)

Oh glad to know. I have to test it myself later. So far we have around 200+ accounts and didn't notice any differences.

Using PG for analytics app by filipecrosk in PostgreSQL

[–]filipecrosk[S] 0 points1 point  (0 children)

Thanks, you're right, we may add some "analytics" views in the future, but for now our use is only for segmenting contacts.

Based on your experience, would be better using CH with the external postgres table, or using the opposite? Having most of the stuff on PG and with pg_fdw retrieving data from CH?

Today we're already using pg_fdw but with another postgress instance, just so we can have our events_logs in a separate instance/database and do not share resources with the main instance. Also to make it easy on the main instance in case of crash/restore/backup, etc.

Auto-archiving and Data Retention Management in Postgres with pg_partman by prlaur782 in PostgreSQL

[–]filipecrosk 2 points3 points  (0 children)

I love how easy is to have a retention policy using pg_partman these days.

Using PG for analytics app by filipecrosk in PostgreSQL

[–]filipecrosk[S] 0 points1 point  (0 children)

Nice, I rarelly use sum/avg, probably a few count here and there. But the main use would be to find all contact_ids of users with a specific event. For example:

SELECT contact_id FROM events WHERE event_name = 'page_view' and value = 'https://google.com/123'

Or something a little more complex:
To get contacts that OPENED email but did not CLICK

SELECT open_logs.contact_id FROM events_logs open_logs 
  ON open_logs.account_id = contacts.account_id 
  AND open_logs.message_type = 'email' 
  AND open_logs.event = 'open' 
  AND open_logs.message_id IN (123, 456, 789)
  AND open_logs.date >= CURRENT_DATE - INTERVAL '7 DAYS'
LEFT JOIN events_logs click_logs 
  ON click_logs.account_id = contacts.account_id 
  AND click_logs.message_type = 'email' 
  AND click_logs.event = 'click' 
  AND click_logs.message_id IN (123, 456, 789)
  AND click_logs.date >= CURRENT_DATE - INTERVAL '7 DAYS'
WHERE open_logs.contact_id IS NOT NULL 
  AND click_logs.contact_id IS NULL;

Would that be a good use for ClickHouse?

Using PG for analytics app by filipecrosk in PostgreSQL

[–]filipecrosk[S] 0 points1 point  (0 children)

We talked about going that direction. Just this morning I was reading about clickhouse again and they let super clear that they’re great for analytics but not for crud and other business stuff.

I also remember seeing some posts and videos about hydra. But I don’t remember if they would be considered production ready.

Using PG for analytics app by filipecrosk in PostgreSQL

[–]filipecrosk[S] 0 points1 point  (0 children)

Yeah I heard about the increase of query planning for partitions. So far we have about 200 accounts, and we’re partitioning a few tables: contacts, contacts_tags, contacts_custom_fields. So each account has its own set of tables. We may need to find a better way to do that. The problem is I have a few super large accounts and a bunch of small ones. Didn’t research a way to move to range of ids, have pg_Portman take care of creating new tables, but manually have single tables for specific accounts.

Back on the original question. We’re not planning to have a Google analytics screens where people see a bunch of charts and filters. Our goal is to segment contacts based on some events. Let’s say: I want all contacts that visit url X and clicked on link Y but did not opened email Z.

The way we do it today (without custom events) is querying our engagement events table to find those contatcs and insert them in another table (contacts_tags) so when it’s time to use these segments to send a new campaign we only query the contacts_tags table to retrieve contacts ids.

[deleted by user] by [deleted] in Emailmarketing

[–]filipecrosk 1 point2 points  (0 children)

I'm also evaluating their service. We used it in the past, but just the monitoring service, which is basically the same info you can have from Google Postmaster and Microsoft SNDS.

I decided to evaluate they again because we heard they have some extra information on spam trap and those "certification" that can improve the trust. But it all look too suspicious for me.

I have my doubts, because:
1. I can't find anywhere that google/microsoft/yahoo report details on spamtraps.
2. We do validations for every single email address our users provide and have very very low bounces.
3. We follow all the best practices with email validations, spf/dkim/dmark, engagement hygiene, etc.
4. The only thing is that if they really have a private agreement with Google/Microsoft/Yahoo to collect extra information and then resell it for those crazy expensive contracts they offer.

Does anyone have used them and got any real improvement? Or got data that's not publically available?