Hi

I've got some street mapping data (X, Y coordinates for street names) in my own table (but it's in the Drupal database, with a different table prefix, and a different database user who can only access that table). [There are over 38,000 records].

1. Can I use Drupal 8's autocomplete functionality with my own database table?
2. Do I use PHP PDO, or does Drupal have something like that? (obviously I'm using my own database table as mentioned above)

Having internal / external databases is explained here for Drupal 7 (https://drupal.stackexchange.com/questions/167569/how-can-i-setup-multip...). Also dependency injection... obviously a lot to know!

Thanks :-)
Mike

Comments

Jaypan’s picture

1) Yes you can.

2) Drupal has a full Database API. It hasn't really changed since D7, so the documentation is still relevant for D8: https://www.drupal.org/docs/7/api/database-api/database-api-overview