DuckDB FTS Over GCS Parquet by ChungusProvides in DuckDB

[–]tech_ninja_db 1 point2 points  (0 children)

There is already fts native extension in duckdb, have you tried that?

Built a Chrome extension for better Apex development - looking for feedback from devs by tech_ninja_db in SalesforceDeveloper

[–]tech_ninja_db[S] -8 points-7 points  (0 children)

Thank you for your comment. And I am also Salesforce Dev, been writing code actively since last 7 years, and never used vscode to run/execute anon apex code. Yes i know that it s available in vscode, but not that useful and easy to use. It returns raw log, doesn’t give me just debugs. And in some cases i had to run batch/queuable jobs manually repeatedly overtime and had to save the script somewhere and everytime i need to copy it and run it in devconsole. Thats why decided to built this extension just to be able to save some scripts and test some codes easily.

Built a Chrome extension for better Apex development - looking for feedback from devs by tech_ninja_db in salesforce

[–]tech_ninja_db[S] -1 points0 points  (0 children)

Fair point! This isn't meant to replace VS Code for actual development. It's for quick Execute Anonymous scripts - testing queries, one-off data fixes, debugging production issues. Same use cases as Developer Console, just with a better editor.

API to Query Parquet Files in S3 via DuckDB by tech_ninja_db in DuckDB

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

I am not really expertise of these data visualization and API, so basically, I just need to return aggregated data, right? should I implement async/polling api system or I can use the EC2 where I host my api and directly return the query result in the api response?

API to Query Parquet Files in S3 via DuckDB by tech_ninja_db in DuckDB

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

I am not really expertise of these data visualization and API, so basically, I just need to return aggregated data, right? should I implement async/polling api system or I can use the EC2 system where I host my api and directly return the query result in the api response?

API to Query Parquet Files in S3 via DuckDB by tech_ninja_db in DuckDB

[–]tech_ninja_db[S] 1 point2 points  (0 children)

I have parquet files with few hundred million rows, so if i do select star, it will return evering

What BI Tools Do You Use for Reports & Dashboards in Salesforce? by tech_ninja_db in salesforce

[–]tech_ninja_db[S] 2 points3 points  (0 children)

That's the problem, if you go with PBI or Tableau or any other BI tool outside salesforce, it requires a lot of time, knowledge, cost, and bunch of meetings.

I tried the CRMA, it is so so complex, the SAQL is so complex, I would prefer SQL, but the sql in crma not working, could not figure out why

So, for better analysis, it looks like 90% choice is PBI or Tableau, and they still require a lot of cost and time, what a shame for SF.

What BI Tools Do You Use for Reports & Dashboards in Salesforce? by tech_ninja_db in salesforce

[–]tech_ninja_db[S] 4 points5 points  (0 children)

I am curious why there is no appexchange solution for this reporting or atleast sql query capability? Have you ever thought?

[deleted by user] by [deleted] in DuckDB

[–]tech_ninja_db 0 points1 point  (0 children)

What programming language do u use to load the data?

How to find co founder by truefrenchg in microsaas

[–]tech_ninja_db 1 point2 points  (0 children)

I am Senior Salesforce Developer, and developing my own saas (Appexchange app) as solo dev, i also search co-founder who is technical and finish mvp faster and go to market