Remote MCP Server to access an Oracle database in Claude on iOS

Image
Think of MCP ( Model Context Protocol ) as the universal adapter for AI assistants. Just like USB-C promised to connect any device to any port, MCP lets AI models connect to virtually any data source, application, or service through a standardized protocol. Whether it's a company database, a cloud service, or a local file system, MCP bridges the gap between AI and the tools you use. The buzz around MCP isn't just hype—it's solving a real problem. Until recently, getting AI to work with your specific data and workflows meant custom integrations, API wrangling, and a lot of developer headaches. MCP changes that by creating a common 'language' that AI models can use to communicate with external systems securely and efficiently. Although MCP is relatively new (created by Anthropic in November 2024), all major players are backing the protocol.  With developers rapidly building MCP servers for everything from databases to development tools, we're witnessing the birt...
Post a Comment

Range Slider Plugin

I've spent a little time updating my online shop demo recently. I've still a long way to go but initially I am trying to get as much core functionality built into the search page, such as trying not to submit the page at all and do as much with Ajax as I can.  From hereonin I think I shall refer to this as 'Ajaxifying' my application.  Ok maybe not.

You can go to the demo here....Online Store Demo

Something to note.  You can drag and drop the product images into the shopping basket and the basket inventory will update, but this doesn't work with pagination.  If you use the range slider this will reset pagination and it will work again.  Also note, that this page only works properly with Firefox, which I think maybe down to APEX 4 EA not yet being supported in IE (it doesn't work with Chrome either).

You will notice that I have created a new plugin which I have based on Patrick Wolf's slider plugin, but this uses 2 markers on the slider to represent a range of high and low.   You can also specify default high and low values for the slider.  You can get the range slider plugin here. (let me know if this link doesn't work).  As plugins only return a single value, then the value returned will be made up of 2 values separated by a comma (ie '100,4500').  You will of course need to extract each value from the item you base on the plugin if you want to refer to them in a report Where clause.

I will post some more in the next day or so as I make other improvements.

(Thanks to Anthony for help with the live binding of the drag and drop/slider dynamic actions)

UPDATE:  One thing I forgot to mention is that I added a plugin parameter for the range slider that allows you to specify a jQuery theme from a select list.  This is not the most efficient way of applying themes to all jQuery based plugins on a page/application, but it gives you a flavour of what can be done.

Comments

Anthony Rayner said…
Hi Paul,

It's really taking shape. Looks great. By the way, 1 point of clarification, the slider item plugin is actually Patrick Wolf's, not mine. I, unfortunately cannot take credit for that one!!

Anthony.
3 February 2010 at 11:14
Paul Brookes said…
Thanks Anthony,

Post now updated.

What is great is the minimal amount of coding required, once you start using plugins.

It would be nice to get the PPR working on the Products without having to code but its working so I'm happy. Just need to fix the issue with pagination causing the drag and drop to stop working.

Paul.
3 February 2010 at 11:38
Anonymous said…
Looks like none of the online store links work?
9 August 2010 at 16:31
Anonymous said…
All tryapexnow.com links are broken.
2 February 2011 at 07:58
Anonymous said…
The link doesn't work.
26 October 2011 at 16:48
Post a Comment

Popular posts from this blog

Visualising AI Embeddings in APEX

Image
" To deal with hyper-planes in a 14-dimensional space, visualize a 3-D space and say 'fourteen' to yourself very loudly. Everyone does it."     - Geoffrey Hinton , 2018 Turing Award winner. Within the wonderful world of  Generative AI , one concept that is all the rage is RAG, or  Retrieval Augmented Generation , which is an  AI framework that combines the strengths of traditional information retrieval systems (such as databases) with the capabilities of generative large language models (LLM s) . RAG's goal is to improve the accuracy, relevance, and timeliness of information  generation  - such as  documents, text and images -  by optimizing LLM output.  When creating a RAG system, it’s essential to store information in a format that a LLM can retrieve. This is where  data is converted into embeddings through a pro...
Read more

Remote MCP Server to access an Oracle database in Claude on iOS

Image
Think of MCP ( Model Context Protocol ) as the universal adapter for AI assistants. Just like USB-C promised to connect any device to any port, MCP lets AI models connect to virtually any data source, application, or service through a standardized protocol. Whether it's a company database, a cloud service, or a local file system, MCP bridges the gap between AI and the tools you use. The buzz around MCP isn't just hype—it's solving a real problem. Until recently, getting AI to work with your specific data and workflows meant custom integrations, API wrangling, and a lot of developer headaches. MCP changes that by creating a common 'language' that AI models can use to communicate with external systems securely and efficiently. Although MCP is relatively new (created by Anthropic in November 2024), all major players are backing the protocol.  With developers rapidly building MCP servers for everything from databases to development tools, we're witnessing the birt...
Read more

Fun with Bubbles!

Image
I'm on a train up to Liverpool for the UK Oracle User Group Tech 14 conference, and decided it's about time for a post showing something I've been working on.  I don't post often these days, which I blame on work and family commitments, but is probably just down to pure laziness.  Anyhow, I'm feeling in the mood so I'll just get on with it in case the desire to catch some zzz's becomes overwhelming.  Also it takes my mind of the bad coffee served up on the train. So, I've been getting into  D3  a little, which if you don't already know is a JavaScript library for manipulating data to create interactive graphs and charts.  Some of the stuff people are creating using D3 is amazing, including this dynamic bubble chart example.  I thought I would use this example as the basis for creating a bubble chart in Apex, that dynamically updates with some cool transitions, using data from the database rather than the real time API in the example. The demo ca...
Read more