Thread: Info regarding integrating a barcode reader with PostgreSQL
Hi, I'm looking for details on how to integrate a barcode reader (e.g. one from Symbol) with a PostgreSQL database. Currently I use PostgreSQL 7.1.2 as the backend and psql, pgaccess, pgAdmin v7.1.0 (on Windows), phpPgAdmin as the frontend(s). The backend, a couple of the frontends, and the PHP enabled web server run on a Linux workstation. I'm new to the details of barcode readers so I'm also looking for hints on how to get a barcode reader hardware working on a Linux system. Any help would be appreciated. Thanks, Deric Sullivan Deric.Sullivan@ec.gc.ca
This is definitely not a pgsql question. Barcode readers usually have a keyboard interface, where they plug in between keyboard and host. When a reader scans a barcode, it sends 'keystrokes' to the host... Alternatively, they can be connected as serial device, outputting data when they see a barcode. On Mon, 9 Jul 2001, Sullivan,Deric [CMC] wrote: > Hi, > > I'm looking for details on how to integrate a barcode reader (e.g. > one from Symbol) with a PostgreSQL database. Currently I use PostgreSQL > 7.1.2 as the backend and psql, pgaccess, pgAdmin v7.1.0 (on Windows), > phpPgAdmin as the frontend(s). The backend, a couple of the frontends, and > the PHP enabled web server run on a Linux workstation. I'm new to the > details of barcode readers so I'm also looking for hints on how to get a > barcode reader hardware working on a Linux system. Any help would be > appreciated. > > > Thanks, > Deric Sullivan > Deric.Sullivan@ec.gc.ca > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://www.postgresql.org/search.mpl > >
What kind of interface do your barcode readers use? If they are a "keyboard wedge" style there shouldn't be anything specail about connecting them and making them operational - they fit between the keyboard and the I/O socket on your computer. We've used ID Tech barcode/magcard readers for a couple of years that have this interface with no problems - they have connectors for both 5-pin DIN and 6-pin mini-DIN connectors. You may have some issues pertaining to configuring which barcode patterns they recognize, but those issues should be covered in any manuals that are supplied. Good luck! "Sullivan,Deric [CMC]" wrote: > Hi, > > I'm looking for details on how to integrate a barcode reader (e.g. > one from Symbol) with a PostgreSQL database. Currently I use PostgreSQL > 7.1.2 as the backend and psql, pgaccess, pgAdmin v7.1.0 (on Windows), > phpPgAdmin as the frontend(s). The backend, a couple of the frontends, and > the PHP enabled web server run on a Linux workstation. I'm new to the > details of barcode readers so I'm also looking for hints on how to get a > barcode reader hardware working on a Linux system. Any help would be > appreciated. > > Thanks, > Deric Sullivan > Deric.Sullivan@ec.gc.ca > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://www.postgresql.org/search.mpl -- John Burski I.T. Manager and Systems Administration 911EP First in LEDs... The solid state warning light leader. 1-800-863-6911