search

AzouKr / sqlite-gui-node

sqlite-gui-node is a Node.js package that provides a user-friendly graphical interface for performing CRUD operations on SQLite databases. It simplifies database management tasks by allowing users to interact with SQLite databases through a web-based GUI.
https://www.npmjs.com/package/sqlite-gui-node
17 stars 5 forks source link

ID as a string is not supporting #8

Open ecSpl01t opened 3 days ago

ecSpl01t commented 3 days ago

Hi there! I'm just started to use your package and faced the problem related to that route /getrecord/:tablename/:label/:id. Inside of that route, you're expecting id as a number. Could you add support id as a string (fetchRecord(db, tablename, label, Number(id)))? Maybe just check it if that id is defined, perhaps this will be enough.

if I removed Number constructor, I needed also fix in some functions of databaseFunctions/sqlGenerator ${label} = ${id} by wrapping {$id} -> "${id}"

Also, I cannot save data as json.

ecSpl01t commented 3 days ago

Please don't use everywhere vh units in css, because it breaks many things with a lot of data.

"Avoid overusing vh units unless you're designing something that specifically requires them, and ensure you account for potential viewport height changes, especially on mobile devices. If you're targeting flexible layouts or components that should adjust based on content, use relative units like em, rem, %, or auto to ensure better consistency and adaptability."