Questions tagged [slashdb]

SlashDB automatically generates REST APIs to databases and other data stores. Questions pertaining to the use, configuration, installation and integrating with SlashDB should use this tag. You can also use this tag if your question mentions or contains some other reference to SlashDB or its website.

SlashDB automatically generates REST APIs to databases and other data stores.

Questions pertaining to the use, configuration, installation and integrating with SlashDB should use this tag.

You can also use this tag if your question mentions or contains some other reference to SlashDB or its website http://slashdb.com/

19 questions
4
votes
2 answers

Update data using SlashDb

I am writing a new API to update a row in a table (database is oracle) using Slash Db. I have chosen the method PUT when creating the API. I still get an error: {"http_code": 405, "description": "This method is not allowed for query:…
2
votes
2 answers

Cloud SlashDB VM can't connect with Azure SQL DB

I set up a SlashDB instance in Azure following the instructions here. I set up an Azure DB which I can access just fine from SSMS using the server admin account. The DB server firewall seems to be properly connected to the SlashDB server vnet…
2
votes
2 answers

Reading JSON data that begins with [ and ends with ]

I'm using Java with a plugin for NetBeans called CODAPPS to retrieve, parse, and display JSON data. I'm following an example that used JSON data produced by Google's Firebase database, but I'm using SlashDB instead. For some reason the JSON data…
Hack-R
  • 22,422
  • 14
  • 75
  • 131
2
votes
2 answers

Wrap SQL Server Objects Quickly?

Back in the MSSQL 2000 timeline, there was an IIS integration layer that allowed HTTP GET commands to make select statements, and there were other SqlXml niceties that worked (not that fast or well but they worked) out of the box. I gave a chance to…
Snowy
  • 5,942
  • 19
  • 65
  • 119
1
vote
1 answer

UTF8 Error in SlashDB using SQL Server

I am using SQL Server with SlashDB. It has been working fine. Error happened today that may be saying I have the wrong database charset defined. I get this error: ValueError | 'utf8' codec can't decode byte 0xa0 in position 183: invalid start…
David B.
  • 13
  • 2
1
vote
2 answers

slashDB accessing a database via POST request and using APIkey yields 403 error

Question about security for POST method of HTTP: I made a user called "MyAPP": { "userdef": [ "view", "create" ], "api_key": "dzn8k7hj2sdgddlvymfmefh1k2ddjl05", "user_id": "MyAPP", "name": "MyAPP", "creator":…
ElliotB
  • 153
  • 2
  • 8
1
vote
2 answers

SlashDB: Is it possible to to return HTTP error code from SQL Pass-thru?

In SlashDB, whenever a pass-through query can be executed, the HTTP code returned is always in the 200-class (OK, Created, etc.). Unfortunately, this doesn't account for cases when an error should be returned, such as: item doesn't exist in a table,…
1
vote
1 answer

SlashDB doesn't commit transaction after executing a stored function in MySQL

I have a SlashDB installation on top of MySQL 5.7. I use it to serve custom REST API calls to allow other people to access the data in the DB. Most of these happen through the 'SQL Pass-thru' feature. When executing straight SQL queries, changes to…
1
vote
1 answer

SlashDB returns 502 on long URL

I'm using SlashDB to layer a REST interface over MySQL back-end. Mostly, I define queries through the 'SQL Pass-thru' feature. We're using this system to record test data from various test station. When sending test data into the database, it seems…
1
vote
1 answer

How do we do User session management in SlashDB?

User Session Management- - How do we maintain the user sessions by using only SlashDB? - Is there any other resources required for that or only SlashDb is sufficient?
1
vote
1 answer

After successful connection with local mysql database in SlashDB, not able to see the database tables and all?

Configured the mysql database related changes and connection established successful but still not able to see the tables from that Db for further operation??
1
vote
1 answer

Text substitution in MySQL SQL Pass-Thru

I am using SlashDB for a REST API (SQL Pass-thru) for MySQL. This allows you to write a SQL query where your parameters (to be replaced by user text) are preceeded by :. For example: select * from mydb where name = :name; would work fine, assuming…
Hack-R
  • 22,422
  • 14
  • 75
  • 131
1
vote
1 answer

SlashDB connection string for MySQL over SSH

I'm trying to have my SlashDB REST API query a MySQL database, which it must connect to over SSH. The connection string isn't successful and I can't say I'm surprised, because SlashDB has a place in its template for the DB username and password, but…
Hack-R
  • 22,422
  • 14
  • 75
  • 131
1
vote
1 answer

make a slash db rest api call from a c# application

We have exposed our sql server db behind slashdb(slashdb.com). Within their site we were able to create queries and get the data from their generated URLs. But not from outside like from a C# application. Now we would to use those URLs in your c#…
APeter
  • 21
  • 1
  • 4
0
votes
1 answer

Unable to create new database

When I create a new mysql db, slashdb's test connection fails. Here is how I log into mysql: $ mysql -u 7stud -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 15 Server version:…
7stud
  • 46,922
  • 14
  • 101
  • 127
1
2