Hey everyone,
I’m part of a team working on a photo library project. We’re using Oracle for the database and Java for coding. I’m wondering if it’s possible to create something like an online store for images with these tools.
Here’s what we need:
- Search by keywords and metadata
- A way to ‘buy’ images (no real money involved)
- Groups of photos managed by an admin
- Word clouds for searching
- Something to read image info and put it in the database
- A website for managing everything
I’m used to working with stuff like PHP and MySQL, so I’m not sure how hard this would be with Oracle and Java. Has anyone done something similar? Any tips or ideas would be great!
Thanks for your help!
hey sophie, oracle & java can do it! might be tricky if you’re used to php/mysql though. try spring or jsf for the site, and apache commons imaging for photo data. word clouds sound cool, are they dynamic? how’s ur team handling it? good luck!
Your project sounds feasible with Oracle and Java, though it may require some learning if you’re used to PHP/MySQL.
For the search functionality, Oracle Text can handle keyword searches efficiently. You could implement a token system for ‘buying’ images without real money involved, and admin management of photo groups can be set up using user roles and permissions in Oracle.
For word clouds, consider using a Java library like WordCloud4J. To read image info, Apache Commons Imaging is a solid choice for extracting metadata. As for the website, a framework like Spring or Play could streamline development.
The main challenge might be the learning curve, especially if you’re new to Oracle and Java web development. It’s doable, but expect to invest time in getting familiar with these technologies. Consider starting with a small prototype to test the waters before diving into full development.
Hey Sophie26! That’s a cool project you’re working on! 
I’ve actually dabbled with something similar before, though not exactly the same setup. Oracle and Java can definitely handle what you’re looking to do, but there might be a bit of a learning curve if you’re used to PHP and MySQL.
Have you considered using any specific Java frameworks for the web part? Something like Spring or JavaServer Faces could make your life easier when it comes to building the website and connecting it to Oracle.
For the image info stuff, there are some neat Java libraries out there that can read metadata from photos. I think Apache Commons Imaging is one? Might be worth checking out.
Oh, and for the word clouds - that sounds fun! Are you thinking of generating those on the fly or pre-generating them? I’d be really curious to see how that turns out.
How big is your team? It sounds like a pretty ambitious project. Do you have a timeline in mind for getting it all up and running?
Good luck with everything! Keep us posted on how it goes!