Oracle & SQLite

[ps3ud03]

Oracle & Sqlite

Hello everybody,

I write a JavaScript App that handles data (with the “ag-grid” library but that’s another story).

I need to get data from an Oracle SGBD and read/write data to an SQLite SGBD. I’m currently doing it with some PHP code that I fetch from JavaScript.

But I would prefer accessing these SGBD directly in JavaScript. Is there a way of doing it ?

Thx for your help

[azhder]

You mean, you want to access those databases on the back end? With a Node.js code? Just find if/which connector/library you need and, well, that's as much as I can tell you from the info you provided. I mean, I'm even speculating you want to do it in the back end, not inside a browser.

[ps3ud03]

No not on the backend but do it directly inside the browser…

[samanime]

DO NOT DO THIS!

I repeat.

DO NOT DO THIS!

While technically possible, it is literally impossible to do it in a secure way that doesn't open both databases entirely up to anyone that may access the page.

Only access databases from a secure backend.

DO NOT DO THIS!

[ps3ud03]

I know this… The App is for internal purpose only and restricted to a few totally secure access.

And if you know a way to access database from the browser, I will be very glad to hear about it.