top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Need guidance for a simple search Rails application

0 votes
218 views

I am learning Ruby. In the meantime, I have to make a simple app for a small company that I know how to make in PHP and MySQL. I have not started learning Rails yet (first I want to finish the Ruby book I have started). But I was thinking if with a little guidance may be I can make this app in Rails. If I can do it, that will be great. The requirement is like this:

  • I am given an Excel file that has 11 columns. Each row has information about one item. Each row is unique. Right now the company uses this excel file to search for required information, and they want me to make a web app for this.

  • This Excel data and future data will be inserted into the database in bulk, using CSV imports. I think there is no need to break the table, and our app can just have a single table to search from.

  • The search will be done using 2 columns from the table.

  • One person will have the privilege to edit searched records.

  • Only 4 people will be using the app for now. There will be no option to sign-up for a new account.

  • The home page will have the search form (two fields, user can fill both or one).

I will appreciate (a lot) any pointers, guidance and help with this. I can make this in PHP, but I'd love to make it in Rails.

posted Jul 15, 2013 by anonymous

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote

I didnt exactly get your question. Are you looking for a way to search for the records ? If the number of rows is huge and you need full text search, you may need to look at Solr or Sphinx or AWS CloudSearch for fast queries. If time is not a big concern, you may even be able to do away with simple ActiveRecord queries (do look at squeel gem too : https://github.com/ernie/squeel).

answer Jul 15, 2013 by anonymous
Similar Questions
+1 vote

I've plan to develop own Rails app based on very simple concepts like Student mark sheet, where we can do:

  1. Add a new marks(m1,m2,m3) of a student,
  2. Delete a existing marks of a student,
  3. Edit any existing mark(s) of a student,
  4. List of students mark in a view.

please give me steps/references to do that above,and it should query with sqlite.

+2 votes

I have a table with several thousand records in it. They take a long time to load and are essentially useless presented altogether.. I'd like present the user a search form to select a limited subset of records for display in the index function. What options are available to solve this problem and where might I look for examples or demos?

+2 votes

I need to generate few basic reports in rails (generated on the basis of some SQLs fired on MySQL) which can be viewed in HTML5 and then if a user wants, he should be able to download a pdf file for the report. Can someone suggest a gem for this requirement?

+2 votes

I need an Idea of how to put a google map in my application, I have field and I want to fill it with address and I want a map in the next line showing the address that I entered in my field......

0 votes

I have built a rails application with jruby. Since I have no experience with deploying a rails application in a production environment, I have spent some time doing a manual deployment on a linux server with tomcat6 as application server.

In essence, I have made a war file of the rails application with help of the warbler gem and deployed that on the linux server. I managed to get it up and running, but not yet exactly as I need it to be.

I have still some configuration issues. I hope you can help me or point me to the right place, since it may be a tomcat question. But I assume there must be some rails/tomcat expertise among the members of this group...

The point is, the URL in the development server is localhost:3000/invoices (using rails server)
The URL in the tomcat production environment is localhost:8080/rails/invoices

I can't seem to figure out how I can change the port and the document root (/invoices instead of /rails/invoices) in tomcat.

Any suggestions?

...