jarulraj

10 ms·

1. 61.▲
   by jarulraj 3y ago

   Got it! EVA is designed for the local use case. You can define a Python function that wraps around the LLM model and use it anywhere in the query (we refer to such functions as user-defined functions or UDFs). This notebook illustrates a UD
2. 62.▲
   by jarulraj 3y ago

   Great question! We will be adding a ChatGPT-based user-defined function this week ( https://github.com/georgia-tech-db/eva/pull/655/ ). With LLM-based functions, EVA will support more interesting queries l
3. 63.▲
   by jarulraj 3y ago

   Thanks! Likewise :) Thanks for the suggestion! I just added links to the demo applications earlier in the README. All applications are Jupyter notebooks that you can open in Google Colab. * Examining the emotion palette of actors in a movie
4. 64.▲
   Show HN: EVA – AI-Relational Database System(github.com)

   237 points by jarulraj 3y ago|36 comments
5. 65.▲
   by jarulraj 9y ago

   Thanks for the suggestion. I unfortunately don't, but this tool can certainly be integrated with ORMs and in other BI stacks.
6. 66.▲
   by jarulraj 9y ago

   Sure :) Any other interesting suggestions? I must mention that I greatly admire your pragmatic books on improving database performance, and they were a source of inspiration for the development of this tool.
7. 67.▲
   by jarulraj 9y ago

   By design, the tool is dialect-agnostic.
8. 68.▲
   by jarulraj 9y ago

   Can you please open an issue or send a PR to update the documentation? Thanks!
9. 69.▲
   by jarulraj 9y ago

   Thanks for sharing these interesting anecdotes.
10. 70.▲
    by jarulraj 9y ago

    Thanks for sharing your perspective. I will add a new check to ensure that table columns are always be prefixed with table name. However, I still think that it is worthwhile to not use a generic primary key name (at least in the common case
11. 71.▲
    by jarulraj 9y ago

    I agree that executing fewer SQL queries is often better for performance. However, it is possible that an elaborate SQL query that has to use many joins, correlated subqueries, and other operations can be harder for the SQL engine to optimi
12. 72.▲
    Show HN: SQLCheck – Automatically identify anti-patterns in SQL queries(github.com)

    61 points by jarulraj 9y ago|26 comments
13. 73.▲
    by jarulraj 9y ago

    LMDB is a highly-optimized storage engine. However, it is not a full-featured DBMS (e.g., no support for query optimization). This talk focuses on the potential impact of NVM on different layers of a full-featured DBMS -- not only the sto
14. 74.▲
    by jarulraj 9y ago

    That's correct, the DBMS will rely on replication to survive media failures. The "NVM Express over Fabrics" standard is a step along that direction. http://www.nvmexpress.org/wp-content/uploads/NVMe
15. 75.▲
    by jarulraj 9y ago

    Meta-observation: LMDB is a highly-optimized storage engine. However, it is not a full-featured DBMS (e.g., no support for query optimization). This talk focuses on the potential impact of NVM on different layers of a full-featured DBMS -
16. 76.▲
    by jarulraj 10y ago

    Any war stories on the SQL Server Database Engine Tuning Advisor? How significantly has it affected the performance of the system?
17. 77.▲
    The data chatbots are coming(wp.sigmod.org)

    1 points by jarulraj 10y ago|0 comments
18. 78.▲
    by jarulraj 10y ago

    Thanks for the shout-out!
19. 79.▲
    by jarulraj 10y ago

    Thanks :) We believe that non-volatile memory (NVM) will be a game-changer for database management systems [1]. [1] https://www-ssl.intel.com/content/www/us/en/architecture-and...
20. 80.▲
    by jarulraj 10y ago

    That's correct! This is the reason why we support both OLTP and OLAP workloads in Peloton.
21. 81.▲
    by jarulraj 10y ago

    We certainly do :) There happens to be an autonomous mechanism for supporting hybrid workloads (OLTP & OLAP). Peloton supports hybrid storage layouts that are automatically and dynamically adapted over time based on the workload pattern
22. 82.▲
    by jarulraj 10y ago

    Great question! There happens to be an autonomous mechanism for supporting hybrid workloads (OLTP & OLAP). Peloton supports hybrid storage layouts that are automatically and dynamically adapted over time based on the workload patter
23. 83.▲
    Interstellar Database Systems(jarulraj.blogspot.com)

    2 points by jarulraj 10y ago|0 comments
24. 84.▲
    by jarulraj 10y ago

    There is on-going conversation on the pg-hackers mailing list. Thanks for the positive feedback.
25. 85.▲
    by jarulraj 10y ago

    I see, thanks for sharing this information.
26. 86.▲
    by jarulraj 10y ago

    * It is a proof-of-concept implementation to show that porting Postgres over to C++ is feasible with minimal changes. It is not official. * We need to refactor the increment operator because the variables are of enumeration type. * We have
27. 87.▲
    by jarulraj 10y ago

    Whoa, why would you do that ?
28. 88.▲
    by jarulraj 10y ago

    Certain features of the C++ language and its library should help simplify coding, improve code reuse, and avoid bugs. Here's a blog post that provides more context: https://petereisentraut.blogspot.com/2013/05&#x2F
29. 89.▲
    Show HN: C++11 port of Postgres(github.com)

    4 points by jarulraj 10y ago|11 comments
30. 90.▲
    Self Tuning Databases(c2.com)

    2 points by jarulraj 10y ago|0 comments