But, the person can read all rows from the table. You could try to use a view but probably, you would just implement some filtering in your proxy. “Just implement some filtering” becomes a problem when the HTTP Plugin is your proxy. There’s no script language, you can’t do that. Unless, there was a script language built-in to the proxy…
Selecting records that need to be ranked, but the column(s) you're attempting to ORDER BY are not unique. SQL ROW_NUMBER() explained, and mimicked in MySQL
The DBacesslayer aka DBSlayer aka Släyer is a lightweight database abstraction layer suitable for high-load websites where you need the scalable advantages of connection pooling. Written in C for speed, DBSlayer talks to clients via JSON over HTTP
Sick of ORM and schemas? select gets right to the point!
Supported databases:
MySQL MongoDB Planned: PostgreSQL, SQLite, CouchDB Researching: Riak, Redis, selector language
The MySQL Cluster team are working on a new NoSQL JavaScript connector for MySQL. The objectives are simplicity and high performance for JavaScript users:
- allows end-to-end JavaScript development, from the browser to the server and now to the world's most popular open source database
- native "NoSQL" access to the storage layer without going first through SQL transformations and parsing.
Column, index, and stored routine names are not case sensitive on any platform, nor are column aliases. Trigger names are case sensitive, which differs from standard SQL.