Skip to main content

Making vanilla web-fontend (project with lit, web component) secured (discussions with chatGpt)

Query: I wn complete seperate .css/.scss and .html template file for my webcomponent.js like in angular. But with complete security. In lit. Use any js lib like domPurify, etc. But I wan complete safety. How? ChatGPT said: Thought for 16s Totally doable. Here’s a secure Lit setup with fully separate .html + .scss files , sanitized with DOMPurify , and rendered into the Shadow DOM without sacrificing performance. Folder layout src / lib/ safe- html .js components/ app-shell .html app-shell .scss app-shell .js 1) Install deps npm i dompurify npm i -D sass Vite will compile .scss . We’ll import the compiled CSS as text and attach it via adoptedStyleSheets (fast + memory-friendly). 2) app-shell.html (pure template file) Put your Carbon UI Shell markup here (no scripts). Example stub: < cds-header aria-label = "My App" > < cds-header-name prefix = "IBM" >[Platform] </ cds-header-name > < cds-header-glo...
Post a Comment

Series: My Database Concepts - JDBC vs JPA / Hibernate

Lot of times questions arise in mind that what to use pure JDBC or JPA/Hibernate.

Well, if performance is compared JDBC is much faster and uses less memory than Hibernate.

But if you plan to work safely, in a less error prone manner while writing Database code, you will need to you Hibernate.

So, finally in my opinion, if you are confidence enough that if you can write JDBC codes properly, have good knowledge of JDBC, you should use JDBC.
Also, if you think you will be able to learn SQL / JDBC properly if you don't know yet, and want to create some JAVA Database project, in this case also you can use JDBC.

But if you don't want to waste too much of time in learning JDBC and writing proper codes and spend time upon testing those codes, use JPA/ Hibernate. But in this case you will need few byes of memory extra, and also performance will be downgraded by a bit in comparison with JDBC.

Note: when these points are considered, following points are important to note:
1> In JDBC you can use DBCP or any other .jar file for connection pooling.
2> You are always using prepared statements / callable statements while using JDBC.
3> When using JPA / Hibernate, it also converts JPQL / HQL to relevant SQL codes for executing SQL statements.

Comments

Post a Comment

If you have any doubts, please let me know.

Popular posts from this blog

Ubuntu Notes: Set up autossh as systemd useful-reminder commands

 sudo vim /etc/systemd/system/permanentAutossh.service ======================================== [Unit] Description=Keeps a tunnel to myOciFreeNat open After=network-online.target [Service] User=<username> Environment="AUTOSSH_GATETIME=0" ExecStart=/usr/bin/autossh -M 0 -q -N -o "ServerAliveInterval 60" -o "ServerAliveCountMax 3" -L 4322:127.0.0.1:5432 -i /<ssh_private_key_file_absolute_path> <username>@<ip_address> -p 22 [Install] WantedBy=multi-user.target ======================================== sudo systemctl daemon-reload sudo systemctl enable permanentAutossh sudo systemctl start permanentAutossh ================== sudo systemctl daemon-reload sudo systemctl restart permanentAutossh sudo systemctl status permanentAutossh ====================== sudo systemctl stop permanentAutossh sudo systemctl disable permanentAutossh sudo rm /etc/systemd/system/permanentAutossh.service
Post a Comment
Read more

C/C++ Postgres libpq execute query with params chatGpt example

PGresult *PQexecParams(PGconn *conn, const char *command, int nParams, const Oid *paramTypes, const char * const *paramValues, const int *paramLengths, const int *paramFormats, int resultFormat); give example ChatGPT said: ChatGPT Here’s a basic example demonstrating how to use PQexecParams in C++ to execute a parameterized query in PostgreSQL. Example: Inserting Data Using PQexecParams Let's assume we are inserting a row into a table called users with the following columns: id (integer) name (text) age (integer) cpp Copy code # include <iostream> # include <libpq-fe.h> # include <memory> # include <string> void checkResult (PGresult* res, PGconn* conn) { if ( PQresultStatus (res) != PGRES_COMMAND_OK) { std::cerr << "Execution failed: " << PQerrorMe...
Post a Comment
Read more

syslog cpp programming: learning using chatGcp

  Introduction to Syslog C++ August 27, 2024 This conversation may reflect the link creator’s personalized data, which isn’t shared and can meaningfully change how the model responds. You said: I am new to syslog in cpp programming n just starting. Can you teach me ChatGPT said: ChatGPT Sure! syslog is a standard for logging system messages in Unix-like operating systems. It provides a way to send log messages to the system log, which can then be collected and analyzed by various tools. Here's a basic guide to get you started with syslog in C++: 1. Include the Necessary Header To use syslog , you need to include the syslog.h header: cpp Copy code # include <syslog.h> 2. Open the Connection to syslog Before sending log messages, you need to open a connection to the syslog system. This is typically done at the start of your program: cpp Copy code openlog ( "your_program_name" , LOG_PID | LOG_CONS, LOG_USER); "your_program_name" : A string representing ...
Post a Comment
Read more